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

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" <globetrotcom@yahoo.com> wrote in message
news:3316c084.0406100932.52f64796@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

Thanks Fan Ruo Xin!

There couldn't have been a better answer!

"Fan Ruo Xin" <fanruox@sbcglobal.net> wrote in message news:<Zg8yc.23106$eH1.10167253@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" <globetrotcom@yahoo.com> wrote in message
> news:3316c084.0406100932.52f64796@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