Db2

Db2

Connect with Db2, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

jt400 connection timeout issue

  • 1.  jt400 connection timeout issue

    Posted 4 hours ago

    Hi, I'm looking for some information on why my datasource connections are waiting on a response from the database and getting stuck in that state. I have an application that connects to a db2 datasource, using the jt400 driver from jtopen v7.10 to connect to DB2 database V5R4.The below errors happen with any connection to the data source through the driver. 

    <BEA-000337> <[STUCK] ExecuteThread
    : '52' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "671" seconds working on the request "Http Request Information: weblogic.servlet.internal.ServletRequestImpl@3a3dfc35[POST /jde/E1Menu.maf]
    ", which is more than the configured time (StuckThreadMaxTime) of "600" seconds in "server-failure-trigger". Stack trace:
    java.lang.Object.wait(Native Method)
    java.lang.Object.wait(Object.java:502)
    com.ibm.as400.access.AS400ThreadedServer.receive(AS400ThreadedServer.java:339)


    The connections never get returned to the datasource's connection pool, I assume because they are stuck in this waiting state.  



    ------------------------------
    Henry Owen
    ------------------------------