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.  Websphere datasource connection failed to SQL Server 2008 with sqljdbc4.jar

    Posted Fri November 14, 2014 10:50 AM

    [11/14/14 13:18:46:007 IST] 00000057 LocalTranCoor E WLTC0017E: Resources rolled back due to setRollbackOnly() being called.
    [11/14/14 13:18:46:007 IST] 00000057 LocalExceptio E CNTR0020E: EJB threw an unexpected (non-declared) exception during invocation of method "getObjects" on bean "BeanId(FileNetEngine#Engine-ejb-ws.jar#Engine, null)". Exception data: com.filenet.api.exception.EngineRuntimeException: E_FAILED_TO_GET_DATASOURCE: Failed to get DataSource FNGCDDS.
    at com.filenet.engine.context.ServerCallContext.getConnectionWithRetry(ServerCallContext.java:942)
    at com.filenet.engine.context.ServerCallContext.getConnection(ServerCallContext.java:895)
    at com.filenet.engine.context.ServerCallContext._getDBContext(ServerCallContext.java:653)
    at com.filenet.engine.context.ServerCallContext.getDBContextFromJNDIValues(ServerCallContext.java:826)
    at com.filenet.engine.dbpersist.DBContext.determineDatabaseType(DBContext.java:661)
    at com.filenet.engine.gcd.GCDDBPersistence.(GCDDBPersistence.java:130)
    at com.filenet.engine.gcd.GCDPersistence.getGCDPersistence(GCDPersistence.java:171)
    at com.filenet.engine.gcd.GCD.initialize(GCD.java:226)
    at com.filenet.engine.gcd.GCD.domainAvailable(GCD.java:183)
    at com.filenet.engine.gcd.GCD.isDomainAvailable(GCD.java:119)
    at com.filenet.engine.jca.impl.RequestBrokerImpl.getUserName(RequestBrokerImpl.java:1289)
    at com.filenet.engine.ejb.EngineCoreBean._getUserName(EngineCoreBean.java:762)
    at com.filenet.engine.ejb.EngineCoreBean.getUserName(EngineCoreBean.java:744)
    at com.filenet.engine.ejb.EJSLocalStatelessEngineCore_22877cb1.getUserName(Unknown Source)
    at com.filenet.engine.ejb.EngineBean.processUserLicense(EngineBean.java:963)
    at com.filenet.engine.ejb.EngineBean.methodInit(EngineBean.java:175)
    at com.filenet.engine.ejb.EngineBean.getObjects(EngineBean.java:303)
    at com.filenet.apiimpl.transport.ejbstubs.EJSLocalStatelessEngine_2e64c374.getObjects(Unknown Source)
    at com.filenet.apiimpl.transport.ejb.EnginePortLocal.getObjects(EnginePortLocal.java:58)
    at com.filenet.apiimpl.wsi.ServiceSessionNst$1.run(ServiceSessionNst.java:1121)
    at java.security.AccessController.doPrivileged(AccessController.java:362)
    at javax.security.auth.Subject.doAs(Subject.java:573)
    at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:194)
    at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:151)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:611)
    at com.filenet.apiimpl.util.J2EEUtilWS.doAs(J2EEUtilWS.java:215)
    at com.filenet.apiimpl.wsi.ServiceSessionNst.sMakeInternalEJBCall(ServiceSessionNst.java:1004)
    at com.filenet.apiimpl.wsi.ServiceSessionNst.sHandleIncomingRequest(ServiceSessionNst.java:938)
    at com.filenet.engine.wsi.ListenerNst.service(ListenerNst.java:147)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:944)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:878)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:277)
    at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
    at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:816)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1660)
    Caused by: com.filenet.api.exception.EngineRuntimeException: E_UNEXPECTED_EXCEPTION: An unexpected exception was detected.
    at com.filenet.apiimpl.util.J2EEUtilWS.handleException(J2EEUtilWS.java:111)
    at com.filenet.apiimpl.util.J2EEUtilWS.doAs(J2EEUtilWS.java:219)
    at com.filenet.engine.context.ServerCallContext.getConnectionWithRetry(ServerCallContext.java:915)
    ... 54 more
    Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:611)
    at com.filenet.apiimpl.util.J2EEUtilWS.doAs(J2EEUtilWS.java:215)
    ... 55 more
    Caused by: java.security.PrivilegedActionException: 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.".DSRA0010E: SQL State = 08S01, Error Code = 0
    at java.security.AccessController.doPrivileged(AccessController.java:368)
    at javax.security.auth.Subject.doAs(Subject.java:573)
    at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:194)
    at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:151)
    ... 60 more
    Caused by: 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.".DSRA0010E: SQL State = 08S01, Error Code = 0
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
    at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:616)
    at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:678)
    at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2112)
    at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:2612)
    at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1695)
    at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:2086)
    at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1761)
    at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2636)
    at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:1064)
    at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:701)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:668)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:635)
    at com.filenet.engine.context.ServerCallContext$GetConnection.run(ServerCallContext.java:1430)
    at java.security.AccessController.doPrivileged(AccessController.java:362)
    ... 63 more
    ---- Begin backtrace for Nested Throwables
    java.sql.SQLException: 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.".DSRA0010E: SQL State = 08S01, Error Code = 0
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368)
    at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1412)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1058)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)
    at com.microsoft.sqlserver.jdbc.SQLServerDataSource.getConnectionInternal(SQLServerDataSource.java:577)
    at com.microsoft.sqlserver.jdbc.SQLServerPooledConnection.createNewConnection(SQLServerPooledConnection.java:60)
    at com.microsoft.sqlserver.jdbc.SQLServerPooledConnection.(SQLServerPooledConnection.java:42)
    at com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource.getPooledConnection(SQLServerConnectionPoolDataSource.java:34)
    at com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource.getPooledConnection(SQLServerConnectionPoolDataSource.java:24)
    at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:1334)
    at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
    at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:1371)
    at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:2608)
    at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1695)
    at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:2086)
    at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1761)
    at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2636)
    at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:1064)
    at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:701)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:668)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:635)
    at com.filenet.engine.context.ServerCallContext$GetConnection.run(ServerCallContext.java:1430)
    at java.security.AccessController.doPrivileged(AccessController.java:362)
    at javax.security.auth.Subject.doAs(Subject.java:573)
    at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:194)
    at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:151)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:611)
    at com.filenet.apiimpl.util.J2EEUtilWS.doAs(J2EEUtilWS.java:215)
    at com.filenet.engine.context.ServerCallContext.getConnectionWithRetry(ServerCallContext.java:915)
    at com.filenet.engine.context.ServerCallContext.getConnection(ServerCallContext.java:895)
    at com.filenet.engine.context.ServerCallContext._getDBContext(ServerCallContext.java:653)
    at com.filenet.engine.context.ServerCallContext.getDBContextFromJNDIValues(ServerCallContext.java:826)
    at com.filenet.engine.dbpersist.DBContext.determineDatabaseType(DBContext.java:661)
    at com.filenet.engine.gcd.GCDDBPersistence.(GCDDBPersistence.java:130)
    at com.filenet.engine.gcd.GCDPersistence.getGCDPersistence(GCDPersistence.java:171)
    at com.filenet.engine.gcd.GCD.initialize(GCD.java:226)
    at com.filenet.engine.gcd.GCD.domainAvailable(GCD.java:183)
    at com.filenet.engine.gcd.GCD.isDomainAvailable(GCD.java:119)
    at com.filenet.engine.jca.impl.RequestBrokerImpl.getUserName(RequestBrokerImpl.java:1289)
    at com.filenet.engine.ejb.EngineCoreBean._getUserName(EngineCoreBean.java:762)
    at com.filenet.engine.ejb.EngineCoreBean.getUserName(EngineCoreBean.java:744)
    at com.filenet.engine.ejb.EJSLocalStatelessEngineCore_22877cb1.getUserName(Unknown Source)
    at com.filenet.engine.ejb.EngineBean.processUserLicense(EngineBean.java:963)
    at com.filenet.engine.ejb.EngineBean.methodInit(EngineBean.java:175)
    at com.filenet.engine.ejb.EngineBean.getObjects(EngineBean.java:303)
    at com.filenet.apiimpl.transport.ejbstubs.EJSLocalStatelessEngine_2e64c374.getObjects(Unknown Source)
    at com.filenet.apiimpl.transport.ejb.EnginePortLocal.getObjects(EnginePortLocal.java:58)
    at com.filenet.apiimpl.wsi.ServiceSessionNst$1.run(ServiceSessionNst.java:1121)
    at java.security.AccessController.doPrivileged(AccessController.java:362)
    at javax.security.auth.Subject.doAs(Subject.java:573)
    at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:194)
    at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:151)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:60)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
    at java.lang.reflect.Method.invoke(Method.java:611)
    at com.filenet.apiimpl.util.J2EEUtilWS.doAs(J2EEUtilWS.java:215)
    at com.filenet.apiimpl.wsi.ServiceSessionNst.sMakeInternalEJBCall(ServiceSessionNst.java:1004)
    at com.filenet.apiimpl.wsi.ServiceSessionNst.sHandleIncomingRequest(ServiceSessionNst.java:938)
    at com.filenet.engine.wsi.ListenerNst.service(ListenerNst.java:147)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:944)
    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507)
    at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:878)
    at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)
    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)
    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.ready(HttpInboundLink.java:277)
    at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.sendToDiscriminators(NewConnectionInitialReadCallback.java:214)
    at com.ibm.ws.tcp.channel.impl.NewConnectionInitialReadCallback.complete(NewConnectionInitialReadCallback.java:113)
    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:816)
    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1660)
    Caused by: java.io.IOException: SQL Server did not return a response. The connection has been closed.
    at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.ensureSSLPayload(IOBuffer.java:513)
    at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.readInternal(IOBuffer.java:570)
    at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.read(IOBuffer.java:562)
    at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.readInternal(IOBuffer.java:757)
    at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.read(IOBuffer.java:745)
    at com.ibm.jsse2.b.a(b.java:286)
    at com.ibm.jsse2.b.a(b.java:67)
    at com.ibm.jsse2.SSLSocketImpl.a(SSLSocketImpl.java:313)
    at com.ibm.jsse2.SSLSocketImpl.h(SSLSocketImpl.java:63)
    at com.ibm.jsse2.SSLSocketImpl.a(SSLSocketImpl.java:316)
    at com.ibm.jsse2.SSLSocketImpl.startHandshake(SSLSocketImpl.java:220)
    at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1379)
    ... 85 more



  • 2.  Websphere datasource connection failed to SQL Server 2008 with sqljdbc4.jar

    Posted Thu April 30, 2015 05:10 PM
    Hello,

    This exception could be caused by a series of components. What version of WebSphere Application Server and MS JDBC driver are you using in the environment?

    First, I would check your Microsoft SQL Server DB version and WebSphere version against the versions listed in the following technote:

    www-01.ibm.com/support/docview.wss?uid=s...

    The protocol version defined could be causing this issue. In addition, there is a defect in version 2.0 of the MS SQL Server JDBC driver as noted in the following link:

    support.microsoft.com/en-us/kb/982512

    For resolution, I suggest checking protocal version and review the SSL configuration in your environment as a first step.

    #dWAnswerLive #answersLive 


  • 3.  Websphere datasource connection failed to SQL Server 2008 with sqljdbc4.jar

    Posted Fri May 08, 2015 11:30 AM
    Hi,

    The exception mentions SSL as the cause. There is certainly a certificate issue. Should you provide us more details on how are you implementing SSL during DB connection would help to find the cause.

    Regards
    Tousi