Last Register

tads · **Posted:** Tue Nov 04, 2003 2:34 pm

Hi all,

I have a table that uses sequences (Oracle) in the
column id.
When I insert into database, I need to know this column id,
into session

Code:

   Transaction tx = null;
   Session session = null;

   session = factory.openSession();
   tx = session.beginTransaction();
        
   // this object has an Id that
   // uses sequence
   obj1.setName("blablabla");
     
   session.save(obj1, session);

   // After, I need the Id of obj1, where I will use in another obj
           
   obj2.setValue(1);
   obj2.setAddress("St. 10");

   obj2.setObj1(obj1);

   session.save(obj2, session);

How can I know the last identification (obj1) inserted into database?

Thanks!!!!

[]

micho2001 · **Posted:** Tue Nov 04, 2003 2:48 pm

Quote:

When I insert into database, I need to know this column id,
into session

Are you mapping this particular with hibernate?

Cause if so, it would be already set for you!

tads · **Posted:** Tue Nov 04, 2003 2:55 pm

Yes, I am, or I think... :-)

The mapping is the following:

Code:

<hibernate-mapping>
    <class name="Obj1" table="obj1">
   <id name="idObj1" column="id_obj1">
      <generator class="native">
         <param name="sequence">seq_obj1</param>
      </generator>
   </id>
   <property name="name" column="name"/>
   <bag name="Obj2" inverse="true" lazy="true">
      <key column="id_obj1"/>
      <one-to-many class="Obj2"/>
                </bag>
    </class>
</hibernate-mapping>

micho2001 · **Posted:** Tue Nov 04, 2003 3:25 pm

is the sequence column de one mapped by id?

cause if so, then you look all set to go! It should work. I do this all the time with mysql and MS SQL server and it works fine. After I insert a new object to the DB it gets its id assigned by hibernate.

For this to work properly you must set the dialect property in you hibernate.cfg.xml file (or properties file), in your case the Oracle Dialect.

hope it helps

tads · **Posted:** Wed Nov 05, 2003 12:34 pm

Sorry,

I found the problem... It