EJB TIMERS Table Creation Fails When Oracle Schema Specified

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