JAVA - JDBC, Supported Database, JDBC Drivers, and Deployment Containers

Supported Databases, JDBC Drivers, and Deployment Containers

NetBeans Visual Web Pack 5.5 is tested on the following databases and drivers:

• Oracle Driver / Oracle Database
• Microsoft Driver / SQL Server Database
• IBM Driver / DB2 Database
• MySQL Driver / MySQL Database
• DataDirect / Oracle/SQLServer/DB2/Sybase

Oracle driver tested on the Oracle database:

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

Microsoft driver tested on 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	jdbc:sqlserver://hostname:1433;databaseName=database;selectMethod=cursor
Example URL	jdbc:sqlserver://localhost:1433;databaseName=travel;selectMethod=cursor

IBM drivers tested with 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 11  db2_jdbc_t4_fp11.zip
Driver JAR Files	Type 4 · db2jcc.jar · 2jcc_license_cu.jar
Driver Classname	com.ibm.db2.jcc.DB2Driver
URL Format (Type 4)	jdbc:db2://hostname:port/database
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.

MySQL drivers tested with the MySQL database:

Driver Location	Download Connector/J 5.0.3 (tar.gz) Download Connector/J 5.0.3 (zip)
Driver Version	MySQL?? Connector/J 5.0.3
Driver JAR Files	mysql-connector-java-5.0.3-bin.jar
Driver Classname	org.gjt.mm.mysql.Driver
URL Format	jdbc:mysql://hostname:port/database jdbc:mysql://hostname/database
Example URL	jdbc:mysql://localhost:3306/sample jdbc:mysql://localhost/sample

DataDirect drivers tested with Oracle, SQL Server, DB2 and Sybase databases:

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

출처 : http://netbeans.org/community/releases/55/vwp-release-notes.html