Databases And Drivers

Java DB driver for the JavaDB database

Driver Location	Bundled with Glassfish or Java 6 Also available from http://db.apache.org/derby/releases/release-10.3.1.4.cgi
Driver Versions	Derby 10.3.1.4
Driver JAR File	Network: derbyclient.jar Embedded: derby.jar
Driver Classnames	Network: org.apache.derby.jdbc.ClientDriver Embedded: org.apache.derby.jdbc.EmbeddedDriver
URL Format (Network)	-	Example URL (Network)	jdbc:derby://localhost:1527/sample

Oracle driver for the Oracle 10.x database

Driver Location	Oracle Database 10g Release 2 JDBC Drivers
Driver Versions	Oracle Database 10g Release 2 (10.2.0.3)
Driver JAR File	ojdbc14.jar
Driver Classnames	oracle.jdbc.driver.OracleDriver
URL Formats	-	Example URL	jdbc:oracle:thin:@localhost:1521:ora9i

Oracle driver for the Oracle 11.x database

Driver Location	Oracle Database 11g Release JDBC Drivers
Driver Versions	Oracle Database 11g Release (11.1.0.6.0)
Driver JAR File	ojdbc5.jar (JDK 1.5), ojdbc6.jar (JDK 1.6)
Driver Classnames	oracle.jdbc.driver.OracleDriver
URL Formats	-	Example URL	jdbc:oracle:thin:@localhost:1521:ora11i

PostgreSQL driver for the PostgreSQL database

Driver Location	Bundled with NetBeans 6.0 Also available from http://jdbc.postgresql.org/download.html
Driver Version	8.2 Build 506
Driver JAR File	postgresql-8.2-506.jdbc3.jar
Driver Classname	org.postgresql.Driver
URL Format	jdbc:postgresql://<host>:<port>/<database>
Example URL	jdbc:postgresql://jbrave-pc1.sfbay.sun.com:5432/postgres

MySQL drivers for the MySQL database

Driver Location	Bundled with NetBeans 6.0 Also available from http://dev.mysql.com/downloads/connector/j/5.0.html
Driver Version	MySQL Connector/J 5.0.7
Driver JAR Files	mysql-connector-java-5.0.7-bin.jar
Driver Classname	com.mysql.jdbc.Driver
URL Formats	-	Example URL	jdbc:mysql://localhost:3306/sample

Other Drivers

The following drivers and databases have not been formally tested, but should work based on experience.

Microsoft driver for the SQL Server database

Driver Location	" Microsoft SQL Server 2005 JDBC Driver 1.1
Driver Version	Microsoft SQL Server 2005 JDBC Driver 1.1 sqljdbc_1.1.1501.101_enu.tar.gz
Driver JAR File	sqljdbc.jar
Driver Classname	com.microsoft.sqlserver.jdbc.SQLServerDriver
URL Format	-	Example URL	jdbc:sqlserver://localhost:1433;databaseName=travel;selectMethod=cursor

IBM driver for the DB2 database

Driver Location	DB2 Personal Developer's Edition: Redistributable JDBC Type 4 Driver (requires registration)
Driver Version	Redistributable DB2 JDBC Type 4 driver v8 fixpack 13 db2_jdbc_t4_fp13.zip
Driver JAR Files	Type 4 db2jcc.jar, Type 2 jcc_license_cu.jar
Driver Classname	com.ibm.db2.jcc.DB2Driver
URL Format (Type 4)	-	Example URL	jdbc:db2://localhost:50002/sample

Note: The IBM drivers support both Type 2 (native) and Type 4 (pure Java). To force the drivers to run in Type 4, add a property: driverType = 4 when connecting to the database. Note2: To execute application, copy db2jcct2.dll or similar to the application server classpath. For Glassfish that would be $GLASSFISH_INSTALL_DIR\domains\domain1\lib

jTDS driver for the SQL Server database

Driver Location	jTDS
Driver Version	jTDS 1.2.1 jtds-1.2.1-dist.zip
Driver JAR File	jtds-1.2.1.jar
Driver Classname	net.sourceforge.jtds.jdbc.Driver
URL Format	-	Example URL	jdbc:jtds:sqlserver://rave-cheetah.sfbay.sun.com:1433/travel

DataDirect drivers for the Oracle, SQL Server, DB2 and Sybase databases

Driver Location	DataDirect Connect for JDBC, Release 3.6 Service Pack1
Driver Versions	DataDirect Connect for JDBC - 3.6 DataDirect Connect for JDBC - 3.6.07
Driver .jar Files	base.jar util.jar spy.jar resource.jar oracle.jar sybase.jar sqlserver.jar informix.jar
Driver Classnames	com.ddtek.jdbc.oracle.OracleDriver com.ddtek.jdbc.sqlserver.SQLServerDriver com.ddtek.jdbc.db2.DB2Driver com.ddtek.jdbc.sybase.SybaseDriver
URL Formats	-	Example URLs	jdbc:datadirect:oracle://localhost;SID=ora9i jdbc:datadirect:sqlserver://localhost:1433;DatabaseName=travel;SelectMethod=cursor jdbc:datadirect:db2://localhost:50002;databaseName=sample