Bug 777581 (SOA-89) - ESB management console DB scripts only support HSQLDB
Summary: ESB management console DB scripts only support HSQLDB
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-89
Product: JBoss Enterprise SOA Platform 4
Classification: JBoss
Component: Documentation, JBossESB
Version: 4.2 IR6
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: ---
: 4.2 CR1
Assignee: Joshua Wulf
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA-89
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2007-11-02 18:01 UTC by Len DiMaggio
Modified: 2014-10-19 22:59 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2008-01-23 20:41:18 UTC
Type: Bug

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-89 0 None None None Never

Description Len DiMaggio 2007-11-02 18:01:46 UTC 
Affects: Documentation (Ref Guide, User Guide, etc.), Release Notes
Date of First Response: 2008-01-15 11:19:33
project_key: SOA

ESB management console DB scripts only support HSQLDB

We should support customers who want to run one database vendor (tier 1 = MySQL, PostgreSQL, Oracle) for all SOA-P databases: 

   - jBPM
   - Message store
   - DB used by ESB console
   - DB used by transformations console
   - DB used by management/admin console
   - jUDDI
Comment 1 Len DiMaggio 2007-11-02 18:02:16 UTC 
Link: Added: This issue is a dependency of JBQA-1090
Comment 2 Joshua Wulf 2008-01-15 16:19:33 UTC 
What to do about this? HSQLDB is not supported in SOA platform. Is this an exception? Any way around this?

What are we going to message in our release notes / documentation about this? It will affect our support staff.
Comment 3 Joshua Wulf 2008-01-15 17:19:24 UTC 
Affects: Added: [Documentation (Ref Guide, User Guide, etc.)]
Comment 4 Mark Little 2008-01-19 21:42:27 UTC 
From the Management Console README:

"By default, the monitoring/management console uses hsqldb as a back-end
database.    It has also been tested with Oracle and MySQL, but could be
extended to use any other JDBC/hibernate-supported database.

In the management-esb directory there is a db.properties file.    In order
to change the database from hsqldb to mysql or oracle, edit this file and
change the db property to "mysql" or "oracle".

Next, change the management-esb/src/main/resources/<db>/management-ds.xml
file so that the settings match the datasource for your database. 

JBoss ships with hsqldb.jar in the server/<instance>/lib directory.    In
order to use a different database as a back-end, please also the JDBC driver
into the server/<instance>/lib directory of your application server.

For MySQL, it may be necessary to create the database "statistics" before 
deploying if you have not edited the management-ds.xml file."

It should be sufficient to refer to this file (MANAGEMENT-README.txt) in the Release Notes.
Comment 5 Mark Little 2008-01-19 21:43:06 UTC 
Josh, can you add this to the Release Notes for CR1?
Comment 6 Mark Little 2008-01-19 21:43:53 UTC 
Affects: Removed: [Documentation (Ref Guide, User Guide, etc.)] Added: [Documentation (Ref Guide, User Guide, etc.), Release Notes]
Comment 7 Joshua Wulf 2008-01-20 15:27:00 UTC 
http://engineering.redhat.com/docbot/en-US/JBoss_SOA_Platform/4.2/html-single/SOA_Release_Notes/
Comment 8 Len DiMaggio 2008-01-23 20:41:18 UTC 
Verified in the RC1 release notes.
Note You need to log in before you can comment on or make changes to this bug.