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

EJB TIMERS Table Creation Fails When Oracle Schema Specified

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Major Major
    • 4.2.0.GA_CP04, 4.3.0.GA_CP02
    • EJB
    • None
    • JBoss EAP 4.3.0 CP02
      Oracle 10g

    • Release Notes

      JBAS-4042 allows for the Oracle schema to be specified for the TIMERS table name so searches for an existing TIMERS table will be restricted to the schema. This is to support using the same database server to back more than one JBoss AS instance[1].

      This is done by adding the schema name to the TimersTable attribute in jboss-as/server/SERVERCONF/deploy/ejb-deployer.xml. For example:

      <attribute name="TimersTable">JBOSSAS.TIMERS</attribute>

      This causes GeneralPurposeDatabasePersistencePlugin[2] to create a primary key constraint called JBOSSAS.TIMERS_PK. "Dots" are not legal in primary key names, so a "ORA-00904: : invalid identifier" error is thrown when the TIMERS table is attempted to be created, and the TIMERS table is not created.

      The code needs to be updated to perhaps replace any "dots" with underscores.

      [1]http://www.redhat.com/docs/manuals/jboss/jboss-eap-4.3/doc/Server_Configuration_Guide/html/apbs08.html
      [2]https://svn.jboss.org/repos/jbossas/tags/JBPAPP_4_3_0_GA_CP03/server/src/main/org/jboss/ejb/txtimer/GeneralPurposeDatabasePersistencePlugin.java

        1. patch.txt
          1.0 kB
          Michael Millson
        2. patch.txt
          1.0 kB
          Michael Millson

            rhn-support-mmillson Michael Millson
            rhn-support-mmillson Michael Millson
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: