• Post Reply Bookmark Topic Watch Topic
  • New Topic

The application requester cannot establish the connection. (connect timed out)  RSS feed

 
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Flow description: The msgflow is invoked after every 120 second and the JCN inserts or update the data to the table.It was working fine previously,not sure what has haapned. I have commeted the conn() statement as msg broker closes the connection by itself. Below are the details of error

09 Jun 2014 13:58:56,941 INFO [MsgFlowname] Broker excpetion[BIPmsgs:6233]BIP6233E: An error occurred in node: Thread 'Thread[Thread-11,5,main]' There was a problem establishing a connection to the given database URL: jdbc:as400://XXX.XXX.XX;naming=system;prompt=false;transaction isolation=none;user=XXXX;password=xxxxxxxx; Exception details: error message: The application requester cannot establish the connection. (connect timed out), SQLState value: 08001, vendor's error code: -99999, stack trace: [com.ibm.as400.access.JDError.throwSQLException(JDError.java:561)
com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3342)
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSource.java:720)
com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSource.java:693)
com.ibm.as400.access.AS400JDBCXADataSource.getXAConnection(AS400JDBCXADataSource.java:145)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.createXAConnection(JDBCType4Connection.java:244)
com.ibm.broker.jdbctype4.jdbcdbasemgr.JDBCType4Connection.getT4NodeConnection(JDBCType4Connection.java:1242)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:296)
com.ibm.broker.jdbctype4.localtrxn.JDBCType4SinglePhaseTrxnHandler.getConnection(JDBCType4SinglePhaseTrxnHandler.java:154)
com.ibm.broker.jdbctype4.connfact.JDBCType4ConnectionFactory.getConnection(JDBCType4ConnectionFactory.java:163)
sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
java.lang.reflect.Method.invoke(Method.java:602)
com.ibm.broker.plugin.MbNode.getJDBCType4Connection(MbNode.java:1564)
xx.xxxx.xxxx.JCNMethod(javaMethod.java:46)
com.ibm.broker.javacompute.MbRuntimeJavaComputeNode.evaluate(MbRuntimeJavaComputeNode.java:281)
com.ibm.broker.plugin.MbNode.evaluate(MbNode.java:1480)]

The node was unable to establish a connection to the given database URL.

Contact your IBM Integration Bus administrator. : Problem encountered obtaining JDBC connection 2014-06-09 13:58:41.935


 
Sheriff
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It looks like either the DB server is down or some firewalls rules are blocking you access to it. Have you tried doing a telnet from the machine where you are running this code, to the DB server/port combination?
 
Pushkar Mahamuni
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have pinged the server and getting correct reponse,what else I can try. I am using Jt400.jar version 8.2. If there is issue with Client's firewall setting then how can I proove it?
 
Jaikiran Pai
Sheriff
Posts: 10447
227
IntelliJ IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ping uses a different protocol. Did you try telnet to that ip/hostname and port?

Also, have you checked with your DB/system admin?
 
Pushkar Mahamuni
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i did telent then it was asking the user id ,password,procedure name. What exactly I need to ask DB admin?
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!