How do I know which driver type I am using?

[Josue Nelson]

I'm using DB2 9.7 and I have the db2jcc.jar driver... How do I know which driver type it is?

Thanks in advance.

[Jelle Klap]

The documentation of the specific RDBMS / driver would be a good place to start.
If the driver is JDBC 4 compatible there's no need to load it via a Class.forName() anymore, though. A JDBC 4 compatible driver should have a file java.sql.Driver file located in the META-INF/services folder of the JDBC driver JAR file, which contains the FQN of the driver class.

[William P O'Sullivan]

import com.ibm.db2.jcc.DB2Version;

...

		System.out.println(DB2Version.getMajorVersion() +"." +DB2Version.getMinorVersion());
		System.out.println(DB2Version.getDriverName());
		System.out.println(DB2Version.getVersion());

gives:

4.1
IBM Data Server Driver for JDBC and SQLJ
4.1.85

using: db2jcc4-9.5.1.jar

WP

[Josue Nelson]

William P O'Sullivan wrote:

import com.ibm.db2.jcc.DB2Version;

...

		System.out.println(DB2Version.getMajorVersion() +"." +DB2Version.getMinorVersion());
		System.out.println(DB2Version.getDriverName());
		System.out.println(DB2Version.getVersion());

gives:

4.1
IBM Data Server Driver for JDBC and SQLJ
4.1.85

using: db2jcc4-9.5.1.jar

WP

Very helpful information. Thank you very much.

JN.