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

Allow configuration of timers table name (and schema)

XMLWordPrintable

    • Documentation (Ref Guide, User Guide, etc.), Compatibility/Configuration
    • 0
    • 0% 0%

      The TIMER service does not allow the name of the table to be used by the timer service to be overriden.

      To check is the table already exists the following is called: -

      rs = dmd.getTables(catalog, schema, tableName, null);
      return rs.next();

      For the timer service no schema is specified so this returns the TIMER tables for all schemas so we do not create the table for the current schema even though it is not available.

      If the table name is specified as SCHEMA_NAME.TABLE_NAME then the search will be restricted to the schema so will prevent tables from other schemas being picked up.

            dandread1@redhat.com Dimitrios Andreadis
            darran.lofthouse@redhat.com Darran Lofthouse
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: