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

which jdbc driver to use

P: n/a
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

Jan 30 '07 #1
Share this Question
Share on Google+
3 Replies


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

Phil Sherman
ka******@hotmail.com wrote:
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
Jan 30 '07 #2

P: n/a
I found the DataDirect driver for db2 quite useful.
www.datadirect.com

Jan 31 '07 #3

P: n/a
On Jan 31, 5:54 pm, "andyhe" <andyhenos...@skynet.bewrote:
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.

Feb 2 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.