Hello Troy,
because, actually, it is against the spec. As synchronization before
a finder won't occur with sync-on-commit-only. There are really
controversy between non-null FK and the spec.
alex
Monday, August 04, 2003, 4:26:58 PM, Troy Poppe wrote:
> Alex,
> Thanks for the response. This looks like this will provide what I need, and
> solve my problem. Is there a reason that one would want to leave the container
> in the default setting (not sync-on-commit-only)? Is there a performance
> benefit. It seems very odd to me that the specification would ignore the
> benefits of a NOT NULL foreign key.
> Perhaps I am missing something!
> Thanks
> Troy
> ---
> Date: Sat, 2 Aug 2003 16:31:57 +0300
> From: Alexey Loubyansky <[EMAIL PROTECTED]>
> Organization: JBoss Group, LLC
> To: "Poppe, Troy" <[EMAIL PROTECTED]>
> Subject: Re: [JBoss-user] CMR remove results in UPDATE? (which fails because of
> NOT NULL c onstraint)
> Reply-To: [EMAIL PROTECTED]
> Hello Troy,
> by default, JBoss follows the spec strictly. By the spec, before
> entity instance is removed physically, all the relationships the
> instance participates in must be destroyed. You can treat it
> differently. But there are two things: destroying relationships in
> object model and in the data store. By default, JBoss destroys
> relationships in both: object model and data store.
> You can turn on sync-on-commit-only in container configuration and
> relationships will be destroyed in object model only and on commit
> only DELETE should be executed.
> alex
> Friday, August 01, 2003, 8:36:12 PM, Troy Poppe wrote:
PT>> Hello,
PT>> I have defined a bi-directional one-to-many CMR between two EJBs,
> PerformancePlan
PT>> and AssignedPerformanceElement. In my database, the FK field
> (PerformancePlanID)
PT>> in AssignedPerformanceElement is defined as NOT NULLable.
PT>> In my code, I am trying to remove an AssignedPerformanceElement from a
PT>> PerformancePlan, and I make my ValueObject (from XDoclet) to reflect this.
> When
PT>> I set this value object on the PerformancePlan, it attempts to call remove()
> on a
PT>> AssignedPerformanceElement instance.
PT>> In the console log, I get the following:
PT>> 11:40:01,090 DEBUG [AssignedPerformanceElement] Executing SQL: UPDATE
PT>> ASSIGNEDPERFORMANCEELEMENT SET performancePlanID=? WHERE
PT>> assignedPerformanceElementID=?
PT>> 11:40:01,131 INFO [STDOUT] p6spy - 1059752401131|41|3|statement|UPDATE
PT>> ASSIGNEDPERFORMANCEELEMENT SET performancePlanID=? WHERE
PT>> assignedPerformanceElementID=?|UPDATE ASSIGNEDPERFORMANCEELEMENT SET
PT>> performancePlanID='' WHERE assignedPerformanceElementID='170'
PT>> 11:40:01,211 ERROR [LogInterceptor] TransactionRolledbackLocalException,
PT>> causedBy:
PT>> java.sql.SQLException: ORA-01407: cannot update
PT>> ("HR"."ASSIGNEDPERFORMANCEELEMENT"."PERFORMANCEPLANID") to NULL
PT>> First, why is JBoss trying to UPDATE to remove the
> AssignedPerformanceElement?
PT>> Shouldn't this be a DELETE instead?
PT>> What am I missing? Is there anything in the documentation (I bought the
> whole
PT>> subscription set! I highly recommend it to anyone who hasnt bought it yet.)
PT>> Thanks
PT>> Troy Poppe
PT>> -------------------------------------------------------
PT>> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
PT>> Data Reports, E-commerce, Portals, and Forums are available now.
PT>> Download today and enter to win an XBOX or Visual Studio .NET.
PT>> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
PT>> _______________________________________________
PT>> JBoss-user mailing list
PT>> [EMAIL PROTECTED]
PT>> https://lists.sourceforge.net/lists/listinfo/jboss-user
> --__--__--
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
> End of JBoss-user Digest
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
-------------------------------------------------------
This SF.Net email sponsored by: Free pre-built ASP.NET sites including
Data Reports, E-commerce, Portals, and Forums are available now.
Download today and enter to win an XBOX or Visual Studio .NET.
http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
