I'm having a problem trying to get JBoss/CMP working w/ Oracle. I'm knew to JBoss, so I'm not sure what information you need to help you figure out what the problem is. I used MiddleGen to build the sample app that comes with it. Everything worked fine when I used Hypersonic DB, but the exact same code / config doesn't work w/ Oracle. I've verified that the tables were created properly and that the SQL Query in the error message executes succesfully when I run it manually.
Any help would be very much appreciated. [error message follows below]
Thanx
Y.
16:45:12,855 INFO [MainDeployer] Deployed package: file:/C:/jboss-3.0.4_tomcat-4.1.12/server/default/deploy/a
irline.ear
16:45:25,355 ERROR [Engine] ActionServlet: Can't find entity
javax.ejb.FinderException: Find failed: java.sql.SQLException: Column not found: PERSON_ID in statement [SELEC
T t0_o.RESERVATION_ID, t0_o.PERSON_ID, t0_o.FLIGHT_ID FROM RESERVATIONS t0_o]
at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:148)
