Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    1

    Unanswered: JDBC connection closed due to socket read timed out

    Hi,

    I'm having a random problem with the jdbc database connectivity. Seems like it's a network issue but still I have some doubts about it. The db connection gets closed because of a socket read timeout.
    This is experienced on both app server.

    Is there any property for the jdbc driver that would prevent it for being sensitive to network fluctuations?

    The traces on the db2 engine do not reveal any database availability problem during the timeframe.

    Any ideea on how to get a deeper insight?

    thanks in advance

    enviroment:
    Windows Server 2003 x86
    DB2 v9.5 fixpack 3
    Application: WebSphere Portal 6.0.2 running on Websphere application server 7.0 cluster - 2 nodes

    jdbc exception
    [9/29/11 14:42:06:110 EEST] 00000046 ConnectionEve A J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adapter for resource jdbc/relDS. The exception is: com.ibm.db2.jcc.b.tn: [jcc][t4][2030][11211][3.53.70] A communication error occurred during operations on the connection's underlying socket, socket input stream,
    or socket output stream. Error location: Reply.fill(). Message: Read timed out. ERRORCODE=-4499, SQLSTATE=08001:java.net.SocketTimeoutException: Read timed out
    Last edited by radu78; 09-29-11 at 11:30.

  2. #2
    Join Date
    Feb 2012
    Posts
    2

    Did you get it fixed? I'm having the same problem

    I'm having the same problem.

    The app server is running on Linux Server: Linux 2.6.18-238.9.1.el5 x86_64
    JDBC driver 'IBM Data Server Driver for JDBC and SQLJ' version 4.7.85

    Data Server: DB2:
    "DB2 v9.7.0.5", "s111017", "IP23285", and Fix Pack
    "5".

    After running my web application I get the following error:

    ERROR 19:41:12 [data.storage.AsynchronousStorage] Exception in asynchronous invocation JdbcLogStorageImpl2.publish: Cannot update distinct record created count: [jcc][t4][2030][11211][4.7.85] A communication error occurred during operations on the connection's underlying socket, socket input stream,
    [java] or socket output stream. Error location: Reply.fill(). Message: Connection timed out. ERRORCODE=-4499, SQLSTATE=08001
    [java] com.maketechnologies.dmw.transformer.DmwException: Cannot update distinct record created count: [jcc][t4][2030][11211][4.7.85] A communication error occurred during operations on the connection's underlying socket, socket input stream,
    [java] or socket output stream. Error location: Reply.fill(). Message: Connection timed out. ERRORCODE=-4499, SQLSTATE=08001
    [java] at com.maketechnologies.dmw.transformer.data.storage. log.JdbcLogStorageSummaryHelper.createLogSourceEnt itySummary(JdbcLogStorageSummaryHelper.java:166)
    [java] at com.maketechnologies.dmw.transformer.data.storage. log.JdbcLogStorageImpl2.prepareForClose(JdbcLogSto rageImpl2.java:319)
    [java] at com.maketechnologies.dmw.transformer.data.storage. log.JdbcLogStorageImpl2.publish(JdbcLogStorageImpl 2.java:227)
    [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
    [java] at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
    [java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    [java] at java.lang.reflect.Method.invoke(Method.java:597)
    [java] at com.maketechnologies.dmw.transformer.data.storage. AsynchronousStorage$MethodInvocation.call(Asynchro nousStorage.java:264)
    [java] at java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:303)
    [java] at java.util.concurrent.FutureTask****n(FutureTask.ja va:138)
    [java] at java.util.concurrent.Executors$RunnableAdapter.cal l(Executors.java:441)
    [java] at java.util.concurrent.FutureTask$Sync.innerRun(Futu reTask.java:303)
    [java] at java.util.concurrent.FutureTask****n(FutureTask.ja va:138)
    [java] at java.util.concurrent.ThreadPoolExecutor$Worker**** nTask(ThreadPoolExecutor.java:886)
    [java] at java.util.concurrent.ThreadPoolExecutor$Worker**** n(ThreadPoolExecutor.java:908)
    [java] at java.lang.Thread****n(Thread.java:662)

  3. #3
    Join Date
    Apr 2012
    Posts
    1,034
    Provided Answers: 18
    radu78: is the DB2-server also clustered, or does it have another HA option?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •