It's on a developer's local sandbox so when he gets back I will have him turn on the SQL debug output and we will provide you with the exact query that is failing.
Rod -----Original Message----- From: Alexey Loubyansky [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 23, 2003 11:11 PM To: [EMAIL PROTECTED] Subject: RE: [JBoss-user] Cannot access EJB with multiple CMR columns So what is causing the SQLException? Incorrect SQL? > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Rod Macpherson > Sent: Wednesday, December 24, 2003 12:34 AM > To: [EMAIL PROTECTED] > Subject: [JBoss-user] Cannot access EJB with multiple CMR columns > > > We get the following error fetching one of our entity beans in JBoss > 3.2.2: > > java.sql.SQLException: ORA-00936: missing expression > > The associated table is different than every other table in > the schema. > I will use a fictitious example to explain. Assume you have a > TREE table with six columns that reference the ORNAMENT > table. Therefore each TREE is restricted to six associated > ORNAMENT records. The entity beans associated with TREE are > failing to load. This is not a common structure. In general > we use an intersect table to associate any number of child > records with the parent. We can use that as a workaround. > Also noted that eliminating all or all but one of the > ORNAMENT refereces from the TREE bean's deployment descritor > fixes the problem. The failure only shows up when a given EJB > has several foreign key references to the same table. > > > > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IBM Linux Tutorials. Become an > expert in LINUX or just sharpen your skills. Sign up for IBM's Free > Linux Tutorials. Learn everything from the bash shell to sys admin. > Click now! http://ads.osdn.com/?ad_id78&alloc_id371&op=ick > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id78&alloc_id371&op=ick _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id78&alloc_id371&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
