Recommended JDBC Drivers


Various JDBC Drivers for the databases supported by Daffodil Replicator (E):


1. Oracle JDBC Drivers -

You can locate the latest Oracle JDBC drivers at the following location ...

Vendor : Oracle

Driver URL: [Free Registration Required]
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html

DATASOURCE_CLASS_NAME: oracle.jdbc.pool.OracleDataSource


2. DB2 8.1 & 8.2 JDBC Driver -

The DB2 JDBC drivers included with ADS, works across all 8.x versions of DB2.

You can locate the latest DB2 JDBC drivers at the following location ...

Vendor: IBM (JDBC Type 4 Driver)

Driver URL : http://www-306.ibm.com/software/data/db2/express/download.html

DATASOURCE_CLASS_NAME: com.ibm.db2.jcc.DB2DataSource


3. Microsoft SQL Server JDBC Drivers: -

You can locate the latest jTDS JDBC driver at the following location...

Vendor: Microsoft

Driver URL :
http://www.microsoft.com/downloads/details.aspx?

FamilyID=4f8f2f01-1ed7-4c4d-8f7b-3d47969e66ae&displaylang=en

DATASOURCE_CLASS_NAME: com.microsoft.jdbcx.sqlserver.SQLServerDataSource


4. Firebird JDBC Drivers -

You can locate the latest Sybase JDBC drivers at the following location ...

Vendor: Firebird

Driver URL :
http://sourceforge.net/project/downloading.php?

groupname=firebird&filename=Jaybird-2.1.1JDK_1.5.zip&use_mirror=jaist


5. Apache Derby JDBC Drivers -

Download the binary Apache Derby distribution from the Derby website at

http://db.apache.org/derby/derby_downloads.html

Include derby.jar and derbyClient.jar (that you can find in the lib of derby database) in lib folder of Daffodil Replicator.

DATASOURCE_CLASS_NAME: org.apache.derby.jdbc.ClientDataSource


6. PostGreSQL JDBC Drivers -

The PostGreSQL JDBC (v8.0.401) drivers include all versions of PostGreSQL from 7.2 to 8.0.

You can locate the latest PostGreSQL JDBC drivers at the following location ...

Vendor: PostgreSQL

Driver URL : http://jdbc.postgresql.org/download.html



7. MySQL JDBC Drivers -

The MySQL JDBC (v3.1.10) drivers include all versions of MySQL from 3.x to 4.1.

You can locate the latest MySQL JDBC drivers at the following location ...

Vendor: MySQL

Driver URL : http://dev.mysql.com/downloads/connector/j/5.1.html

DATASOURCE_CLASS_NAME: com.mysql.jdbc.jdbc2.optional.MysqlDataSource


8. Daffodil DB JDBC Drivers -

The Daffodil DB JDBC drivers include all versions of Daffodil DB.

You can locate the Daffodil DB JDBC drivers at the following location ...

Vendor: Daffodil

Driver URL : http://www.daffodildb.com/download/ReplicatorSite/download-replicator.jsp

DATASOURCE_CLASS_NAME: in.co.daffodil.db.rmi.RmiDaffodilDBDataSource


Daffodil Replicator (E) has been successfully tested with the following database versions:

DB2 9.1

Derby 10.1.3.1

Oracle 9i, 10g

PostGre 8.1, 8.2

SqlServer 2005_And_2000

DaffodilDB 4.2

MySql 5.0.3 beta

Firebird 2.0