Bug 996175

Summary: Database driver configured during the installation process is not used for existing datasources
Product: [JBoss] JBoss Fuse Service Works 6 Reporter: Stefan Bunciak <sbunciak>
Component: InstallerAssignee: Thomas Hauser <thauser>
Status: CLOSED CURRENTRELEASE QA Contact: Len DiMaggio <ldimaggi>
Severity: urgent Docs Contact:
Priority: unspecified    
Version: 6.0.0 GACC: atangrin, jcoleman, soa-p-jira
Target Milestone: ER3   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Stefan Bunciak 2013-08-12 15:00:21 UTC
Description of problem:


Version-Release number of selected component (if applicable):

SOA 6.0.0.ER1

How reproducible:


Steps to Reproduce:
1. Install SOA 6.0.0.ER1 using installer
2. In post-installation configuration of the installer create a new datasource (e.g. with connection to Mysql database) with appropriate jdbc driver.
3. Finish installer

Actual results:

* New datasource along with appropriate driver is created in standalone.xml, however the existing datasources (jbpmDS, OverlordRTgov ds, ...) still use the default H2 database.

Expected results:

* After explicitly configuring a new database driver in the installer, this database driver should be used for existing datasources as well. 

Additional info:

* We can consider creating a checkbox in the installer GUI so users can decide.

Comment 4 Thomas Hauser 2013-09-20 19:40:25 UTC
The scripts now exist, and the chosen JDBC driver will be put into the existing datasources through the corresponding *.properties file.

Comment 5 Stefan Bunciak 2013-09-24 12:51:38 UTC
Verified in FSW 6.0.0.ER3. 

However, datasources are updated to use the new database driver, credentials remains the same which won't be correct until someone creates new users in its DB with exact the same credentials as the installer script specified.

Moreover, URL of the jBPM DS is not updated: https://bugzilla.redhat.com/show_bug.cgi?id=1011494