GeeCON Prague 2014*
The moose likes Websphere and the fly likes problem - db2 database configuration in datasource Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » Websphere
Bookmark "problem - db2 database configuration in datasource" Watch "problem - db2 database configuration in datasource" New topic
Author

problem - db2 database configuration in datasource

uma mahesh
Greenhorn

Joined: Jan 31, 2002
Posts: 11
database name url for oracle to connect remote database is
jdbc racle:thin:@hostName ort:serviceId
for db2 how to connect to remote database....
jdbc b2:-----------------
what we have to give...


IBM Certified - WebSphere V4.0
Jacqueline Qin
Greenhorn

Joined: Jan 11, 2002
Posts: 9
I think if I am not wrong, you just need to put jdbc b2 bname where dbname is your database name. You also need to create this connection in your DB2 Control Center. Go to your Control Center, expand to the databases node and right-click. Select "Add" and select the database.
uma mahesh
Greenhorn

Joined: Jan 31, 2002
Posts: 11
You are telling to add alias name in the control center and use it... but i dont want to create alias for my remote database. My aim is to remove hard coding.
I can connect to remote database by alias and give that name in connecting database. but the problem is if i shifted my application to client side again i have to configure alias for that i have to give user and password.
I want to eliminate entire thing and connect db2 using ip address. not through aliases..
could you please help me in this regards
just like in oracle
by ip and port of remote machine...
Subhash Reddy
Greenhorn

Joined: Feb 08, 2002
Posts: 10
In the properties , add the below properties and try :
serverName <your remote server IP address>
libraries <your library name>
Use the new jt400 driver.
Subhash Reddy
Greenhorn

Joined: Feb 08, 2002
Posts: 10
In the Data Source properties , add the below properties and try :
serverName "your remote server IP address"
libraries "your library name"
Use the new jt400 driver.
 
GeeCON Prague 2014
 
subject: problem - db2 database configuration in datasource