Difference between oracle thin and thick drivers

 · JDBC Drivers. JDBC drivers are client-side adapters (installed on the client machine, not on the server) that convert requests from Java programs to a protocol that the DBMS can understand. There are 4 types of JDBC drivers: Type-1 driver or JDBC-ODBC bridge driver. Type-2 driver or Native-API driver. Type-3 driver or Network Protocol driver.  · Apr 15th, Basic difference between thin and thick client. Oracle has a thin client driver, which mean you can connect to a oracle database without the Oracle client installed on your machine. Thick client would need the Oracle Client, database drivers,etc.. Drivers include JDBC-ODBC bridge drivers,JDBC drivers depending on tns resolution. Thin vs Thick Driver. If Driver won’t require any extra Component to communicate with Database, such type of Driver is called Thin Driver. E.g. Type-4 Driver. If Driver require some extra Component (like ODBC Driver OR Vendor specific Native Libraries OR Middleware Server), such Type of Driver is called Thick Driver. E.g: Type-1, Type-2 and Type-3 Drivers.

From the server standpoint there is no difference between the two. The JDBC thin driver is % Java and comes in a single standalone jar (some extra jars will be needed for advanced features). The JDBC OCI driver makes JNI calls to the OCI C client library and hence depends on the Oracle full client to be installed (OCI is also what sqlplus uses). driver is a superset of the thin driver. If this is the case, and for example if all database connections were handled through a configuration file with the above OCI connection string, then theoretically the thick driver should work. If anyone has any info on this that they can share, it would be greatly appreciated. Thanks, Lou Avrami. Thin clients: Thick clients: 1. Installation: Thin clients have browser based installation. Thick clients are installed locally. 2. Type of devices: Thin clients are used by handheld devices. Customization systems use thick clients. 3. Processing Type: In thin clients there is complete processing on server side.

8 nov Oracle provides different types of JDBC drivers. Some features apply only to JDBC OCI drivers and some apply only to the JDBC Thin driver. hace 8 días While all Oracle JDBC drivers are similar, some features apply only to JDBC OCI drivers and some apply only to the JDBC Thin driver. The JDBC OCI driver is a Type II driver used with Java applications. It requires an Oracle client installation.