where to check JDBC driver version? 1

[huchen]

Hello,
Somebody asked me this:
What version of JDBC driver do we use to connect to the database?

Where should I look to find out the answer?

Database is Oracle and application is on BEA server(web application)

The more detailed your answer is, the better it will help me.

Thank you.

 

[sedj]

Connection c ...
DatabaseMetaData dmd = c.getMetaData();

The class DatabaseMetaData holds version info and other data.
See

http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html

--------------------------------------------------
Free Java/J2EE Database Connection Pooling Software

http://www.primrose.org.uk

 

[huchen]

Thank you.
I used following to get the JDBC driver on my local.



import java.sql.*;
import oracle.jdbc.driver.*;

class JDBCVersion
{
public static void main (String args [])
throws SQLException
{
// Load the Oracle JDBC driver

DriverManager.registerDriver
(new oracle.jdbc.driver.OracleDriver());

// Change the following code line to reflect a valid connection to your

// server

Connection conn = DriverManager.getConnection
("jdbcracle:thin:myDBservreort#:sid","scott","tiger");

// Create Oracle DatabaseMetaData object
DatabaseMetaData meta = conn.getMetaData ();

// gets driver info:

System.out.println("\n=============\nDatabase Product Name is ... " +
meta.getDatabaseProductName());
System.out.println("\nDatabase Product Version is " +
meta.getDatabaseProductVersion());
System.out.println("\n=============\nJDBC Driver Name is ........ " +
meta.getDriverName());
System.out.println("\nJDBC Driver Version is ..... " +
meta.getDriverVersion());
System.out.println("\nJDBC Driver Major Version is " +
meta.getDriverMajorVersion());
System.out.println("\nJDBC Driver Minor Version is " +
meta.getDriverMinorVersion());
System.out.println("\n=============");
}
}