From: Dain S. <da...@da...> - 2002-12-30 17:27:04
|
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: jbo...@li... >> [mailto:jbo...@li...]On Behalf Of >> Jonathan.O'Co...@xc... >> Sent: Monday, December 30, 2002 6:10 AM >> To: jbo...@li... >> 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" <rod...@sb...> >> Sent by: jbo...@li... >> 21.12.2002 19:53 >> Please respond to jboss-user >> >> >> To: <jbo...@li...> >> 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 >> JBo...@li... >> 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 >> JBo...@li... >> 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 > JBo...@li... > https://lists.sourceforge.net/lists/listinfo/jboss-user |