[JBoss-user] [Persistence & CMP/JBoss] - Re: Major CMP bug with relations with JBoss 3.2.2?
Hi edikus, I think that I have the same problem. But I am using MySql DB, instead. And I have my constraints defined as ON UPDATE RESTRICT ON DELETE RESTRICT. Do you actually know how to solve this problem? Thank you View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3839380#3839380 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3839380 --- This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: Major CMP bug with relations with JBoss 3.2.2?
Hi edikus, I think while creating the FK constraint you can specify 3 categories like a) ON DELETE NO ACTION b) ON DELETE CASCADE c) ON DELETE RESTRICT. Defualt is : ON DELETE NO ACTION. So in that case it will remove the ONE and set the fk to null in MANY. In your case you can set that to ON DELETE RESTRICT. Ex: ALTER TABLE MYTABLE ADD CONSTRAINT FK_MANY_ONE FOREIGN KEY (ONE_FK) REFERENCES ONE (ID) ON UPDATE NO ACTION ON DELETE RESTRICT. Murali. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826932#3826932";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826932>Reply to the post --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: Major CMP bug with relations with JBoss 3.2.2?
I interpret unidirectional CMR as you can navigate a relationship only in one direction. Not that I can't remove the blind side if relationship still exists. I implement CMP spec, not SQL. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826579#3826579";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826579>Reply to the post --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: Major CMP bug with relations with JBoss 3.2.2?
That's not what would happen in SQL. The whole idea is that you are PREVENTED from doing certain things so that the integrity of your DB is maintained. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826577#3826577";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826577>Reply to the post --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] [Persistence & CMP/JBoss] - Re: Major CMP bug with relations with JBoss 3.2.2?
Why is this unexpected? Removing one side detroys relationships, hence, foreign keys are set to null. http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826576#3826576";>View the original post http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826576>Reply to the post --- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click ___ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user