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
