Type: Driver
File Name: jdbc_oci_33380.zip
File Size: 6.8 MB
39 (3.88)
Downloads: 30
Supported systems: Windows 7/8/10, Windows XP 64-bit, Mac OS X 10.X
Price: Free* (*Free Registration Required)

Download Now

Starting from Version Consider the following when choosing which JDBC driver to use for your application or applet:. But there's a fail-over issue, that OCI driver can preserve a state of it's clients, where as jdbc oci thin thin driver cannot.

I have heard that Thin drivers have problems when they are used in a clustered application server environment with multi-threaded programs jdbc oci thin database connections. SQLJ offers jdbc oci thin for these applications because it permits error checking at precompile time. The precompile step of a SQLJ program performs syntax-checking of the embedded SQL, type checking against the database to assure that the data exchanged between Java and SQL have compatible types and proper type conversions, and schema checking to assure congruence between SQL constructs and the database schema. The generated Java code compiles and runs like any other Java program.

Oracle DBA Tips: Tip#28 Thin (JDBC) Vs Thick (OCI) Driver

Jdbc oci thin syntax and semantics of SQLJ and JDBC do not depend on the configuration under which they are running, thus enabling implementation on the client or database side or in the middle tier. This section introduces the Oracle JDBC drivers, their basic architecture, and some scenarios for their use.

  • JDBC Connectivity
  • Connecting to Oracle Database - NetBeans IDE Tutorial
  • OCI Versus Thin Drivers - Java Programming with Oracle JDBC [Book]
  • The difference between OCI and thin Oracle in URL
  • Subscribe to RSS
  • Documentation
  • Connecting to Oracle

This information describes jdbc oci thin core functionality of all JDBC drivers. The rest of this section describes common features of the Oracle drivers and then discusses each one individually, concluding with a discussion of some of the considerations in choosing the appropriate driver for your application. Please note that you do not need to specify a database URL, username or password as you are already connected to a database session.

Connecting to Oracle Database from NetBeans IDE

NullPointerException at oracle. Linked Related Hot Network Questions. Question feed.


It is used on the client-side with an Oracle client installation. It can be used only with applications. It is functionally similar to the client-side Thin driver.


However, it is used for jdbc oci thin that runs on the database server and jdbc oci thin to access another session either on the same server or on a remote server on any tier. It is used for code that runs on the database server and accesses the same session. That is, the code runs and accesses data from a single Oracle session.

OracleDriver for the OCI driver. The troubleshooting tips below describe only a few exceptions that we met. If your question is not answered here, make your own search or use the Send Feedback on This Tutorial link to jdbc oci thin constructive feedback.

SQL Developer 19.1 Connections – Thick or Thin

For more information about administering and working with Oracle Database, see the corresponding Oracle's documentation. Below we provide a brief list of most commonly used documentation. If jdbc oci thin are connecting to a local instance you need to download and install Oracle Database XE.

auriga ckbm-001Question and Answer
saitek r100Question and Answer
arturia laboratory 49Query, Edit, Browse, and Manage Databases

The installation process is simple and intuitive, but if you have questions, refer to the Oracle Database XE installation guide for your platform. All rights reserved by Burleson.

Posted by Mehul Shah at PM.Both the JDBC thin driver and the JDBC OCI driver speak the same network protocol. From the server standpoint there is not difference.

Oracle Database 19c for Windows has just been released. Need a hand getting up and running? Here is a walkthrough of the software.

Related Drivers

Leave a Reply

Your email address will not be published. Required fields are marked *