Alex, I read in another recent post that sync-on-commit changes the synchronization behaviour for finders. They no longer behave as defined in the spec and so the results could be unexpected (especially in a multi-deployment environment). For now I'd sooner incur the cost and pain of modifying the database schema rather than go down that road. It would be nice, feature request :), if cascade delete on not-null fk's worked in the compliant setup.
thanks, gavin > -----Original Message----- > From: Alexey Loubyansky [mailto:[EMAIL PROTECTED] > Sent: Saturday, July 12, 2003 2:38 AM > To: Gavin Matthews > Subject: Re: [JBoss-user] CMR, cascade-delete & not-null > > > Hello Gavin, > > you need to set sync-on-commit-only to true. > > <container-configuration> > <container-name>Custom container</container-name> > <sync-on-commit-only>true</sync-on-commit-only> > > alex > > Saturday, July 12, 2003, 12:42:47 AM, Gavin Matthews wrote: > > GM> Hi, > GM> I have a database table which has a not-null foreign > key. At the moment I > GM> can't get cascade-delete to work with not-null foreign > keys, JBoss is trying > GM> to update the foreign key to null. > GM> I'm using JBoss 3.2.2RC1 and I just want to confirm if > this is the expected > GM> behaviour or a bug? Would it be possible for > JDBCRemoveEntityCommand to > GM> check for cascade delete and remove the related entities first? > > GM> thanks, > GM> gavin > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Parasoft > Error proof Web apps, automate testing & more. > Download & eval WebKing and get a free book. > www.parasoft.com/bulletproofapps1 > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > ------------------------------------------------------- This SF.Net email sponsored by: Parasoft Error proof Web apps, automate testing & more. Download & eval WebKing and get a free book. www.parasoft.com/bulletproofapps1 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
