com.ibm.websphere.ce.cm.StaleConnectionException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=EXPLAIN;CURRENT DATE, TIME, TIMESTAMP, CURRENT_DATE, CURRENT_TIME, CUR, DRIVER=3.53.95DSRA0010E: SQL State = 42601, Error Code = -104

ibm.com | 4 months ago
  1. 0

    WebSphere:WebSphere Application Server:WAS 7 DB2 DataSource problem. - WebSphere Application Server Forum

    ibm.com | 4 months ago
    com.ibm.websphere.ce.cm.StaleConnectionException: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=EXPLAIN;CURRENT DATE, TIME, TIMESTAMP, CURRENT_DATE, CURRENT_TIME, CUR, DRIVER=3.53.95DSRA0010E: SQL State = 42601, Error Code = -104
  2. 0

    CannotGetJdbcConnectionException and StaleConnectionException problems

    Stack Overflow | 1 year ago | Karson074
    org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.ibm.websphere.ce.cm.StaleConnectionException: null DSRA0010E: SQL State = 56038, Error Code = -4,700
  3. 0

    SQL Server Exception

    Stack Overflow | 1 year ago | MKP
    com.ibm.websphere.ce.cm.StaleConnectionException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: SQL Server did not return a response. The connection has been closed..CWWRA0010E: SQL State = 08S01, Error Code = 0
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java获取远程服务器websphere数据源时报错,请帮忙看看! - 问题 - WebSphere中国社区

    webspherechina.net | 1 year ago
    com.ibm.websphere.ce.cm.StaleConnectionException: Io 异常: The Network Adapter could not establish the connectionDSRA0010E: SQL 状态:08006,错误码:17,002。
  6. 0

    IBM Getting DSRA0080E, "com.ibm.db2.jcc.b.SqlException: invalid operation: connection closed" due to DisconnectException - United States

    ibm.com | 7 months ago
    com.ibm.websphere.ce.cm.StaleConnectionException: A communication error has been detected. Communication protocol being used: UWReply.fill(). Communication API being used: recvBuff(). Location where the error was detected: ReasonCode=71. Communication function detecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS DB2ConnectionCorrelator: *LOCAL.db2inst1.050809212337

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.ibm.websphere.ce.cm.StaleConnectionException

      DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=EXPLAIN;CURRENT DATE, TIME, TIMESTAMP, CURRENT_DATE, CURRENT_TIME, CUR, DRIVER=3.53.95DSRA0010E: SQL State = 42601, Error Code = -104

      at com.ibm.ws.rsadapter.AdapterUtil.mapException()
    2. com.ibm.ws
      WSManagedConnectionFactoryImpl.createManagedConnection
      1. com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2142)
      2. com.ibm.ws.rsadapter.AdapterUtil.translateSQLException(AdapterUtil.java:1428)
      3. com.ibm.ws.rsadapter.spi.WSRdbDataSource.getConnection(WSRdbDataSource.java:2529)
      4. com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1606)
      4 frames
    3. com.ibm.ejs
      ConnectionManager.allocateConnection
      1. com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:2032)
      2. com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1709)
      3. com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2470)
      4. com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:1059)
      5. com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:696)
      5 frames
    4. com.ibm.ws
      WSJdbcDataSource.getConnection
      1. com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:668)
      2. com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:635)
      2 frames
    5. com.ibm.services
      CommonPatternsAction.execute
      1. com.ibm.services.epricer.framework.dao.jdbc.JDBCDAOFactory.getDAOSource(JDBCDAOFactory.java:106)
      2. com.ibm.services.epricer.framework.dao.jdbc.JDBCDAOObject.getConnection(JDBCDAOObject.java:25)
      3. com.ibm.services.epricer.settings.dao.jdbc.SQLTXDBTable.getDeletedRecords(SQLTXDBTable.java:90)
      4. com.ibm.services.epricer.settings.retrievequoteattachments.services.QuoteAttachmentsServiceImpl.retrieveQuoteAttachments(QuoteAttachmentsServiceImpl.java:56)
      5. com.ibm.services.epricer.settings.retrievequoteattachments.services.QuoteAttachmentsServiceProxy.retrieveQuoteAttachments(QuoteAttachmentsServiceProxy.java:57)
      6. com.ibm.services.epricer.settings.retrievequoteattachments.gui.SearchQuoteAttachmentsAction.commonGeoPatternExecute(SearchQuoteAttachmentsAction.java:110)
      7. com.ibm.services.epricer.settings.pattern.common.action.CommonPatternsAction.execute(CommonPatternsAction.java:75)
      7 frames