Dear All,
Can anybody let me know how to configure DataSource for a remote Database in WAS40 AE(i.e my .ear is running on one m/c and Database is running on other)
Do I need to use NET Driver of DB2 for the same or is there any other way?
Thanks in Advance
Dushyant Bhardwaj
-
Configuring Remote Database in Websphere (1 messages)
- Posted by: Dushyant Bhardwaj
- Posted on: December 24 2002 02:10 EST
Threaded Messages (1)
- Configuring Remote Database in Websphere by Web Master on December 24 2002 08:23 EST
-
Configuring Remote Database in Websphere[ Go to top ]
- Posted by: Web Master
- Posted on: December 24 2002 08:23 EST
- in response to Dushyant Bhardwaj
Probably the best option (since DB2 is already running where your app is) is to configure a connection to the remote DB using the DB2 control center or cmd line processor. Then configure a DataSource in WebSphere using COM.ibm.db2.jdbc.DB2ConnectionPoolDataSource as the implementation class. When you install the driver, put db2java.zip in the classpath.
You can use the net driver, but you will need the DB2 applet server server running on the db server. The net driver is type 3.
You could also purchase a type 4 driver from someone like hit software (http://www.hitsw.com) and connect directly to your remote db).
HTH