* JBoss 3.0.4 w/ Tomcat 4.1.12
* Oracle 8i w/ ojdbc14 drivers
* Sun jdk 1.4.1_01
When trying to create or find a CMP entity EJB, going against a table called GPSVAL.ENS_MESSAGE_CONTENT_TYPE, JBoss would return a nested exception:
java.sql.SQLException: ORA-00942: table or view does not exist
I double checked all my code and xdoclet tags. I verified that the same user account could access and insert into the same table through straight jdbc. So, on a whim, I removed the schema name from the table name, and it worked. Yes, the schema name is correct and is working fine w/ 8 other beans in my package.
This leads me to believe that JBoss CMP may artificially limit the CMP table name length. Can anyone else confirm?
Thanks.
-Matthew Ring