Bug 779203 (SOA-1597)

Summary: DB schema tool should add the schema name to the TIMERS table in Oracle
Product: [JBoss] JBoss Enterprise SOA Platform 4 Reporter: Martin Weiler <mweiler>
Component: ToolingAssignee: Julian Coleman <jcoleman>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: high Docs Contact:
Priority: high    
Version: 4.2 CP04, 4.3 CP02   
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-1597
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 779204 (view as bug list) Environment:
Last Closed: 2010-01-05 09:18:28 UTC Type: Task
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Martin Weiler 2009-11-12 16:08:45 UTC 
Date of First Response: 2009-11-13 06:40:53
Help Desk Ticket Reference: https://enterprise.redhat.com/issue-tracker/363255
project_key: SOA

As documented in the EAP Server Configuration Guide, the TIMERS and HILOSEQUENCES tables should be prefixed by the schema name in Oracle (and possibly others):
http://www.redhat.com/docs/en-US/JBoss_Enterprise_Application_Platform/4.3.0.cp06/html/Server_Configuration_Guide/apbs08.html

The schema tool already does this for the HILOSEQUENCES table (see SOA-604), but not yet for the TIMERS table.
Comment 1 Julian Coleman 2009-11-13 11:40:53 UTC 
Fixed on trunk in revision 4121 of:
  build-tools/schema-tool/build.xml

Commit message:
  SOA-1597
  Prepend the user name to the TIMERS tablename (for all databases).
Comment 2 Julian Coleman 2009-11-13 11:53:34 UTC 
Add 5 ER4/GA to fix versions.
Comment 3 Julian Coleman 2009-11-20 15:14:51 UTC 
Additional fix in revision 4222 of:
  build-tools/schema-tool/build.xml 
 
Commit message:
  SOA-1597
  Only change the timers table name for Oracle.
Comment 4 nwallace 2009-11-27 18:03:08 UTC 
Link: Added: This issue related SOA-1652
Comment 5 nwallace 2009-11-30 14:12:59 UTC 
Link: Added: This issue related SOA-1655
Comment 6 nwallace 2009-11-30 14:17:42 UTC 
Fix in place and being back ported to 4.3 and 4.2 releases.
Comment 7 nwallace 2009-12-02 15:07:08 UTC 
I went and closed this rather than marking it as resolved.
Comment 8 nwallace 2009-12-02 15:08:57 UTC 
Resolved not closed
Comment 9 Jiri Pechanec 2010-01-05 09:18:28 UTC 
Verified in ER6
Comment 10 Marek Baluch 2011-08-30 14:07:45 UTC 
Link: Added: This issue is related to SOA-3315
Comment 11 Marek Baluch 2011-08-30 14:43:03 UTC 
Link: Removed: This issue is related to SOA-3315
Comment 12 Marek Baluch 2011-08-30 14:44:37 UTC 
Link: Added: This issue is related to SOA-3315