Win a copy of Learning OpenStack Networking: Build a solid foundation in virtual networking technologies for OpenStack-based clouds this week in the Cloud/Virtualization forum!
  • 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

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?
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!