2 Replies Latest reply on Feb 28, 2003 12:30 PM by Yuri Kouzmov

    Find failed: Column not found:

    Yuri Kouzmov Newbie

      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)