WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  WebSpphere application server connection timeout

    Posted Sun March 18, 2012 10:12 AM
    Hi All,

    Please help me, its urgent.

    We have initiated some process, after some time it's  got disconnected.

    I am getting below error's pls, suggest what could be the problem.


    WSJccConnecti W DSRA8650W: Error closing a JDBC
    child wrapper, com.ibm.ws.rsadapter.jdbc.
    WSJccPreparedStatement@28182818



    com.ibm.db2.jcc.b.SqlException: [jcc][10120][10943]
    [3.50.152] Invalid operation: statement is closed.
    ERRORCODE=-4470, SQLSTATE=null



    at com.ibm.db2.jcc.b.wc.a(wc.java:55)



    00000035 ConnectionEve A J2CA0056I: The Connection
    Manager received a fatal connection error from the Resource
    Adapter for resource GM_JNDI. The exception which was received is com.ibm.websphere.ce.cm.StaleConnectionException: [jcc]
    [t4][2030][11211][3.50.152] A communication error occurred
    during operations on the connection's underlying socket,
    socket input stream,



    or socket output stream. Error location: Reply.fill().
    Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001:com.ibm.db2.jcc.b.gm: [jcc][t4]
    [2030][11211][3.50.152] A communication error
    occurred during operations on the connection's
    underlying socket, socket input stream,



    or socket output stream. Error location: Reply.fill().
    Message: Insufficient data. ERRORCODE=-4499,
    SQLSTATE=08001



    JDBCException E org.hibernate.util.JDBCException
    Reporter logExceptions [jcc][t4][2030][11211]
    [3.50.152] A communication error occurred during
    operations on the connection's underlying socket,
    socket input stream,



    or socket output stream. Error location: Reply.fill().
    Message: Insufficient data. ERRORCODE=-4499,
    SQLSTATE=08001



    [3/18/12 13:16:10:728 IST] 00000035 JDBC
    Exception W org.hibernate.util.JDBCException
    Reporter logExceptions SQL Error: -4499, SQLState: 08001



    [3/18/12 13:16:10:728 IST] 00000035 JDBC
    Exception E org.hibernate.util.JDBCException
    Reporter logExceptions [jcc][t4][2030][11211]
    [3.50.152] A communication error occurred during
    operations on the connection's underlying socket, socket input stream,



    or socket output stream. Error location: Reply.fill().
    Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001




    com.ibm.websphere.ce.cm.StaleConnectionException:
    [jcc][t4][2030][11211][3.50.152] A communication error
    occurred during operations on the connection's underlying
    socket, socket input stream,



    or socket output stream. Error location: Reply.fill(). Message:
    Insufficient data. ERRORCODE=-4499, SQLSTATE=08001



    E J2CA0081E: Method destroy failed while trying to execute
    method destroy on ManagedConnection WSRdbManagedConnectionImpl@56725672 from resource
    No longer available. Caught exception: com.ibm.ws.exception.
    WsException: DSRA0080E: An exception was received by the
    Data Store Adapter. See original exception message: [jcc][t4]
    [2030][11211][3.50.152] A communication error occurred during
    operations on the connection's underlying socket, socket input stream,



    or socket output stream. Error location: Reply.fill(). Message:
    Insufficient data. ERRORCODE=-4499, SQLSTATE=08001.
    with SQL State : 08001 SQL Code : -4499



    at com.ibm.ws.rsadapter.exceptions.DataStoreAdapterException.
    setLinkedException(DataStoreAdapterException



    Any thing needs to tune at WAS connection pool.

    Please help me. Its urgent and  critical activity.

    Thanks,
    Chinna.




  • 2.  WebSpphere application server connection timeout

    Posted Mon March 19, 2012 12:35 PM
    Hi,

    It looks like error is getting logged for the stable connection received from Database server. Please also check this from Database admin and AD team to fine tune queries hitting database server.

    Thanks..

    Aziz