Java JDBC

1.JDBC-ODBC Bridge

Java Jar:None

Driver Name: sun.jdbc.odbc.JdbcOdbcDriver

DB URL:jdbc.odbc:<DB>

User Name:xxxx

Password:xxxx

2.Java DB(Network)(Derby)

Java Jar: derbyclient.jar

Driver Name:org.apache.derby.jdbc.ClientDriver

DB URL:jdbc:derby://<HOST>[:<PORT>]/databaseName[;attr1=value1[;...]] default port =1527

User Name:xxxx

Password:xxxx

3.Java DB(Embedded)(Derby)

Java Jar: derby.jar

Driver Name:org.apache.derby.jdbc.EmbeddedDriver

DB URL:jdbc:derby:<DB> (simlar as jdbcodbc)

User Name:xxxx

Password:xxxx

4.MySQL Connector/J(MySQL (Connector/J driver))

Java Jar: mysql-connector-java-3.1.11-bin.jar(在Linux上，MySQL的缺省用户为root,密码无）

Driver Name:com.mysql.jdbc.Driver(org.gjt.mm.mysql.Driver)

DB URL:jdbc:mysql://<hostname>[<:3306>]/<dbname>

User Name:xxxx

Password:xxxx

5.Oracle (OCI driver)

Java Jar: ojdbc14.jar

Driver Name:org.apache.derby.jdbc.EmbeddedDriver

DB URL:jdbc:oracle:oci8:@<database_name>

User Name:xxxx