Bug 777558 (SOA-62) - Need to define, document, (ideally) automate in installer - steps for customer to convert or install SOA-P with DB other than HSQL
Summary: Need to define, document, (ideally) automate in installer - steps for custome...
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-62
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Documentation
Version: 4.2 IR2
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 4.2 CR3
Assignee: Mike Brock
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA-62
Whiteboard:
Depends On: SOA-427
Blocks:
TreeView+ depends on / blocked
 
Reported: 2007-10-23 14:17 UTC by Len DiMaggio
Modified: 2013-06-17 05:10 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2008-02-26 13:37:10 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 Bugzilla 777559 0 low CLOSED Need to examine DB-specific schema optimizations for SOA-P databases 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker JBESB-832 0 None None None Never
Red Hat Issue Tracker JBESB-871 0 None None None Never
Red Hat Issue Tracker SOA-62 0 None None None Never

Internal Links: 777559

Description Len DiMaggio 2007-10-23 14:17:24 UTC 
Date of First Response: 2007-10-24 02:42:46
project_key: SOA

We need to support customers who do not want to run HSQL. Right now, the ESB/SOA-P install (ant dist for ESB) creates the DBs automatically, but only for HSQL.

The DBs are:
   - jBPM
   - Message store
   - DB used by ESB console
   - DB used by transformations console
   - DB used by management/admin console
   - jUDDI

Right now, some of the DBs have scripts to create their DBs, but probably not all of them.

We need to create these scripts, define/document/verify/test the steps needed to convert an installation from HSQL to MySQL and PostgreSQL (tier 1 DBs for SOA-P).

Ideally - we will automate the install process in the installer.
Comment 2 Len DiMaggio 2007-10-23 14:27:45 UTC 
Link: Added: This issue is related to SOA-63
Comment 3 Len DiMaggio 2007-10-23 14:40:35 UTC 
Link: Added: This issue related JBESB-832
Comment 4 Len DiMaggio 2007-10-23 14:40:54 UTC 
Link: Added: This issue related JBESB-871
Comment 5 Jiri Pechanec 2007-10-24 06:42:46 UTC 
Check https://svn.corp.jboss.com/repos/soa/trunk/qa/dbinstall

It contains QA ant script that allows to configure ESB for selected database
Comment 7 Joshua Wulf 2007-12-19 15:10:25 UTC 
Will a script be included to do this, or will this be a sequence of steps that users need to follow manually, and which we will need to provide in the installation guide?
Comment 8 Jiri Pechanec 2008-02-05 14:15:52 UTC 
Also look to
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4122856#4122856
Comment 9 Mike Brock 2008-02-07 04:33:19 UTC 
fixed in CR3.

Interactive script is located in: /tools/schema

Simply run: "ant" then follow screen prompts for information.
Comment 10 Len DiMaggio 2008-02-26 13:37:10 UTC 
The new tool is in: /tools/schema in the GA CR3 and GA builds.
Comment 11 Aleksandar Kostadinov 2008-02-26 14:59:54 UTC 
SOA-427 is about the tool being broken
Comment 12 Aleksandar Kostadinov 2008-02-26 14:59:54 UTC 
Link: Added: This issue depends SOA-427
Note You need to log in before you can comment on or make changes to this bug.