0 Replies Latest reply on Jan 31, 2003 1:35 PM by Matthew S. Ring

    Possible CMP table name length limitation?

    Matthew S. Ring Newbie

      * 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?

      -Matthew Ring