Customer Testimonial:

I was introduced to DbVis about 3 years ago while working for a leading payments company in South Africa. Now, I cannot live without ...

User in South Africa

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 website

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 website 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 website
Oracle Instant Client website

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

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings.

Close