Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to check which JDBC API version a specific driver implements [duplicate]

Tags:

java

jdbc

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?

like image 598
Surendran Duraisamy Avatar asked Sep 19 '13 05:09

Surendran Duraisamy


People also ask

Which JDBC driver is a native API partial Java 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.

Which JDBC driver is the fastest driver and why?

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.

Which API is used in JDBC?

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.


1 Answers

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.

like image 122
Elf Avatar answered Oct 23 '22 14:10

Elf