Bug 779204

Summary:	DB schema tool should add the schema name to the TIMERS table in Oracle
Product:	[JBoss] JBoss Enterprise SOA Platform 5	Reporter:	Martin Weiler <mweiler>
Component:	Tooling	Assignee:	Julian Coleman <jcoleman>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	5.0
Target Milestone:	---
Target Release:	5.0.0 GA, 5.0.0 ER4
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:	SOA-1597	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

++ 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