Bug 778752 (SOA-1207)

Summary:	database schema tool can't deal with multiple databases
Product:	[JBoss] JBoss Enterprise SOA Platform 4	Reporter:	Dana Mison <dmison>
Component:	Documentation	Assignee:	David Le Sage <dlesage>
Status:	CLOSED NEXTRELEASE	QA Contact:
Severity:	high	Docs Contact:
Priority:	high
Version:	4.3 GA	CC:	atangrin
Target Milestone:	---
Target Release:	4.3 CP05
Hardware:	Unspecified
OS:	Unspecified
URL:	http://jira.jboss.org/jira/browse/SOA-1207
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2011-05-03 19:16:45 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:

Description Dana Mison 2009-03-06 04:30:47 UTC

Affects: Documentation (Ref Guide, User Guide, etc.)
project_key: SOA

The database schema tool doesn't support the possibility of different components using different databases.

After the instructions for using the schema tool there needs to be details on how to update the config for each component.

These instructions should also include jBPM

https://bugzilla.redhat.com/show_bug.cgi?id=488709
https://bugzilla.redhat.com/show_bug.cgi?id=488735

Comment 3 Dana Mison 2011-02-24 23:45:06 UTC

using multiple databases for different SOA platform components is not a supported config

Comment 4 Dana Mison 2011-02-25 02:41:22 UTC

actually we need to ensure that it is clear in the schema tool instructions in the GSG that we only support using a single DB system at a time.

Comment 5 David Le Sage 2011-04-05 23:17:28 UTC

Release Notes Docs Status: Added: Not Required
Release Notes Text: Added: Getting Started Guide backported from 5.1.  It includes a clear warning about the database schema tool.

Comment 6 David Le Sage 2011-04-07 23:09:40 UTC

Writer: Added: dlesage

Comment 7 Jiri Pechanec 2011-04-21 12:41:30 UTC

Verified in the documentation
http://documentation-stage.bne.redhat.com/docs/en-US/JBoss_Enterprise_SOA_Platform/4.3/html/Getting_Started_Guide/chap-setup.html#sect-changing_database

Comment 8 Jiri Pechanec 2011-04-21 12:43:52 UTC

My bad, documentation claims only that schema tool can be run only once. The documentation does not contain an information that only one database for all components is supported.

Comment 9 David Le Sage 2011-05-03 04:31:55 UTC

Thanks for picking up on that, Jiri.  I have added an extra warning to that section of the book to clearly state that you cannot have different databases for different components.

Comment 10 David Le Sage 2011-05-03 04:32:53 UTC

Release Notes Text: Removed: Getting Started Guide backported from 5.1.  It includes a clear warning about the database schema tool.

Comment 11 Len DiMaggio 2011-05-03 19:16:45 UTC

Changes verified in the doc here:

http://documentation-stage.bne.redhat.com/docs/en-US/JBoss_Enterprise_SOA_Platform/4.3/html/Getting_Started_Guide/chap-setup.html#sect-changing_database