• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

How do I setup a DB2 datasource in WSAD test environment?

 
Ranch Hand
Posts: 38
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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 ]
 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
I don�t know whether it could help you. I have a somilar problem like you! But I have to install DB2-database in VAJ. I have to start "start/programmes/IBM DB2 /CommandLineprozessor or like this (translation from german) And than create db name(your db-name). Than as I start persistant_name_server and servlet_engine I wanted to start the ejb-server! And than I got a Exception like "Driver com.ibm....DBDriver could not be found"! So i have to install my windows and than DB2 and VAJ once more
PS. Tehre is a redbook "IBM WebSphere Commerce Studio for Windows NT and Windows 2000 Installation". You can read this!
 
reply
    Bookmark Topic Watch Topic
  • New Topic