[JBoss-user] [EJB/JBoss] - Re: java.sql.SQLException: ORA-00904: invalid column name

2005-07-13 Thread bbbrotg
As it turns out JBoss ignores the orion-ejb-jar.xml that is created by JDeveloper. What I had to do was use the information in orion-ejb-jar.xml to create a jbosscmp-jdbc.xml from scratch. The container was then able to send a query to the Oracle database with the correct column names. View the

[JBoss-user] [EJB/JBoss] - Re: java.sql.SQLException: ORA-00904: invalid column name

2005-07-13 Thread bbbrotg
In the actual Oracle databse the coulumn names are county_nbr and district_nbr. The orion-ejb-jar.xml shown below should translate the cmp-field-mapping name to the persistence-name. I placed this file next to the ejb-jar.xml file in the META-INF folder. http://xmlns.oracle.com/ias/dtds/orion-

[JBoss-user] [EJB/JBoss] - java.sql.SQLException: ORA-00904: invalid column name

2005-07-12 Thread bbbrotg
I am trying to get a simple session facade to run using JBoss 4.0.2 and Oracle 8i. The code compiles fine the beans deploy fine but when I run the client I get the following error... 2005-07-12 09:03:51,046 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.District#findNameGivenNumber] Exec