Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-958

All TCK test com.sun.ts.tests.ejb.ee.pm.ejbql failing for DB2 - Table name is too long

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 4.3.0.GA_CP03
    • 4.3.0.GA_CP01
    • EJB, TCK
    • None
    • TCK 1.4 Tests with EAP 4.3, using DB2

      All tests under com.sun.ts.tests.ejb.ee.pm.ejbql.equality are failing. The tests fails because an error in deployment occurred, due to the limit of table name in DB2. The deployer is trying to create a table name which exceeds the limit of 18 chars:

      12:15:43,613 WARN [ServiceController] Problem starting service jboss.j2ee:service=EjbModule,module=ejb_ECmpQL_schema_ejb.jar
      org.jboss.deployment.DeploymentException: Error while creating table ALIASEJB_CUSTOMERS_CUSTOMEREJB_ALIASES; - nested throwable: (com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -107, SQLSTATE: 42622, SQLERRMC: PK_ALIASEJB_CUSTOMERS_CUSTOMEREJB_ALIASES;18)

      This error means that the table ALIASEJB_CUSTOMERS_CUSTOMEREJB_ALIASES cannot be created because of the length of its name is bigger than the limit of 18 chars.

      This is the relevant stack trace:

      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:617)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:319)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:499)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:396)
      at org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)
      at org.jboss.ejb.EjbModule.startService(EjbModule.java:414)

            jpkroehling@redhat.com Juraci Paixão Kröhling (Inactive)
            jpkroehling@redhat.com Juraci Paixão Kröhling (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: