which jdbc driver to use

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kavallin@hotmail.com - 30 Jan 2007 09:34 GMT

I wonder if anyone has compared the db2 universal jdbc driver type 2
and 4 with the legacy db2 driver. Which one is the best to use ? I'm
working in a project where the envm looks like this

Solaris 10
Websphere 6.1 with app
db2 connect 9 ============================> as/400 5.3

as/400 databases cataloged on db2 connect with auth SERVER_ENCRYPT

We have tested the following scenarios
1) using the universal jdbc driver and connect directly to the as/400
with securityMechanism enabled
2) using universal jdbc driver type 4 and connect to the database
cataloged on db2 connect with securityMechanism enabled
3) using the universal jdbc driver type 4 with webpshere connection
pool and connect to the database cataloged on db2 connect with
securityMechanism enabled

Should I do a test with the universal driver type 2 and/or the legacy
driver ?
/Roger

Reply to this Message

Phil Sherman - 30 Jan 2007 19:10 GMT

IBM has announced "no new features will be added to the legacy drivers".
This should be a factor in your decision.

Phil Sherman

> I wonder if anyone has compared the db2 universal jdbc driver type 2
> and 4 with the legacy db2 driver. Which one is the best to use ? I'm
[quoted text clipped - 18 lines]
> driver ?
> /Roger

Reply to this Message

andyhe - 31 Jan 2007 15:54 GMT

I found the DataDirect driver for db2 quite useful.
www.datadirect.com

Reply to this Message

Otto Carl Marte - 02 Feb 2007 13:39 GMT

> I found the DataDirect driver for db2 quite useful.www.datadirect.com

I would recommend the IBM Universal type 4 driver.
In our benchmarking (transaction processing), it outperformed the
DataDirect driver by miles.
But if performance is not a criteria, then the DataDirect driver is an
option.

Reply to this Message