JDBC Driver for OracleJDBC Driver for Oracle

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.

This driver is co-packaged with DbVisualizer.

Required File(s)
ojdbc6.jar

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

Notes

To enable support for Oracles XMLTYPE in DbVisualizer Pro 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.

Note: We've discovered a problem starting with version 11.2 of the Oracle JDBC driver whereas XML data appear as "opaque" in DbVisualizer. Until we find a permanent solution, use the 11.1 driver version.

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)
ojdbc6.jar

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 web site
Oracle Instant Client web site

Notes

To enable support for Oracles XMLTYPE in DbVisualizer Pro 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.

Note: We've discovered a problem starting with version 11.2 of the Oracle JDBC driver whereas XML data appear as "opaque" in DbVisualizer. Until we find a permanent solution, use the 11.1 driver version.

Who Uses DbVisualizer

 

Customer Testimonial:
Kudos to the DbVisualizer development team for such an outstanding product. I have been a customer of DB Visualizer Professional for 6 years and I appreciate the constant effort you put into the product year in and year out. I use the product for many different development utilities I write and...
Tim
More...