4 Replies Latest reply on Mar 21, 2011 4:45 PM by lfelipeas

Update a table and then insert in another table

lfelipeas Mar 18, 2011 2:58 PM

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!

1. Re: Update a table and then insert in another table

marcio.dantas Mar 18, 2011 4:51 PM (in response to lfelipeas)

Do you really have to control the ID generation?

What you're doing is really similar to a database sequence or auto-increment ID..
Actions
2. Re: Update a table and then insert in another table

lfelipeas Mar 21, 2011 1:56 PM (in response to 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.
Actions
3. Re: Update a table and then insert in another table

rogermorituesta.rogermori.yahoo.com Mar 21, 2011 2:10 PM (in response to lfelipeas)

Hi Luiz:

The semantics of GenerationType.TABLE fits your requirement.

Roger.
Actions
4. Re: Update a table and then insert in another table

lfelipeas Mar 21, 2011 4:45 PM (in response to 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.
Actions

Go to original post