To further clarify, the following two SQL queries do what I want done: "delete from STUDENT_SUBJECT;" and "delete from STUDENT_CLASS;" The second one is not mentioned in the post, but if I can get one to work, so will the other. There is a method that removes any number of stidents (comma separated) from a subject and also from the class for a subject. Putting the code for this in a loop for all subjects does not work with the same exception as above. This should be possible, and preferably without the looping - more something like the native delete query, which is not implemented in the EJB3/JBoss version I use (4.0.3) Maybe I should create explicit classes for the relationship tables and one to many relationships. I think I can get that to work. What a hassle. It will mean a lot of re-writing.
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3953864#3953864 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3953864 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user