[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jboss-user
Subject:    RE: [JBoss-user] Cannot access EJB with multiple CMR columns
From:       "Rupp, Heiko" <Heiko.Rupp () cellent ! de>
Date:       2003-12-29 10:32:21
[Download RAW message or body]

Hi,

did you check that all column names are not sql reserved words?
Some databases check for them at every place while others 
are more relaxed and when they know that at a certain place
only a column name is allowed, allow the use of reserved words.

You can (from 3.2.2 on) have JBoss escape reserved words.
Have a look at the bottom of standardjbosscmp-jdbc.xml

> -----Original Message-----
> From: jboss-user-admin@lists.sourceforge.net
> [mailto:jboss-user-admin@lists.sourceforge.net]On Behalf Of Rod
> Macpherson
> Sent: Wednesday, December 24, 2003 6:57 PM
> To: jboss-user@lists.sourceforge.net
> Subject: RE: [JBoss-user] Cannot access EJB with multiple CMR columns
> 
> 
> 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:alex@jboss.org] 
> Sent: Tuesday, December 23, 2003 11:11 PM
> To: jboss-user@lists.sourceforge.net
> Subject: RE: [JBoss-user] Cannot access EJB with multiple CMR columns
> 
> 
> So what is causing the SQLException? Incorrect SQL? 
> 
> > -----Original Message-----
> > From: jboss-user-admin@lists.sourceforge.net
> > [mailto:jboss-user-admin@lists.sourceforge.net] On Behalf Of 
> > Rod Macpherson
> > Sent: Wednesday, December 24, 2003 12:34 AM
> > To: jboss-user@lists.sourceforge.net
> > 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
> > JBoss-user@lists.sourceforge.net
> > 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
> JBoss-user@lists.sourceforge.net
> 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
> JBoss-user@lists.sourceforge.net
> 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Ěk
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user

[prev in list] [next in list] [prev in thread] [next in thread]