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

[Mike Millson (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBAS-6241?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12439542#action_12439542 ] 

Mike Millson commented on JBAS-6241:
------------------------------------

The commit message for https://svn.jboss.org/repos/jbossas/trunk/ erroneously referenced JBPAPP-1366.

>  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-4.2.3.GA, JBossAS-5.0.0.CR2
>         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