DatabasesAndDrivers

Contents


Tested Drivers

NetBeans 6.0 has been tested with the following databases and drivers. (see supported target servers for web applications)

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
Not logged in. Log in, Register

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo