patternModerate
Why Oracle SQL Developer does not need Oracle client?
Viewed 0 times
whyneedsqlclientdoesdeveloperoraclenot
Problem
I installed Oracle SQL Developer from Oracle's web page. It seems to work without a Oracle client installed on my computer. How is that possible? I also installed Toad for Oracle and it seems to require Oracle client.
Solution
SQL Developer is using the so called "thin driver".
For this the JDBC driver (a file named
This is not something specific to SQL Developer but to any Java application using JDBC to connect to the database.
For this the JDBC driver (a file named
ojdbc6.jar) implements the complete Oracle network protocol which is usually handled by the Oracle client. It could use the another implementation: the "OCI" (or "thick") driver which would require an Oracle client to be installed. That would be necessary if e.g. Transparent Application Failover in a RAC is required.This is not something specific to SQL Developer but to any Java application using JDBC to connect to the database.
Context
StackExchange Database Administrators Q#44470, answer score: 14
Revisions (0)
No revisions yet.