UPDATE after INSERT in CMR

mkyaj Mar 22, 2004 2:01 PM

Hi,

To put my problem with an example i have a CMR USER(1) -ADDRESS(m).
When i create an User, it will create the corresponding Addresses(say 3 different addresses for this instance) also.
It is calling
INSERT INTO ADDRESS(field1,field2,USER_FK) VALUES(?,?,?).
INSERT INTO ADDRESS(field1,field2,USER_FK) VALUES(?,?,?).
INSERT INTO ADDRESS(field1,field2,USER_FK) VALUES(?,?,?).

and after that it is again calling
UPDATE ADDRESS set USER_FK=? WHERE ID=?
UPDATE ADDRESS set USER_FK=? WHERE ID=?
UPDATE ADDRESS set USER_FK=? WHERE ID=?

How to stop updating immediately after creation?

Murali.

1. Re: UPDATE after INSERT in CMR

mkotsbak Jul 1, 2004 2:13 PM (in response to mkyaj)

Did you find any solution to this? We have the same problem with postgres, which is fast to run the INSERT statements, but takes many seconds for each UPDATE statement...
Actions
2. Re: UPDATE after INSERT in CMR

mkotsbak Jul 1, 2004 2:13 PM (in response to mkyaj)

Did you find any solution to this? We have the same problem with postgres, which is fast to run the INSERT statements, but takes many seconds for each UPDATE statement...
Actions
3. Re: UPDATE after INSERT in CMR

aloubyansky Jul 2, 2004 3:29 AM (in response to mkyaj)
<insert-after-ejb-post-create>true</insert-after-ejb-post-create>
Actions
4. Re: UPDATE after INSERT in CMR

mkotsbak Jul 2, 2004 5:49 AM (in response to mkyaj)
"loubyansky" wrote:
<insert-after-ejb-post-create>true</insert-after-ejb-post-create>

Thanks. I actually found this myself also, and it actually works :-) It speeds up our code >60X!.

Why isn't this the default?
Actions
5. Re: UPDATE after INSERT in CMR

aloubyansky Jul 3, 2004 3:41 AM (in response to mkyaj)

Because the spec says insert after ejbCreate and before ejbPostCreate.
Actions

Go to original post