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 | 8 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

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

    ibm.com | 8 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

    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