[jboss-jira] [JBoss JIRA] Created: (JBAS-6241) EJB TIMERS Table Creation Fails When Oracle Schema Specified

[Mike Millson (JIRA)]

 EJB TIMERS Table Creation Fails When Oracle Schema Specified
-------------------------------------------------------------

                 Key: JBAS-6241
                 URL: https://jira.jboss.org/jira/browse/JBAS-6241
             Project: JBoss Application Server
          Issue Type: Bug
      Security Level: Public (Everyone can see)
          Components: EJB2
    Affects Versions: JBossAS-5.0.0.CR2, JBossAS-4.2.3.GA
         Environment: JBoss EAP 4.3.0 CP02
Oracle 10g 
            Reporter: Mike Millson
            Assignee: Mike Millson
             Fix For: JBossAS-5.0.0.GA, JBossAS-4.2.4.GA


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.

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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira