DB2 Type4 Driver and DB2 7 on OS390

[btt423]

Does anyone have any feedback on using the DB2 jdbc type4 driver for connecting to an OS390 DB2 v7 database?

I have been using the type 2, but would much rather use the type 4 if I can. In my testing, I have not run across any problems within my application. However, I have run into a couple of problems with visual database tools (DBVisualizer, Eclipse JFaceDBC plugin) connecting to the database correctly.

Due to the fact that I have run into problems in other tools, I'm a little hesitant to switch over my application.

Any advice?

 

[sedj]

problems ? errors ? stack traces ?

 

[btt423]

I'm not getting any stack traces, because I haven't run into any problems within my application as of yet. The error I receive from the visual database tools is an error complaining about a missing stored proc. Our DBA's are aware of this and think they have a patch for it.

Due to the fact that this error came up, it makes me think that other odd errors may be present that I'm not aware of yet. Everything I've seen online so far for the type 4 driver has pretty much been geared toward version 8 of DB2 UDB, so that increases my hesitancy as well.

I'm just curious if anybody else has had any problems with this setup.

 

[sedj]

Well, you should always use a driver that is specific to your db version. If there is a JDBC compliant driver available for your db, then I cannot see any problems with using it - it should behave like any other JDBC driver.