Re: [JBoss-user] How to INSERT after ebjPostCreate versus ejbCreate
Dain, I did a hunt on google for any problems, and the only thing I found was this: www.geocities.com/lydian_third/ admintips/pkconstraint.pdf Basically it seems that unique indexes may cause a problem with deferrable constraints. However, I think the way we use the deferrable fk constraint, then it should be OK. Ciao, Jonathan Dain Sundstrom <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 30.12.2002 17:26 Please respond to jboss-user To: [EMAIL PROTECTED] cc: Subject: Re: [JBoss-user] How to INSERT after ebjPostCreate versus ejbCreate I've had a lot of Oracle DBAs tell me that DEFERRABLE INITIALLY DEFERRED does "very bad things" to Oracle. I don't remember the details, but it was bad enough that I gave up on some code that depended on it. -dain On Monday, December 30, 2002, at 10:17 AM, Bill Burke wrote: > nice, thanks Jonathan. > >> -Original Message- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED]]On Behalf Of >> Jonathan.O'[EMAIL PROTECTED] >> Sent: Monday, December 30, 2002 6:10 AM >> To: [EMAIL PROTECTED] >> Subject: Re: [JBoss-user] How to INSERT after ebjPostCreate versus >> ejbCreate >> >> >> Rod, >> If you are using Oracle as your DB, then you can mark your CMR fk >> columns >> as DEFERRABLE INITIALLY DEFERRED. >> Oracle will only check the non-null constraints at commit time. >> Shouldn't >> be a problem for you. >> >> Other DBs may have something similar. >> >> Ciao, >> Jonathan >> >> >> >> >> "Rod Macpherson" <[EMAIL PROTECTED]> >> Sent by: [EMAIL PROTECTED] >> 21.12.2002 19:53 >> Please respond to jboss-user >> >> >> To: <[EMAIL PROTECTED]> >> cc: >> Subject:[JBoss-user] How to INSERT after >> ebjPostCreate versus ejbCreate >> >> >> Calling an entity bean CMR setter method within ejbCreate is >> prohibited. >> The >> general solution is to make CMP calls within ejbCreate and CMR calls >> in >> ejbPostCreate. That solution does not work when the CMR field maps >> directly >> to a non-nullable required column value. WebLogic resolves this issue >> by >> deferring INSERT statements. How does one specify that option in >> JBoss? >> >> >> >> >> >> --- >> This SF.NET email is sponsored by: Order your Holiday Geek Presents >> Now! >> Green Lasers, Hip Geek T-Shirts, Remote Control Tanks, Caffeinated >> Soap, >> MP3 Players, XBox Games, Flying Saucers, WebCams, Smart Putty. >> T H I N K G E E K . C O M http://www.thinkgeek.com/sf/ >> ___ >> JBoss-user mailing list >> [EMAIL PROTECTED] >> https://lists.sourceforge.net/lists/listinfo/jboss-user >> >> >> >> >> >> --- >> This sf.net email is sponsored by:ThinkGeek >> Welcome to geek heaven. >> http://thinkgeek.com/sf >> ___ >> JBoss-user mailing list >> [EMAIL PROTECTED] >> https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > --- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] How to INSERT after ebjPostCreate versus ejbCreate
I've had a lot of Oracle DBAs tell me that DEFERRABLE INITIALLY DEFERRED does "very bad things" to Oracle. I don't remember the details, but it was bad enough that I gave up on some code that depended on it. -dain On Monday, December 30, 2002, at 10:17 AM, Bill Burke wrote: nice, thanks Jonathan. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jonathan.O'[EMAIL PROTECTED] Sent: Monday, December 30, 2002 6:10 AM To: [EMAIL PROTECTED] Subject: Re: [JBoss-user] How to INSERT after ebjPostCreate versus ejbCreate Rod, If you are using Oracle as your DB, then you can mark your CMR fk columns as DEFERRABLE INITIALLY DEFERRED. Oracle will only check the non-null constraints at commit time. Shouldn't be a problem for you. Other DBs may have something similar. Ciao, Jonathan "Rod Macpherson" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 21.12.2002 19:53 Please respond to jboss-user To: <[EMAIL PROTECTED]> cc: Subject:[JBoss-user] How to INSERT after ebjPostCreate versus ejbCreate Calling an entity bean CMR setter method within ejbCreate is prohibited. The general solution is to make CMP calls within ejbCreate and CMR calls in ejbPostCreate. That solution does not work when the CMR field maps directly to a non-nullable required column value. WebLogic resolves this issue by deferring INSERT statements. How does one specify that option in JBoss? --- This SF.NET email is sponsored by: Order your Holiday Geek Presents Now! Green Lasers, Hip Geek T-Shirts, Remote Control Tanks, Caffeinated Soap, MP3 Players, XBox Games, Flying Saucers, WebCams, Smart Putty. T H I N K G E E K . C O M http://www.thinkgeek.com/sf/ ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
RE: [JBoss-user] How to INSERT after ebjPostCreate versus ejbCreate
nice, thanks Jonathan. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of > Jonathan.O'[EMAIL PROTECTED] > Sent: Monday, December 30, 2002 6:10 AM > To: [EMAIL PROTECTED] > Subject: Re: [JBoss-user] How to INSERT after ebjPostCreate versus > ejbCreate > > > Rod, > If you are using Oracle as your DB, then you can mark your CMR fk columns > as DEFERRABLE INITIALLY DEFERRED. > Oracle will only check the non-null constraints at commit time. Shouldn't > be a problem for you. > > Other DBs may have something similar. > > Ciao, > Jonathan > > > > > "Rod Macpherson" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 21.12.2002 19:53 > Please respond to jboss-user > > > To: <[EMAIL PROTECTED]> > cc: > Subject:[JBoss-user] How to INSERT after > ebjPostCreate versus ejbCreate > > > Calling an entity bean CMR setter method within ejbCreate is prohibited. > The > general solution is to make CMP calls within ejbCreate and CMR calls in > ejbPostCreate. That solution does not work when the CMR field maps > directly > to a non-nullable required column value. WebLogic resolves this issue by > deferring INSERT statements. How does one specify that option in JBoss? > > > > > > --- > This SF.NET email is sponsored by: Order your Holiday Geek Presents Now! > Green Lasers, Hip Geek T-Shirts, Remote Control Tanks, Caffeinated Soap, > MP3 Players, XBox Games, Flying Saucers, WebCams, Smart Putty. > T H I N K G E E K . C O M http://www.thinkgeek.com/sf/ > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > > > > > > --- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > ___ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] How to INSERT after ebjPostCreate versus ejbCreate
Rod, If you are using Oracle as your DB, then you can mark your CMR fk columns as DEFERRABLE INITIALLY DEFERRED. Oracle will only check the non-null constraints at commit time. Shouldn't be a problem for you. Other DBs may have something similar. Ciao, Jonathan "Rod Macpherson" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 21.12.2002 19:53 Please respond to jboss-user To: <[EMAIL PROTECTED]> cc: Subject:[JBoss-user] How to INSERT after ebjPostCreate versus ejbCreate Calling an entity bean CMR setter method within ejbCreate is prohibited. The general solution is to make CMP calls within ejbCreate and CMR calls in ejbPostCreate. That solution does not work when the CMR field maps directly to a non-nullable required column value. WebLogic resolves this issue by deferring INSERT statements. How does one specify that option in JBoss? --- This SF.NET email is sponsored by: Order your Holiday Geek Presents Now! Green Lasers, Hip Geek T-Shirts, Remote Control Tanks, Caffeinated Soap, MP3 Players, XBox Games, Flying Saucers, WebCams, Smart Putty. T H I N K G E E K . C O M http://www.thinkgeek.com/sf/ ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
Re: [JBoss-user] How to INSERT after ebjPostCreate versus ejbCreate
Hello Rod, pity, but non-null foreign keys aren't supported currently. alex Saturday, December 21, 2002, 9:53:42 PM, you wrote: RM> Calling an entity bean CMR setter method within ejbCreate is prohibited. The RM> general solution is to make CMP calls within ejbCreate and CMR calls in RM> ejbPostCreate. That solution does not work when the CMR field maps directly RM> to a non-nullable required column value. WebLogic resolves this issue by RM> deferring INSERT statements. How does one specify that option in JBoss? --- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user