We have a java program that calls db2 on our solaris/unix server. If I login as user1 and run it it works, but if I login as user2 and try to run it, it throws a "No Suitable Driver" error. So it looks like a classpath issue, BUT i am able to compile the code under both logins just fine which means it is able to find the db2 db2java.zip driver, right?
Now we need to move the program over to redhat linux enterprise, again i setup the classpath etc.. and it compiles fine but when i try to run it I get the same "No Suitable Driver" error.
The Class.forName path is"COM.ibm.db2.jdbc.app.DB2Driver"; I am almost 100% certain this is not the issue and dont want to change it unless it will fix the problem.
I am a bit unsure where to begin now to fix this problem, the driver is in the classpath after all and the class.forname is correct. What else could be causing this error?