Bug 779179 (SOA-1574)

Summary: Check and document DB driver versions
Product: [JBoss] JBoss Enterprise SOA Platform 5 Reporter: Julian Coleman <jcoleman>
Component: Documentation, ConfigurationAssignee: Len DiMaggio <ldimaggi>
Status: CLOSED NEXTRELEASE QA Contact:
Severity: urgent Docs Contact:
Priority: urgent    
Version: 5.0.0 CR1   
Target Milestone: ---   
Target Release: 5.0.0 GA   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/SOA-1574
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
N/A
Last Closed: 2010-02-12 15:19:32 UTC Type: Task
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Julian Coleman 2009-10-29 14:16:38 UTC
Affects: Documentation (Ref Guide, User Guide, etc.)
Date of First Response: 2010-01-28 09:44:38
project_key: SOA

Following on from SOA-1568, the correct driver versions:
  need to be added to the schema tool
  need to be documented, including download locations

Comment 1 Julian Coleman 2009-10-29 14:18:17 UTC
Link: Added: This issue is related to SOA-1568


Comment 2 Julian Coleman 2009-11-04 10:37:56 UTC
Fixed with revisions 4021, 4024 and 4025 of:
  build-tools/resource/schema-tool/*

Commit messages:
(4021)
  Update the list of supported databases for SOA 5:
    Oracle 10g R2, (10.2.0.4)
    MySQL 5.0 (5.0.79)
    Microsoft SQL Server 2005
    PostgreSQL 8.2.4

(4023)
  Update driver jar file names.

(4024)
  Use the JDBC4 driver.


Comment 4 Len DiMaggio 2010-01-28 14:44:38 UTC
The schema tool includes support for these DBs - the getting started guide and this page will indicate the supported databases - http://www.jboss.com/products/platforms/soa/testedconfigurations

BUT - I think we should remove the sybase related files and directories - as will will not have done ANY platform testing with it and SOA-P. Having the files/dir in the 5.0 release may cause some user confusion about it being/not being supported.

db2-97
db.driver.jar=db2jcc.jar

mssql2005
db.driver.jar=sqljdbc4.jar

mysql50
db.driver.jar=mysql-connector-java-5.0.*-bin.jar

mysql51
db.driver.jar=mysql-connector-java-5.1.*-bin.jar

oracle10g
db.driver.jar=ojdbc14*.jar

postgresql824
db.driver.jar=postgresql-8.2-*.jdbc4.jar

postgresql837
db.driver.jar=postgresql-8.3-*.jdbc4.jar

sybase15
db.driver.jar=jconn2.jar


Comment 6 trev 2010-01-29 11:18:25 UTC
as it's now docs, assigning to docs team and moving it to GA as it shouldn't have been left as ER2

Comment 7 David Le Sage 2010-02-09 04:55:52 UTC
I have updated Section 2.3 of the Getting Started Guide to indicate the supported databases and drivers.

Comment 8 David Le Sage 2010-02-10 00:37:39 UTC
Should now be visible on Documentation-Stage.

Comment 9 Len DiMaggio 2010-02-11 19:17:00 UTC
This section in the guide is incorrect.

We do NOT support Sybase in SOA-P 5.0

2.3. Database Requirements
JBoss Enterprise SOA Platform has been successfully tested with and is supported on the following database systems and JDBC drivers:
Database 	JDBC Driver
IBM DB2 9.7 	IBM Data Server Driver for JDBC and SQLJ (db2jcc.jar)
Microsoft SQL Server 2005 	Microsoft SQL Server JDBC Driver 2.0 (sqljdbc4.jar)
MySQL 5.0 	MySQL Connector/J 5.0.8 (mysql-connector-java-5.0.*-bin.jar)
MySQL 5.1 	MySQL Connector (mysql-connector-java-5.1.*-bin.jar)
Oracle 10g R2 	Oracle 10g R2, (10.2.0.4) JDBC thin (ojdbc14*.jar)
PostgreSQL 8.2.4 	JDBC4 Postgresql Driver, Version 8.2-510 (postgresql-8.2-510.jdbc4.jar)
PostgreSQL 8.3.7 	JDBC4 Postgresql Drive (postgresql-8.3-*.jdbc4.jar)
Sybase 15 	Sybase 15 (jconn2.jar) 

Comment 10 Len DiMaggio 2010-02-11 19:19:00 UTC
Please remove the reference to Sybase - it is NOT supported in SOA-P 5.0 - thx!

Comment 11 David Le Sage 2010-02-11 22:45:20 UTC
Just removed Sybase as requested.