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 |
No comments:
Post a Comment