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?