Hi,
I want to setup a DB2 datasource for my WebSphere Studio Appl Development Client's (V4.0)
test Application Server. The DB2 database I want to access is on an AS400 (V5R1). My guess is that I do this on the Server Perspective in the Server Configuration box. I double click on WebSphere Admin Domain under Server Configurations and then select the data sources tab.
On the data sources panel it has three areas: the
JDBC Driver List, the Data Source defined in the JDBC driver, and the Resource Properties defined in the data source.
In the JDBC Driver List area I have the default entries (created automatically when the server was created) of:
Db2JdbcDriver(COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource)
idbJdbcDriver(com.ibm.ejs.cm.portability.IDBConnectionPoolDataSource)
In the Datasource Defined in the JDBC Driver area I have a single entry for the Db2JdbcDriver which is Session Persistence Datasource (jdbc/Session).
Currently, when I edit the Db2JdbcDriver it shows:
Name: Db2JdbcDriver
Desc: DB2 JDBC Driver
Implementation class name: COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource
URL prefix: jdbc: db2
Class path: C:\Program Files\SQLLIB\java\db2\db2java.zip
The AS400 driver that I want to use (I think) is
Java Toolbox for the AS400 driver AS400JDBCDriver in the JT400.jar file. I got that from the AS400's QIBM/ProdData/HTTP/Public/jt400/lib directory.
(1) Do I need to download that jar file to my PC inorder to use it in the WASD WAS test environment or can I leave it on the as400 and use network drive to access it?
(2) Either way, what changes/additions should I make to the WSAD's server configuration inorder to setup a database connection pool datasource for the AS400's DB2 database?
(3) I understand that the driver needs to be in my classpath, but I am not sure on how to do that. Help?
I have search everywhere for this information but all I am finding is how to access and use a datasource in a
servlet and nothing about setting up the datasource in a WSAD test server environment.
Thanks,
Reed Peters
[ October 24, 2002: Message edited by: Reed Peters ]
[ October 24, 2002: Message edited by: Reed Peters ]
[ October 24, 2002: Message edited by: Reed Peters ]