Bug 779179 (SOA-1574) - Check and document DB driver versions
Summary: Check and document DB driver versions
Keywords:
Status: CLOSED NEXTRELEASE
Alias: SOA-1574
Product: JBoss Enterprise SOA Platform 5
Classification: JBoss
Component: Documentation, Configuration
Version: 5.0.0 CR1
Hardware: Unspecified
OS: Unspecified
urgent
urgent
Target Milestone: ---
: 5.0.0 GA
Assignee: Len DiMaggio
QA Contact:
URL: http://jira.jboss.org/jira/browse/SOA...
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2009-10-29 14:16 UTC by Julian Coleman
Modified: 2010-02-12 15:19 UTC (History)
0 users

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
N/A
Last Closed: 2010-02-12 15:19:32 UTC
Type: Task


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 779173 0 high CLOSED remove db drivers from the SOA build 2021-02-22 00:41:40 UTC
Red Hat Issue Tracker SOA-1574 0 None None None Never

Internal Links: 779173

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.  


Note You need to log in before you can comment on or make changes to this bug.