Update a table and then insert in another table

[lfelipeas]

I have a situation that when I include an object I first have to update this Sequence table (that controls the sequences) and then include the object in his proper table.
I want to know how I do this. I'm thinking in overriding the persist method and then do it there, but what do I use?

To make things more clear, an example:

Let's say I'm trying to include an object in the Control Table. This table has a sequence that is his PK.
I have another table called SEQ table that controls all the sequences of the database. This table has 2 fields, one called TABLENAME and other called LASTVALUE.

So, to include the object in the Control table I have to update the field that references the Control table in the SEQ table and then insert the new object in the Control table.

What can I use to do this query?

Thanks for your help!

[marcio.dantas]

Do you really have to control the ID generation?

What you're doing is really similar to a database sequence or auto-increment ID..

[lfelipeas]

I know, but this is how they created here. I have to control the ID generation.

My problem now is how to insert the value that I updated into the new object. For that only field.

Example: I created the object and now I'm going to insert it in the Control Table. I've already updated the SEQ Table to control the last value. Now I have to get this value from the LASTVALUE field that is in the SEQ table, put it in the referenced field of the control object and insert it with all the other fields that this control object has.

[rogermorituesta.rogermori.yahoo.com]

Hi Luiz:

The semantics of GenerationType.TABLE fits your requirement.

Roger.

[lfelipeas]

Really Helpful! Thank you!

Now I have another doubt. And if I have a compositeID. How do I use the GenerationType.Table?

I'm searching but until now I have found nothing.