본문 바로가기

Languages/Java

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 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