How can I check whatthe type of the JDBC driver I am using is?
I am currently using ojdbc14.jar
. How can I check if my driver is JDBC 4 compliant driver?
Type 2 or Partial Java driver: Also known as Native API converts JDBC calls into database-specific native libraries calls and these calls are directly understood by the database engine. This type of driver converts JDBC calls into calls on the client API for Oracle, Sybase, Informix, DB2, or other DBMS.
JDBC Net pure Java driver(Type 4) is the fastest driver because it converts the JDBC calls into vendor specific protocol calls and it directly interacts with the database.
Java™ JDBC API The Java Database Connectivity (JDBC) API provides universal data access from the Java programming language. Using the JDBC API, you can access virtually any data source, from relational databases to spreadsheets and flat files.
You can run the following command to get the driver version.
java -jar ojdbc14.jar
This gave me o/p as:
Oracle 11.1.0.7.0-Production JDBC 3.0 compiled with JDK5
So the driver version is 11.1.0.7.0 and it is JDBC 3.0 complaint.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With