Databases & DriversDatabases & Drivers

Oracle Thin JDBC Driver

The JDBC Thin driver is a pure Java, Type IV driver that can be used in applications and applets. It is platform-independent and does not require any additional Oracle software on the client-side. The JDBC Thin driver communicates with the server using SQL*Net to access Oracle Database.

The JDBC Thin driver allows a direct connection to the database by providing an implementation of SQL*Net on top of Java sockets. The driver supports the TCP/IP protocol and requires a TNS listener on the TCP/IP sockets on the database server.

Required File(s)
ojdbc15.jar (For Java 1.5)
ojdbc16.jar (For Java 1.6)

Default Driver Class
oracle.jdbc.OracleDriver

JDBC URL Format
jdbc:oracle:thin://<host>:<port>/<service><br> jdbc:oracle:thin:<host>:<port>:<SID><br> jdbc:oracle:thin:<TNSName> (from 10.2.0.1.0)

Example:
jdbc:oracle:thin:@mimmi:1521:ORCL_SID
jdbc:oracle:thin:@192.168.1.12:1521/ORCL_SVC
jdbc:oracle:thin:@(description=(address=(host=localhost)
(protocol=tcp)(port=1521))(connect_data=(sid=ORCL)))
jdbc:oracle:thin:@ML

More information and download
Oracle JDBC

Notes
Read more in: Oracle JDBC Frequently Asked Question

To enable support for Oracles XMLTYPE in DbVisualizer Personal you need to load the xdb.jar and xmlparserv2.jar in the DbVisualizer Driver Manager. These files are available in the Oracle XML Developers Kit. Visit the Oracle web site for download.

Oracle OCI JDBC Driver

The JDBC OCI driver is a Type II driver used with Java applications. It requires an Oracle client installation and, therefore, is Oracle platform-specific. It supports all installed Oracle Net adapters, including interprocess communication (IPC), named pipes, TCP/IP, and Internetwork Packet Exchange/Sequenced Packet Exchange (IPX/SPX).

The JDBC OCI driver uses the OCI libraries, C-entry points, Oracle Net, core libraries, and other necessary files on the client computer where it is installed.

Generally we recommend the Oracle Thin driver over the OCI driver since it works on any platform that supports Java. OCI requires client libraries and these are not available on all platforms.

Required File(s)
ojdbc15.jar (For Java 1.5)
ojdbc16.jar (For Java 1.6)

Default Driver Class
oracle.jdbc.OracleDriver

JDBC URL Format
jdbc:oracle:oci://<host>:<port>/<service><br> jdbc:oracle:oci:<host>:<port>:<SID><br> jdbc:oracle:oci:<TNSName>

Example:
jdbc:oracle:oci:@mimmi:1521:ORCL_SID
jdbc:oracle:oci:@192.168.1.12:1521/ORCL_SVC
jdbc:oracle:oci:@(description=(address=(host=localhost)
(protocol=tcp)(port=1521))(connect_data=(sid=ORCL)))
jdbc:oracle:oci:ML

More information and download
Oracle JDBC
Oracle Instant Client

Notes
Read more in: Oracle JDBC Frequently Asked Question

To enable support for Oracles XMLTYPE in DbVisualizer Personal you need to load the xdb.jar and xmlparserv2.jar in the DbVisualizer Driver Manager. These files are available in the Oracle XML Developers Kit. Visit the Oracle web site for download.