Bug 779222 (SOA-1615)

Summary: dbinstall does not support correct versions of PostgreSQL and MySQL
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Jiri Pechanec <jpechane>
Component: ToolingAssignee: Julian Coleman <jcoleman>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: 5.0.0 ER3   
Target Milestone: ---   
Target Release: 5.0.0 GA, 5.0.0 ER4   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-1615
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2009-12-02 06:05:52 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 Jiri Pechanec 2009-11-18 12:36:09 UTC
Date of First Response: 2009-11-18 10:11:29
project_key: SOA

It was agreed that we will certify first on latest MySQL(5.1)  and PostgreSQL (8.3) but dbinstall supports only versions 5.0 and 8.2. Either new versions should be supported or both versions for each db should be supported.

Comment 1 Len DiMaggio 2009-11-18 15:11:29 UTC
The files that Jirka is referring to:

[ldimaggi@ldimaggi schema]$ cat postgresql824/driver/name.properties 
db.driver.jar=postgresql-8.2-*.jdbc4.jar

[ldimaggi@ldimaggi schema]$ cat mysql50/driver/name.properties 
db.driver.jar=mysql-connector-java-5.0.*-bin.jar


Comment 2 Julian Coleman 2009-11-20 13:32:17 UTC
Fixed with revision 4217 of:
  build-tools/resource/schema-tool/build.xml
  build-tools/resource/schema-tool/mysql51 (added)
  build-tools/resource/schema-tool/postgresql837 (added)

Commit message:
  Make MySQL 5.1 and PostgreSQL 8.3.7 the initially supported versions.
  Add files for them.


Comment 3 Jiri Pechanec 2009-12-02 06:05:52 UTC
Verified in ER4