0 Replies Latest reply on Jan 9, 2003 10:32 AM by Micke


    Micke Newbie

      Hi, I've struggled with this problem for a while now and I have not been able to find a solution for it yet! Hopefully someone here has the answer?! I'm running JBoss 3.0.3 with Oracle 8.1.7, using the oci8 driver. I have a session bean and a local entity bean, Logger and ErrorLogger.

      I get an exception when I call the create method of ErrorLogger from the Logger. The beans are in the same .ear file. I've checked the ejb-jar.xml and the jbosscmp-jdbc.xml file and they match the database.

      There's no problem when I deploy the .ear but this are the messages printed when I call the create method:

      15:16:58,869 DEBUG [ErrorLogger] Create: pk=server.logger.error.ErrorLoggerPK@ec9f56f9
      15:16:58,879 DEBUG [ErrorLogger] Executing SQL: SELECT COUNT(*) FROM ERRORLOGGER
      WHERE millisecondTimestamp=? AND uniqObjref=?
      15:16:58,899 DEBUG [ErrorLogger] Executing SQL: INSERT INTO ERRORLOGGER (millisecondTimestamp, uniqObjref, errorNumber, date, errorType) VALUES (?, ?, ?, ?, ?)
      15:16:58,929 ERROR [ErrorLogger] Could not create entity
      java.sql.SQLException: ORA-01747: invalid user.table.column, table.column, or column specification

      Anyone who's experienced this problem before?