Database Implementation Notes

Sybase

DBReplicator support for Sybase is implemented but in need of further testing.

SQLServer

DBReplicator support for SQLServer is implemented, but needs further testing.

Microsoft JDBC Connection
Database Driver
com.microsoft.jdbc.sqlserver.SQLServerDriver
JDBC Connect String
jdbc:microsoft:sqlserver://<server name>:1433;DatabaseName=<database name>

JNetDirect JDBC Connection
Database Driver
com.jnetdirect.jsql.JSQLDriver
JDBC Connect String
jdbc:JSQLConnect://<server name>:1433/database=<database name>/lastUpdateCount=true

PostgreSQL

DBReplicator support for PostgreSQL has been reasonably well tested, having been used in production environments with medium(500,000 - 6,000,000 records) sized databases, with sync sessions of up to approximately 3,000,000 records.

Tested with Postgres versions 7.3 and 8.2. It should work for anything in between.

Database Driver
org.postgresql.Driver
JDBC Connect String
jdbc:postgresql://<Hostname>:<Port>/<dbname>

PointBase

DBReplicator support for PointBase is implemented but not tested.

Oracle

DBReplicator support for Oracle is implemented but not tested

Database Driver
oracle.jdbc.driver.OracleDriver
JDBC Connect String
jdbc:oracle:thin:@<Server Name>:<Port>:<database name>

MySQL

DBReplicator support for MySQL is implemented and somewhat tested, but could use much more.

MySQL JDBC Connection
Database Driver
com.mysql.jdbc.Driver
JDBC Connect String
jdbc:mysql://localhost/<database name>

FireBird

DBReplicator support for FireBird is implemented but still needs testing.

DB2

DBReplicator support for DB2 is implemented but needs testing

Database Driver
com.ibm.db2.jcc.DB2Driver
JDBC Connect String
jdbc:db2j:net://<server name>:1527/<database name>;retrieveMessagesFromServerOnGetMessage=true;deferPrepares=true;create=true
jdbc:db2://<server name>::50000/<database name>

DaffodilDB / One$DB

DBReplicator support for DaffodilDB / One$DB is implemented, but needs testing.

Database Driver
in.co.daffodil.db.jdbc.DaffodilDBDriver
JDBC URL
jdbc:daffodilDB_embedded:school;create=true

CloudScape / Derby / JavaDB

Background
Cloudscape Inc was founded in 1996 to develop a Java database. In 1999 it was acquired by Informix, which was taken over by IBM in 2001. IBM developed Cloudscape as an embedded Java database, before handing it over to the Apache Software Foundation in 2004, which renamed it "Derby." Sun began supplying Java DB as a supported version of Derby in 2006.

From the Derby homepage: db.apache.org/derby

Powered by Drupal - Theme by Danger4k