Sarah Chow

Hi!
I solved the problem by myself.
The reason of my problem was the URL of JDBC Driver
I set was incorrect.
The URL is needed to include the "systemName" of DB Server.
e.g.
URL -> jdbc:db2//hoge
which "hoge" is the "systemName" of DB Server.
After fixed, I was setting it into [DateSource] -> [DataBase].
BTW, the Online Manual of Websphere was hard for me to understand...T_T

Originally posted by Sarah Chow:

I also have the same problem.
I tried to have an JDBC Connection on DB2 7.1 with Websphere 3.5.
The WebSphere AppServer(RedHat6.2) and DB Server(RedHat6.2) are installed into two different machines.

Hi!
I also have the same problem.
I tried to have an JDBC Connection on DB2 7.1 with Websphere 3.5.
The WebSphere AppServer(RedHat6.2) and DB Server(RedHat6.2) are installed into two different machines.
I only copied the db2driver.zip into the AppServer.
My servlet got an error as "error loading COM.ibm.jdbc.app.DB2Driver".
The JTA of JDBC driver is disabled.
But it works well on an JDBC Connection without using Servlet.

Although I did added the classpath into the admin.conf or
the startupServer.sh.,it stil didn't work!
Does anyone give me any hint on how to setting-up the Websphere AppServer??
Thanks in advanced.

Originally posted by Rahul Mahindrakar:
You have to set the driver in the admin.conf as well as the
setupCmdLine.bat.
in the setupCmdline.bat file set the line
SET DB2DRIVER=C:\WebSphere\Appserver\lib\db2java.zip
i hope this helps