By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,237 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,237 IT Pros & Developers. It's quick & easy.

JDBC Driver Versions

P: n/a
We have installed DB2UDB 8.2 on a windows 2003 server. How can I
confirm the version of the JDBC driver that would have been installed
with this? I wasn;t sure if the JBDC driver would have a different
version/build then the DB version itself.

Thanks,
Bob Cook

Sep 13 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a

drudini wrote:
We have installed DB2UDB 8.2 on a windows 2003 server. How can I
confirm the version of the JDBC driver that would have been installed
with this? I wasn;t sure if the JBDC driver would have a different
version/build then the DB version itself.

Thanks,
Bob Cook
Versions of JDBC drivers may often evolve independently
of the DBMS. JDBC offers one standard call to determine
the driver version:

DatabaseMetaData.getDriverVersion()

You have to make a valid connection in order to make this
call. Otherwise, if you're good at decompiling, you can usually
find the static final string that determines this.

Joe Weinstein at BEA Systems

Sep 13 '06 #2

P: n/a
jo***********@gmail.com wrote:
DatabaseMetaData.getDriverVersion()

You have to make a valid connection in order to make this
call. Otherwise, if you're good at decompiling, you can usually
find the static final string that determines this.
I don't know if the output of getDriverVersion() is updated on each
fixpack (I guess it isn't). The best way to synchronize the driver on
the client is to deploy it with a batch after each fixpack.

From our experiences since 5.x/6.x, we're comparing filesize/date and
then the MD5 checksum. If they don't match, the driver is copied to the
client before the database connection is established.

Bernd
Sep 14 '06 #3

P: n/a
drudini wrote:
We have installed DB2UDB 8.2 on a windows 2003 server. How can I
confirm the version of the JDBC driver that would have been installed
with this? I wasn;t sure if the JBDC driver would have a different
version/build then the DB version itself.

Thanks,
Bob Cook
"db2jcc -version" will tell you the JCC driver version. "db2jcc -configuration"
will tell you everything you ever wanted to know about your configuration.

Jan M. Nelken
Sep 15 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.