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

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