and How to Installed different JDBC driver???

1) java.sql.DriverManager.getDriver(url).getMajorVers ion()
java.sql.DriverManager.getDriver(url).getMinorVers ion()

2) Class.forName("com.ibm.db2.jcc.DB2Driver").newInst ance();

Andy

Sorry I didn't inform you much. How do I find this infor in db2 database server


DB21085I Instance "DEV" uses "64" bits and DB2 code release "SQL09013"
with level identifier "01040107".
Informational tokens are "DB2 v9.1.0.3", "s070914", "U813650", and Fix Pack
"3a".
Product is installed at "/opt/IBM/db2/V9.1_03".

SELECT * FROM SYSIBMADM.ENV_INST_INFO

Andy

My bad . Thanks for replying ARWinner

I can't even type message properly.

My environment is

DB21085I Instance "DEV" uses "64" bits and DB2 code release "SQL09013"
with level identifier "01040107".
Informational tokens are "DB2 v9.1.0.3", "s070914", "U813650", and Fix Pack
"3a".
Product is installed at "/opt/IBM/db2/V9.1_03".


I need to find what type of JDBC drivers I had on my database serve from command line.

There is no command or program that I know of to get you this info. The only way is to load the driver and query it like I posted in my first post.

Andy

thanks for info bud