COM.ibm.db2.jdbc.app.DB2Driver JDBC version compatibility

[Satish Gupta]

I am using DB2 version 7.2 on Windows 2000. I just installed Fixpack
12 as well.

This driver is not working with a third-party software. The vendor
claims that this driver is too old. As a proof of this, the following
call is failing:

Connection.createStatement(ResultSet.TYPE_FORWARD_ ONLY,
ResultSet.CONCUR
_READ_ONLY); with driver version: [07.02.0009]
major version = 7
minor version = 1
Exception in thread "main" java.lang.AbstractMethodError:
COM.ibm.db2.jdbc.app.D
B2Connection.createStatement(II)Ljava/sql/Statement;
at TestDB2.test(TestDB2.java:22)
at TestDB2.main(TestDB2.java:7)

My questions are:

.. What does this imply? What version of JDBC does the above driver
implement?
.. What will it take for me to get a driver which will work with
version 7.2 and provide above functionality? I am assuming that I'd
need JDBC 2 functionality.
.. How can I get/upgrade to such a driver?
.. Or do I have to use DB2 version 8 to get this functionality?

Thanks

[Fan Ruo Xin]

In db2 udb version7.2, in order to allow the use of the Java 2 functions,
you have to run usejdbc2 ($DB2HOME/sqllib/java12) script. And you don't need
to run this script when use DB2 UDB Version8, which will support Java 2
functions by default.

"Satish Gupta" <gl**********@yahoo.com> wrote in message
news:33**************************@posting.google.c om...

I am using DB2 version 7.2 on Windows 2000. I just installed Fixpack
12 as well.

This driver is not working with a third-party software. The vendor
claims that this driver is too old. As a proof of this, the following
call is failing:

Connection.createStatement(ResultSet.TYPE_FORWARD_ ONLY,
ResultSet.CONCUR
_READ_ONLY); with driver version: [07.02.0009]
major version = 7
minor version = 1
Exception in thread "main" java.lang.AbstractMethodError:
COM.ibm.db2.jdbc.app.D
B2Connection.createStatement(II)Ljava/sql/Statement;
at TestDB2.test(TestDB2.java:22)
at TestDB2.main(TestDB2.java:7)

My questions are:

. What does this imply? What version of JDBC does the above driver
implement?
. What will it take for me to get a driver which will work with
version 7.2 and provide above functionality? I am assuming that I'd
need JDBC 2 functionality.
. How can I get/upgrade to such a driver?
. Or do I have to use DB2 version 8 to get this functionality?

Thanks

[Satish Gupta]

Thanks Fan Ruo Xin!

There couldn't have been a better answer!

"Fan Ruo Xin" <fa*****@sbcglobal.net> wrote in message news:<Zg**********************@newssvr28.news.prod igy.com>...

In db2 udb version7.2, in order to allow the use of the Java 2 functions,
you have to run usejdbc2 ($DB2HOME/sqllib/java12) script. And you don't need
to run this script when use DB2 UDB Version8, which will support Java 2
functions by default.

"Satish Gupta" <gl**********@yahoo.com> wrote in message
news:33**************************@posting.google.c om...

I am using DB2 version 7.2 on Windows 2000. I just installed Fixpack
12 as well.

This driver is not working with a third-party software. The vendor
claims that this driver is too old. As a proof of this, the following
call is failing:

Connection.createStatement(ResultSet.TYPE_FORWARD_ ONLY,
ResultSet.CONCUR
_READ_ONLY); with driver version: [07.02.0009]
major version = 7
minor version = 1
Exception in thread "main" java.lang.AbstractMethodError:
COM.ibm.db2.jdbc.app.D
B2Connection.createStatement(II)Ljava/sql/Statement;
at TestDB2.test(TestDB2.java:22)
at TestDB2.main(TestDB2.java:7)

My questions are:

. What does this imply? What version of JDBC does the above driver
implement?
. What will it take for me to get a driver which will work with
version 7.2 and provide above functionality? I am assuming that I'd
need JDBC 2 functionality.
. How can I get/upgrade to such a driver?
. Or do I have to use DB2 version 8 to get this functionality?

Thanks