wood burning stoves 2.0*
The moose likes JDBC and the fly likes Websphere Application Server V6.1 connection problem with DB2 V8.1 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Websphere Application Server V6.1 connection problem with DB2 V8.1" Watch "Websphere Application Server V6.1 connection problem with DB2 V8.1" New topic
Author

Websphere Application Server V6.1 connection problem with DB2 V8.1

mayur shah
Greenhorn

Joined: Sep 07, 2007
Posts: 15
Hii everybody,

i have installed
* Websphere Application Server V6.1 on Linux Red Hat V4
* DB2 V8.1 on other machine with Linux Red Hat V5

I have deployed one application on the WAS. I want to connect WAS with DB2.

When i try to connect i get the following error:

La connexion test pour la source de donn�es Veratone Data Source sur le serveur server1 au noeud bpa-srv-05Node01 a �chou� avec l'exception suivante : java.lang.Exception: java.sql.SQLException: java.net.NoRouteToHostException : Error opening socket to server bpa-srv-06/192.168.4.245 on port 50000 with message : Aucun chemin d'acc�s pour atteindre l'h�te cible DB2ConnectionCorrelator: nullDSRA0010E: Etat SQL = null, Code d'erreur = -4 499. Consultez les journaux JVM pour obtenir plus de d�tails.

Seems like network problem but i am able to ping/telnet the other machine (DB2) from WAS machine.
can anyone help me out from this .
thanks for any help or hint

with regards

mayur
Raghavan Muthu
Ranch Hand

Joined: Apr 20, 2006
Posts: 3344

As you say you are able to ping from your WAS machine to DB2,i think it must be with the IP Address Vs DNS name conflict.

I also really don't know, but sometimes trying out with the IP Address instead of the hostname works! Can you please try this option?

Also, pinging is different from connecting to an application which is running on a specific port (in this case DB2 which listens on port# 50000).

Can you also please check in the DB2 machine whether the 'Remote access' (accessing from remote machine) is enabled in the DB2 Server Configuration?


Everything has got its own deadline including one's EGO!
[CodeBarn] [Java Concepts-easily] [Corey's articles] [SCJP-SUN] [Servlet Examples] [Java Beginners FAQ] [Sun-Java Tutorials] [Java Coding Guidelines]
mayur shah
Greenhorn

Joined: Sep 07, 2007
Posts: 15
thanks raghavan but i have sorted it out.

The problem was related to network configuration ie Firewall related.

anyways thanks

mayur
 
jQuery in Action, 2nd edition
 
subject: Websphere Application Server V6.1 connection problem with DB2 V8.1
 
Similar Threads
error starting websphere application server v6.1
Problem starting project on Websphere
Connecting WAS/WPS to DB2 database
Developing/Deploying/Acessing Portlets: Info/Help/Guidance required
WebSphere V6.1 Db2 V8.1 Connection Problem