Bug 779204 - DB schema tool should add the schema name to the TIMERS table in Oracle
Summary: DB schema tool should add the schema name to the TIMERS table in Oracle
Keywords:
Status: CLOSED NEXTRELEASE
Alias: None
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: Tooling
Version: 5.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 5.0.0 GA,5.0.0 ER4
Assignee: Julian Coleman
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-11-12 16:08 UTC by Martin Weiler
Modified: 2012-07-13 04:17 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of: SOA-1597
Environment:
Last Closed: 2010-01-05 09:18:28 UTC
Type: Task

Attachments (Terms of Use)
Add an attachment (proposed patch, testcase, etc.)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker SOA-1597 0 None None None Never

Description Martin Weiler 2009-11-12 16:08:45 UTC 
++ This bug is a clone of bug 779203 ++

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
Note You need to log in before you can comment on or make changes to this bug.