Hi,
COM.ibm.db2.jdbc.app.DB2Driver

What jar should i use for this db2driver? Iam using db2java.jar . But i get errror message saying 'no suitable driver'.
Thanks in advance.

Know that You got it while installing db2 client. Look at "Programm Files\SQLLIB\java\db2java.zip" If your platform is windows. I dont know why DB2 developers renamed db2java.jar file to db2java.zip. I had just rename zip file back to jar and enjoy the work.

Thanks for your response.I tried renaming it but it still gives me "No Suitable driver".

Iam actually using db2 in a java application.In my local machine it is working fine with db2java.jar .But when i try to deploy it in production server, it is causing problems.

Any suggestion would appreciated.

I'm not sure if renaming the 'system' file is acceptable .. When you apply fixpaks, the db2java.jar file may not be updated .. Therefore your jdbc drivers may be out of step to the other db2 client components

Sandhya .. Sorry, are you sure it is the same bit of code you are trying to execute on both boxes ??


Cheers
Sathyaram

Thanks for your suggestions.
yes iam using the same bit of code. How do i make sure that i use the updated version of db2java.jar?

I solved the problem.Solution is to close the resultset and statements after its use in the code. Now it works perfect.
Thanks for all your help

Sandhya, Thanks for taking time to give your feedback ... It is much appreciated - Sathyaram

I GUESS because of some database management tool can detect jar file not zip file, so they have to rename the file to make it work. Example like SQuirreL-SQL.

Hopefully can help.

__________________________________________________ _______________
Home Services