other problem??

ice wang · **Posted:** Fri Sep 30, 2005 2:03 am

I will session.saveorupdate(entity);

because date is wrong, so rollback(), but entity.id is have a new id.

again session.saveorupdate(entity) throw exception "row is delete or update......."

example:

Code:

    //add new data
     Entity  entity = new Entity();
     entity.name = "test";

    try
    {
          // data wrong,throw exception, this is right.
           session.saveorupdate(entity);
     }
     catch
     {
           //this data is right. should is save to dataBase, but throw exception
           entity.name = "newtest";
           session.saveorupdate(entity);
      }

sergey · **Posted:** Fri Sep 30, 2005 3:41 am

Do not use a session after there was an exception. Rollback the transaction and close it.

ice wang · **Posted:** Fri Sep 30, 2005 4:06 am

NO,NO,NO..

actually is Entity.id(OID) by assign, but after rollback(),entity can't clear.

KPixel · **Posted:** Fri Sep 30, 2005 12:27 pm

Here is how sessions should be used:

Code:

ISession sess = factory.OpenSession();
ITransaction tx;
try {
   tx = sess.BeginTransaction();
   //do some work
   ...
   tx.Commit();
} catch (Exception e) {
   if (tx != null) tx.Rollback();
   throw;
} finally {
   sess.Close();
   sess = null; // This is to stress that you shouldn't use it after
}

The transaction is optionnal.

In your case:

Code:

    //add new data
     Entity  entity = new Entity();
     entity.name = "test";

    bool Failed = false;
    try
    {
        // data wrong,throw exception, this is right.
        session.saveorupdate(entity);
    }
    catch
    {
        Failed = true;
    }
    finally {
   session.Close();
    }

    if(Failed)
        try
        {
            session = sessionFactory.OpenSession();
            // this data is right. should get saved in the dataBase
            entity.name = "newtest";
            session.saveorupdate(entity);
        }
        catch
        {
            Console("Wow, It fails again!"); // handle exception...
        }
        finally {
       session.Close();
        }

KPixel · **Posted:** Fri Sep 30, 2005 12:32 pm

Here is how sessions should be used:

Code:

ISession sess = factory.OpenSession();
ITransaction tx;
try {
   tx = sess.BeginTransaction();
   //do some work
   ...
   tx.Commit();
} catch (Exception e) {
   if (tx != null) tx.Rollback();
   throw;
} finally {
   sess.Close();
   sess = null; // This is to stress that you shouldn't use it after
}

The transaction is optionnal.

In your case:

Code:

    //add new data
     Entity  entity = new Entity();
     entity.name = "test";

    bool Failed = false;
    try
    {
        // data wrong,throw exception, this is right.
        session.saveorupdate(entity);
    }
    catch
    {
        Failed = true;
    }
    finally {
   session.Close();
    }

    if(Failed)
        try
        {
            session = sessionFactory.OpenSession();
            // this data is right. should get saved in the dataBase
            entity.name = "newtest";
            session.saveorupdate(entity);
        }
        catch
        {
            Console("Wow, It fails again!"); // handle exception...
        }
        finally {
       session.Close();
        }