Recommanded JDBC Driver

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