Uploaded image for project: 'Application Server 3 4 5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-6241

EJB TIMERS Table Creation Fails When Oracle Schema Specified

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • JBossAS-5.0.0.GA
    • JBossAS-4.2.3.GA, JBossAS-5.0.0.CR2
    • EJB2
    • None
    • Workaround Exists
    • Hide

      Create the TIMERS table manually by executing the following SQL:

      create table <SCHEMANAME>.TIMERS ( TIMERID varchar(80) not null, TARGETID varchar(250) not null, INITIALDATE TIMESTAMP(9) not null, TIMERINTERVAL NUMBER(19), INSTANCEPK BLOB, INFO BLOB, CONSTRAINT <SCHEMANAME>_TIMERS_PK PRIMARY KEY (TIMERID, TARGETID) )

      Replace <SCHEMANAME> with the name of your schema. For example:

      create table JBOSSAS.TIMERS ( TIMERID varchar(80) not null, TARGETID varchar(250) not null, INITIALDATE TIMESTAMP(9) not null, TIMERINTERVAL NUMBER(19), INSTANCEPK BLOB, INFO BLOB, CONSTRAINT JBOSSAS_TIMERS_PK PRIMARY KEY (TIMERID, TARGETID) )

      Show
      Create the TIMERS table manually by executing the following SQL: create table <SCHEMANAME>.TIMERS ( TIMERID varchar(80) not null, TARGETID varchar(250) not null, INITIALDATE TIMESTAMP(9) not null, TIMERINTERVAL NUMBER(19), INSTANCEPK BLOB, INFO BLOB, CONSTRAINT <SCHEMANAME>_TIMERS_PK PRIMARY KEY (TIMERID, TARGETID) ) Replace <SCHEMANAME> with the name of your schema. For example: create table JBOSSAS.TIMERS ( TIMERID varchar(80) not null, TARGETID varchar(250) not null, INITIALDATE TIMESTAMP(9) not null, TIMERINTERVAL NUMBER(19), INSTANCEPK BLOB, INFO BLOB, CONSTRAINT JBOSSAS_TIMERS_PK PRIMARY KEY (TIMERID, TARGETID) )

    Description

      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.

      Attachments

        Issue Links

          is incorporated by

          Task - Represents a small unit of work that is not end-user facing. JBPAPP-1366 EJB TIMERS Table Creation Fails When Oracle Schema Specified

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: