10 Replies Latest reply: Nov 8, 2012 4:15 AM by user9961531 RSS

    'No more data to read from socket' Exception after inactivity (WLS, JDBC)

    user9961531
      Used Technologies:
      - Oracle WeblogicServer 12
      - Orcle DB (version?)
      - Ibatis as an OR Mapping tool
      - JAX-WS for the SOAP Stack

      We are running a SOAP Provider on a Weblogic 12 Server and are using a WLS configured JDBC DataSource to connect to our database.

      The first call issued to the service after a certain amount of inactivity (e.g. a night) creates a 'No more data to read from the socket' Exception (see StackTrace below). This error is reproduce able.

      What is happening? Is an old connection being used? Does the session terminate beforehand? Is there a WLS-JDBC setting, which will allow the first call to go through?

      Many thanks in advance for your help.

      ####<Jul 18, 2012 1:21:07 PM CEST> <Info> <EJB> <rbals72.bas.roche.com> <rbals72_dev_kerna4> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <irci10> <> <> <1342610467855> <BEA-011062> <The following exception has occurred:

      javax.transaction.SystemException: Heuristic hazard: (MOSAIC_WS_USEROraclePoolDataSource_DEV_KERNA4, HeuristicHazard, (javax.transaction.xa.XAException: Two rollbacks failed. The first one threw No more data to read from socket. The second one threw No more data to read from socket))
           at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:455)
           at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:420)
           at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:499)
           at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:447)
           at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:248)
           at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:202)
           at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:44)
           at com.roche.research.mosaic.impl.ejb.impl.MosaicEJBImpl_k2s1ls_MosaicEJBImpl.getAvailability(Unknown Source)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at com.roche.research.mosaic.impl.ws.AbstractWebServiceImpl$LoggingInvocationHandler.invoke(AbstractWebServiceImpl.java:192)
           at $Proxy122.getAvailability(Unknown Source)
           at com.roche.research.mosaic.impl.ws.MosaicWSImpl.getAvailability(MosaicWSImpl.java:119)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
           at weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
           at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:149)
           at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
           at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:892)
           at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:841)
           at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:804)
           at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:706)
           at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:430)
           at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:640)
           at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:265)
           at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:163)
           at weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:171)
           at weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
           at weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
           at weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
           at weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
           at weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
           at weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:352)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:235)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3254)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
           at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2089)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1512)
           at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

      ####<Jul 18, 2012 1:21:07 PM CEST> <Notice> <EJB> <rbals72.bas.roche.com> <rbals72_dev_kerna4> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <irci10> <> <> <1342610467859> <BEA-010014> <Error occurred while attempting to rollback transaction: javax.transaction.SystemException: Heuristic hazard: (MOSAIC_WS_USEROraclePoolDataSource_DEV_KERNA4, HeuristicHazard, (javax.transaction.xa.XAException: Two rollbacks failed. The first one threw No more data to read from socket. The second one threw No more data to read from socket))
      javax.transaction.SystemException: Heuristic hazard: (MOSAIC_WS_USEROraclePoolDataSource_DEV_KERNA4, HeuristicHazard, (javax.transaction.xa.XAException: Two rollbacks failed. The first one threw No more data to read from socket. The second one threw No more data to read from socket))
           at weblogic.transaction.internal.ServerTransactionImpl.internalRollback(ServerTransactionImpl.java:455)
           at weblogic.transaction.internal.ServerTransactionImpl.rollback(ServerTransactionImpl.java:420)
           at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:499)
           at weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:447)
           at weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:248)
           at weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:202)
           at weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:44)
           at com.roche.research.mosaic.impl.ejb.impl.MosaicEJBImpl_k2s1ls_MosaicEJBImpl.getAvailability(Unknown Source)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at com.roche.research.mosaic.impl.ws.AbstractWebServiceImpl$LoggingInvocationHandler.invoke(AbstractWebServiceImpl.java:192)
           at $Proxy122.getAvailability(Unknown Source)
           at com.roche.research.mosaic.impl.ws.MosaicWSImpl.getAvailability(MosaicWSImpl.java:119)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
           at java.lang.reflect.Method.invoke(Method.java:597)
           at weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
           at weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
           at com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:149)
           at com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
           at com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:892)
           at com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:841)
           at com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:804)
           at com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:706)
           at com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:430)
           at com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:640)
           at com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:265)
           at com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:163)
           at weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:171)
           at weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
           at weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
           at weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
           at weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
           at weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
           at weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
           at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
           at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
           at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:352)
           at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:235)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
           at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3254)
           at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
           at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
           at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
           at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
           at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2089)
           at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
           at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1512)
           at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254)
           at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
           at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
        • 1. Re: 'No more data to read from socket' Exception after inactivity (WLS, JDBC)
          user9961531
          Does nobody have an answer for this question?
          • 2. Re: 'No more data to read from socket' Exception after inactivity (WLS, JDBC)
            Kalyan Pasupuleti-Oracle
            Hi,

            Under Datasource you will find Transaction block.

            enable set XA Transaction and keep setXATransactiontimeout as zero and increase Global transaction under Domain.

            This will avoid such rollaback and socket exception.

            One more enable Tunneling on every individual server.

            Regards,
            Kal
            • 3. Re: 'No more data to read from socket' Exception after inactivity (WLS, JDBC)
              user9961531
              Hey Kal!!

              Many thanks!

              I'm a newbe to WLS (using 12c), hence I have another question which may be very basic.

              Where can I set this property? I tried setting it on my existing data source connection & couldn't find it. Also when creating a new connection I couldn't find it.

              I'm using a 'Thin for Service connections' connection type. Also the 'Thin XA for Service connections' does not have the options you mentioned.

              In advance many thanks for your answer!!

              Alex
              • 4. Re: 'No more data to read from socket' Exception after inactivity (WLS, JDBC)
                Kalyan Pasupuleti-Oracle
                Hi,

                Click on your Data source.

                Data source >> Transactions

                Under this you will find SetXATransaction timeout option.

                Please set there.

                Still if you have query please let me know.

                Regards,
                Kal
                • 5. Re: 'No more data to read from socket' Exception after inactivity (WLS, JDBC)
                  user9961531
                  Hey Kal!

                  My Transaction Tab only holds the following options:
                  - Supports Global Transactions (Checkbox)
                  - Logging Last Resource/Emulate Two-Phase Commit/One-Phase Commit

                  Unfortunately I cannot find the Option 'SetXATransaction timeout'.

                  Could it be that I have the wrong type of connection?

                  Many thanks again for your help!

                  - Alex
                  • 6. Re: 'No more data to read from socket' Exception after inactivity (WLS, JDBC)
                    Kalyan Pasupuleti-Oracle
                    Hi Alex,

                    but error says that your using XA.

                    but you mentioned that your are not using non-XA data source.

                    Can you paste me the Datsource moudle xml file which is available under %Domain_Home% / config / jdbc.

                    Let me check your DS once and then we can start tune the DS there.

                    Regards,
                    Kal
                    • 7. Re: 'No more data to read from socket' Exception after inactivity (WLS, JDBC)
                      user9961531
                      Hi Kal!

                      The following is my JDBC configuration found under config/jdbc/:

                      <jdbc-data-source xmlns="http://xmlns.oracle.com/weblogic/jdbc-data-source" xmlns:sec="http://xmlns.oracle.com/weblogic/security" xmlns:wls="http://xmlns.oracle.com/weblogic/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/jdbc-data-source http://xmlns.oracle.com/weblogic/jdbc-data-source/1.2/jdbc-data-source.xsd">
                      <name>MOSAIC_WS_USEROraclePoolDataSource</name>
                      <jdbc-driver-params>
                      <url>jdbc:oracle:thin:@XXX:1521/ISDEV</url>
                      <driver-name>oracle.jdbc.OracleDriver</driver-name>
                      <properties>
                      <property>
                      <name>user</name>
                      <value>mosaic_webservices_read</value>
                      </property>
                      </properties>
                      <password-encrypted>{AES}WMZjXoZrUDMTsNuZWs3Cjih5h2bOTK71/iGK9Ve8YFg=</password-encrypted>
                      </jdbc-driver-params>
                      <jdbc-connection-pool-params>
                      <max-capacity>50</max-capacity>
                      <test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>
                      </jdbc-connection-pool-params>
                      <jdbc-data-source-params>
                      <jndi-name>MOSAIC_WS_USEROraclePoolDataSource</jndi-name>
                      <global-transactions-protocol>OnePhaseCommit</global-transactions-protocol>
                      </jdbc-data-source-params>
                      </jdbc-data-source>
                      • 8. Re: 'No more data to read from socket' Exception after inactivity (WLS, JDBC)
                        Kalyan Pasupuleti-Oracle
                        Hi ,

                        But above exception was showing different DataSource.

                        MOSAIC_WS_USEROraclePoolDataSource_DEV_KERNA4


                        Where you are showing me configuration of MOSAIC_WS_USEROraclePoolDataSource.

                        Can you confirm the Datasource one more time.

                        Regards,
                        Kal
                        • 9. Re: 'No more data to read from socket' Exception after inactivity (WLS, JDBC)
                          user9961531
                          Hey Kal!

                          Excuse the delayed response.

                          We are running multiple domains on our server. In my configuration UI the name of the configuration is MOSAIC_WS_USEROraclePoolDataSource -
                          as it seems, the server internally adds the domain name (e.g. DEV_KERNA4) to the end of the datasource name. Hence the difference.

                          In the meanwhile I have edited the configuration to not use a global transaction protocol. Still the exception occurs, but the stack and cause is a different one.

                          What do you make of this behaviour?

                          Many thanks in advance! - Alex.

                          <?xml version='1.0' encoding='UTF-8'?>
                          <jdbc-data-source xmlns="http://xmlns.oracle.com/weblogic/jdbc-data-source" xmlns:sec="http://xmlns.oracle.com/weblogic/security" xmlns:wls="http://xmlns.oracle.com/weblogic/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/jdbc-data-source http://xmlns.oracle.com/weblogic/jdbc-data-source/1.2/jdbc-data-source.xsd">
                          <name>MOSAIC_WS_USEROraclePoolDataSource</name>
                          <jdbc-driver-params>
                          <url>jdbc:oracle:thin:@jelinek2.bas.roche.com:1521/ISDEV</url>
                          <driver-name>oracle.jdbc.OracleDriver</driver-name>
                          <properties>
                          <property>
                          <name>user</name>
                          <value>mosaic_webservices_read</value>
                          </property>
                          </properties>
                          <password-encrypted>{AES}WMZjXoZrUDMTsNuZWs3Cjih5h2bOTK71/iGK9Ve8YFg=</password-encrypted>
                          </jdbc-driver-params>
                          <jdbc-connection-pool-params>
                          <max-capacity>50</max-capacity>
                          <test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>
                          </jdbc-connection-pool-params>
                          <jdbc-data-source-params>
                          <jndi-name>MOSAIC_WS_USEROraclePoolDataSource</jndi-name>
                          <global-transactions-protocol>None</global-transactions-protocol>
                          </jdbc-data-source-params>
                          </jdbc-data-source>

                          null
                          $Proxy129.getAvailability(Unknown Source)
                          com.roche.research.mosaic.impl.ws.MosaicWSImpl.getAvailability(MosaicWSImpl.java:119)
                          sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                          sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                          sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                          java.lang.reflect.Method.invoke(Method.java:597)
                          weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
                          weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
                          com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:149)
                          com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
                          com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:892)
                          com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:841)
                          com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:804)
                          com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:706)
                          com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:430)
                          com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:640)
                          com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:265)
                          com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:164)
                          weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:172)
                          weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
                          weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
                          weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
                          weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
                          weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
                          weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
                          weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
                          weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
                          javax.servlet.http.HttpServlet.service(HttpServlet.java:845)
                          weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
                          weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
                          weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
                          weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:352)
                          weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:236)
                          weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
                          weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3254)
                          weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                          weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                          weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
                          weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
                          weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2091)
                          weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
                          weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1512)
                          weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
                          weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                          weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                          null
                          sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                          sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                          sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                          java.lang.reflect.Method.invoke(Method.java:597)
                          com.roche.research.mosaic.impl.ws.AbstractWebServiceImpl$LoggingInvocationHandler.invoke(AbstractWebServiceImpl.java:192)
                          $Proxy129.getAvailability(Unknown Source)
                          com.roche.research.mosaic.impl.ws.MosaicWSImpl.getAvailability(MosaicWSImpl.java:119)
                          sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                          sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                          sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                          java.lang.reflect.Method.invoke(Method.java:597)
                          weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
                          weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
                          com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:149)
                          com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
                          com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:892)
                          com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:841)
                          com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:804)
                          com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:706)
                          com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:430)
                          com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:640)
                          com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:265)
                          com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:163)
                          weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:171)
                          weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
                          weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
                          weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
                          weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
                          weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
                          weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
                          weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
                          weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
                          javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
                          weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
                          weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
                          weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
                          weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:352)
                          weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:235)
                          weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
                          weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3254)
                          weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                          weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                          weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
                          weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
                          weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2089)
                          weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
                          weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1512)
                          weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254)
                          weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                          weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                          EJB Exception:
                          weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:453)
                          weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:248)
                          weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:202)
                          weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:44)
                          com.roche.research.mosaic.impl.db.ibatis.impl.AvailabilityDAOImpl_grcm00_AvailabilityDAOImpl.findAvailableErnsByCrnOrSrn(Unknown Source)
                          com.roche.research.mosaic.impl.service.impl.PowderAvailabilityServiceImpl.findAvailableErnsByCrnOrSrn(PowderAvailabilityServiceImpl.java:74)
                          com.roche.research.mosaic.impl.service.impl.PowderAvailabilityServiceImpl.createErnAvailabilityResultFromCrnOrSrn(PowderAvailabilityServiceImpl.java:100)
                          com.roche.research.mosaic.impl.service.impl.PowderAvailabilityServiceImpl.retrieveResultList(PowderAvailabilityServiceImpl.java:48)
                          com.roche.research.mosaic.impl.service.impl.PowderAvailabilityServiceImpl_9fmylc_PowderAvailabilityServiceImpl.__WL_invoke(Unknown Source)
                          weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                          com.roche.research.mosaic.impl.service.impl.PowderAvailabilityServiceImpl_9fmylc_PowderAvailabilityServiceImpl.retrieveResultList(Unknown Source)
                          com.roche.research.mosaic.impl.service.impl.AvailabilityServiceImpl.retrieveResultList(AvailabilityServiceImpl.java:39)
                          com.roche.research.mosaic.impl.service.impl.AvailabilityServiceImpl_raolkw_AvailabilityServiceImpl.__WL_invoke(Unknown Source)
                          weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                          com.roche.research.mosaic.impl.service.impl.AvailabilityServiceImpl_raolkw_AvailabilityServiceImpl.retrieveResultList(Unknown Source)
                          com.roche.research.mosaic.impl.ejb.impl.MosaicEJBImpl.getAvailability(MosaicEJBImpl.java:40)
                          com.roche.research.mosaic.impl.ejb.impl.MosaicEJBImpl_k2s1ls_MosaicEJBImpl.__WL_invoke(Unknown Source)
                          weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                          com.roche.research.mosaic.impl.ejb.impl.MosaicEJBImpl_k2s1ls_MosaicEJBImpl.getAvailability(Unknown Source)
                          sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                          sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                          sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                          java.lang.reflect.Method.invoke(Method.java:597)
                          com.roche.research.mosaic.impl.ws.AbstractWebServiceImpl$LoggingInvocationHandler.invoke(AbstractWebServiceImpl.java:192)
                          $Proxy129.getAvailability(Unknown Source)
                          com.roche.research.mosaic.impl.ws.MosaicWSImpl.getAvailability(MosaicWSImpl.java:119)
                          sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                          sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                          sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                          java.lang.reflect.Method.invoke(Method.java:597)
                          weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
                          weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
                          com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:149)
                          com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
                          com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:892)
                          com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:841)
                          com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:804)
                          com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:706)
                          com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:430)
                          com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:640)
                          com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:265)
                          com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:164)
                          weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:172)
                          weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
                          weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
                          weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
                          weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
                          weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
                          weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
                          weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
                          weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
                          javax.servlet.http.HttpServlet.service(HttpServlet.java:845)
                          weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
                          weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
                          weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
                          weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:352)
                          weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:236)
                          weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
                          weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3254)
                          weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                          weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                          weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
                          weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
                          weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2091)
                          weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
                          weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1512)
                          weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
                          weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                          weblogic.work.ExecuteThread.run(ExecuteThread.java:221)


                          --- The error occurred in resources/ibatis/availability.xml.
                          --- The error occurred while applying a parameter map.
                          --- Check the mosaic.availability.findAvailableErnsByCrnOrSrn-InlineParameterMap.
                          --- Check the statement (query failed).
                          --- Cause: java.sql.SQLRecoverableException: No more data to read from socket
                          com.roche.research.mosaic.impl.db.ibatis.impl.AvailabilityDAOImpl.findAvailableErnsByCrnOrSrn(AvailabilityDAOImpl.java:41)
                          com.roche.research.mosaic.impl.db.ibatis.impl.AvailabilityDAOImpl_grcm00_AvailabilityDAOImpl.__WL_invoke(Unknown Source)
                          weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                          com.roche.research.mosaic.impl.db.ibatis.impl.AvailabilityDAOImpl_grcm00_AvailabilityDAOImpl.findAvailableErnsByCrnOrSrn(Unknown Source)
                          com.roche.research.mosaic.impl.service.impl.PowderAvailabilityServiceImpl.findAvailableErnsByCrnOrSrn(PowderAvailabilityServiceImpl.java:74)
                          com.roche.research.mosaic.impl.service.impl.PowderAvailabilityServiceImpl.createErnAvailabilityResultFromCrnOrSrn(PowderAvailabilityServiceImpl.java:100)
                          com.roche.research.mosaic.impl.service.impl.PowderAvailabilityServiceImpl.retrieveResultList(PowderAvailabilityServiceImpl.java:48)
                          com.roche.research.mosaic.impl.service.impl.PowderAvailabilityServiceImpl_9fmylc_PowderAvailabilityServiceImpl.__WL_invoke(Unknown Source)
                          weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                          com.roche.research.mosaic.impl.service.impl.PowderAvailabilityServiceImpl_9fmylc_PowderAvailabilityServiceImpl.retrieveResultList(Unknown Source)
                          com.roche.research.mosaic.impl.service.impl.AvailabilityServiceImpl.retrieveResultList(AvailabilityServiceImpl.java:39)
                          com.roche.research.mosaic.impl.service.impl.AvailabilityServiceImpl_raolkw_AvailabilityServiceImpl.__WL_invoke(Unknown Source)
                          weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                          com.roche.research.mosaic.impl.service.impl.AvailabilityServiceImpl_raolkw_AvailabilityServiceImpl.retrieveResultList(Unknown Source)
                          com.roche.research.mosaic.impl.ejb.impl.MosaicEJBImpl.getAvailability(MosaicEJBImpl.java:40)
                          com.roche.research.mosaic.impl.ejb.impl.MosaicEJBImpl_k2s1ls_MosaicEJBImpl.__WL_invoke(Unknown Source)
                          weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                          com.roche.research.mosaic.impl.ejb.impl.MosaicEJBImpl_k2s1ls_MosaicEJBImpl.getAvailability(Unknown Source)
                          sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                          sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                          sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                          java.lang.reflect.Method.invoke(Method.java:597)
                          com.roche.research.mosaic.impl.ws.AbstractWebServiceImpl$LoggingInvocationHandler.invoke(AbstractWebServiceImpl.java:192)
                          $Proxy129.getAvailability(Unknown Source)
                          com.roche.research.mosaic.impl.ws.MosaicWSImpl.getAvailability(MosaicWSImpl.java:119)
                          sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                          sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                          sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                          java.lang.reflect.Method.invoke(Method.java:597)
                          weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
                          weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
                          com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:149)
                          com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
                          com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:892)
                          com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:841)
                          com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:804)
                          com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:706)
                          com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:430)
                          com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:640)
                          com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:265)
                          com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:164)
                          weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:172)
                          weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
                          weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
                          weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
                          weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
                          weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
                          weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
                          weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
                          weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
                          javax.servlet.http.HttpServlet.service(HttpServlet.java:845)
                          weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
                          weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
                          weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
                          weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:352)
                          weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:236)
                          weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
                          weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3254)
                          weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                          weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                          weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
                          weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
                          weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2091)
                          weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
                          weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1512)
                          weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
                          weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                          weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
                          ...
                          • 10. Re: 'No more data to read from socket' Exception after inactivity (WLS, JDBC)
                            user9961531
                            Hey Kal!

                            Sorry for the late follow up (this thread started in July!!).

                            This problem is still occurring. The scenario is always the same: WS-calls work fine until a long pause (e.g. one night) takes place, in which no WS-requests are been issued.

                            I'm assuming it has something to do with my transactions - although I have disabled them. But still, it seems as if the application tries to access a staled JDBC connection from the pool - & the application server does not close/refresh or create a new connection, but just passes on the staled instance.

                            The application is a WS-provider using stateless session beans to access the business logic, which in return accesses the database. Maybe I need to adapt the EJBs transaction settings..?

                            Below you'll find the datasource as well as the stack trace.

                            I'd be really thankful for any help!!

                            All the best - LX.

                            The datasource is the following:

                            <?xml version='1.0' encoding='UTF-8'?>
                            <jdbc-data-source xmlns="http://xmlns.oracle.com/weblogic/jdbc-data-source" xmlns:sec="http://xmlns.oracle.com/weblogic/security" xmlns:wls="http://xmlns.oracle.com/weblogic/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/jdbc-data-source http://xmlns.oracle.com/weblogic/jdbc-data-source/1.2/jdbc-data-source.xsd">
                            <name>MOSAIC_WS_USEROraclePoolDataSource</name>
                            <jdbc-driver-params>
                            <url>jdbc:oracle:thin:@JELINEK-SCAN.BAS.ROCHE.COM:1521/ISTST</url>
                            <driver-name>oracle.jdbc.OracleDriver</driver-name>
                            <properties>
                            <property>
                            <name>user</name>
                            <value>mosaic_webservices_read</value>
                            </property>
                            </properties>
                            <password-encrypted>{AES}rjRxI2H+amWwoVIUkc61aGRlhhyh0EY4hYf+TDaeIyo=</password-encrypted>
                            </jdbc-driver-params>
                            <jdbc-connection-pool-params>
                            <max-capacity>50</max-capacity>
                            <test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>
                            </jdbc-connection-pool-params>
                            <jdbc-data-source-params>
                            <jndi-name>MOSAIC_WS_USEROraclePoolDataSource</jndi-name>
                            <global-transactions-protocol>None</global-transactions-protocol>
                            </jdbc-data-source-params>
                            </jdbc-data-source>

                            The stack trace:

                            java.lang.reflect.UndeclaredThrowableException
                            $Proxy108.handleBarcodes(Unknown Source)
                            com.roche.research.mosaic.ws.MosaicWSImpl.getPlateLayout(MosaicWSImpl.java:78)
                            sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                            java.lang.reflect.Method.invoke(Method.java:597)
                            weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
                            weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
                            com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:149)
                            com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
                            com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:892)
                            com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:841)
                            com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:804)
                            com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:706)
                            com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:430)
                            com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:640)
                            com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:265)
                            com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:164)
                            weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:172)
                            weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
                            weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
                            weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
                            weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
                            weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
                            weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
                            weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
                            weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
                            javax.servlet.http.HttpServlet.service(HttpServlet.java:845)
                            weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
                            weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
                            weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
                            weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:338)
                            weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:222)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.__run(WebAppServletContext.java:3254)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java)
                            weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                            weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                            weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
                            weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
                            weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2091)
                            weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
                            weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1513)
                            weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
                            weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                            weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                            java.lang.reflect.InvocationTargetException
                            sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                            java.lang.reflect.Method.invoke(Method.java:597)
                            com.roche.research.mosaic.ws.AbstractWebServiceImpl$LoggingInvocationHandler.invoke(AbstractWebServiceImpl.java:218)
                            $Proxy108.handleBarcodes(Unknown Source)
                            com.roche.research.mosaic.ws.MosaicWSImpl.getPlateLayout(MosaicWSImpl.java:78)
                            sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                            java.lang.reflect.Method.invoke(Method.java:597)
                            weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
                            weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
                            com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:149)
                            com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
                            com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:892)
                            com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:841)
                            com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:804)
                            com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:706)
                            com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:430)
                            com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:640)
                            com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:265)
                            com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:163)
                            weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:171)
                            weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
                            weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
                            weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
                            weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
                            weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
                            weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
                            weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
                            weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
                            javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
                            weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
                            weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
                            weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
                            weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:338)
                            weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:221)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.__run(WebAppServletContext.java:3254)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java)
                            weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                            weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                            weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
                            weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
                            weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2089)
                            weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
                            weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1513)
                            weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254)
                            weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                            weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                            javax.ejb.EJBTransactionRolledbackException: EJB Exception:
                            weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:453)
                            weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:248)
                            weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:202)
                            weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:44)
                            com.roche.research.mosaic.ejb.impl.MosaicServiceImpl.handleBarcodes(MosaicServiceImpl.java:72)
                            weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                            sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                            java.lang.reflect.Method.invoke(Method.java:597)
                            com.roche.research.mosaic.ws.AbstractWebServiceImpl$LoggingInvocationHandler.invoke(AbstractWebServiceImpl.java:218)
                            $Proxy108.handleBarcodes(Unknown Source)
                            com.roche.research.mosaic.ws.MosaicWSImpl.getPlateLayout(MosaicWSImpl.java:78)
                            sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                            java.lang.reflect.Method.invoke(Method.java:597)
                            weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
                            weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
                            com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:149)
                            com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
                            com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:892)
                            com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:841)
                            com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:804)
                            com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:706)
                            com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:430)
                            com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:640)
                            com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:265)
                            com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:164)
                            weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:172)
                            weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
                            weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
                            weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
                            weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
                            weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
                            weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
                            weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
                            weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
                            javax.servlet.http.HttpServlet.service(HttpServlet.java:845)
                            weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
                            weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
                            weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
                            weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:338)
                            weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:222)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.__run(WebAppServletContext.java:3254)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java)
                            weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                            weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                            weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
                            weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
                            weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2091)
                            weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
                            weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1513)
                            weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
                            weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                            weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                            javax.ejb.EJBTransactionRolledbackException: EJB Exception:
                            weblogic.ejb.container.internal.BaseLocalObject.handleSystemException(BaseLocalObject.java:453)
                            weblogic.ejb.container.internal.BaseLocalObject.postInvoke1(BaseLocalObject.java:248)
                            weblogic.ejb.container.internal.BaseLocalObject.__WL_postInvokeTxRetry(BaseLocalObject.java:202)
                            weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:44)
                            com.roche.research.mosaic.availability.impl.PlateInfoServiceImpl.getPlateLayout(PlateInfoServiceImpl.java:84)
                            com.roche.research.mosaic.availability.impl.PlateInfoServiceImpl.handleBarcodes(PlateInfoServiceImpl.java:66)
                            weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                            com.roche.research.mosaic.ejb.impl.MosaicServiceImpl.handleBarcodes(MosaicServiceImpl.java:72)
                            weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                            sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                            java.lang.reflect.Method.invoke(Method.java:597)
                            com.roche.research.mosaic.ws.AbstractWebServiceImpl$LoggingInvocationHandler.invoke(AbstractWebServiceImpl.java:218)
                            $Proxy108.handleBarcodes(Unknown Source)
                            com.roche.research.mosaic.ws.MosaicWSImpl.getPlateLayout(MosaicWSImpl.java:78)
                            sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                            java.lang.reflect.Method.invoke(Method.java:597)
                            weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
                            weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
                            com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:149)
                            com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
                            com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:892)
                            com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:841)
                            com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:804)
                            com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:706)
                            com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:430)
                            com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:640)
                            com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:265)
                            com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:164)
                            weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:172)
                            weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
                            weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
                            weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
                            weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
                            weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
                            weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
                            weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
                            weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
                            javax.servlet.http.HttpServlet.service(HttpServlet.java:845)
                            weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
                            weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
                            weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
                            weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:338)
                            weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:222)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.__run(WebAppServletContext.java:3254)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java)
                            weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                            weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                            weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
                            weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
                            weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2091)
                            weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
                            weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1513)
                            weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
                            weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                            weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

                            java.lang.RuntimeException:
                            --- The error occurred in resources/ibatis/plateInfo.xml.
                            --- The error occurred while applying a parameter map.
                            --- Check the mosaic.plateInfo.findByBarcode-InlineParameterMap.
                            --- Check the statement (query failed).
                            --- Cause: java.sql.SQLRecoverableException: No more data to read from socket
                            com.roche.research.mosaic.db.ibatis.impl.PlateInfoDAOImpl.findByBarcode(PlateInfoDAOImpl.java:49)
                            weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                            com.roche.research.mosaic.availability.impl.PlateInfoServiceImpl.getPlateLayout(PlateInfoServiceImpl.java:84)
                            com.roche.research.mosaic.availability.impl.PlateInfoServiceImpl.handleBarcodes(PlateInfoServiceImpl.java:66)
                            weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                            com.roche.research.mosaic.ejb.impl.MosaicServiceImpl.handleBarcodes(MosaicServiceImpl.java:72)
                            weblogic.ejb.container.internal.SessionLocalMethodInvoker.invoke(SessionLocalMethodInvoker.java:31)
                            sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                            java.lang.reflect.Method.invoke(Method.java:597)
                            com.roche.research.mosaic.ws.AbstractWebServiceImpl$LoggingInvocationHandler.invoke(AbstractWebServiceImpl.java:218)
                            $Proxy108.handleBarcodes(Unknown Source)
                            com.roche.research.mosaic.ws.MosaicWSImpl.getPlateLayout(MosaicWSImpl.java:78)
                            sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                            sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                            sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                            java.lang.reflect.Method.invoke(Method.java:597)
                            weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:92)
                            weblogic.wsee.jaxws.WLSInstanceResolver$WLSInvoker.invoke(WLSInstanceResolver.java:74)
                            com.sun.xml.ws.server.InvokerTube$2.invoke(InvokerTube.java:149)
                            com.sun.xml.ws.server.sei.SEIInvokerTube.processRequest(SEIInvokerTube.java:95)
                            com.sun.xml.ws.api.pipe.Fiber.__doRun(Fiber.java:892)
                            com.sun.xml.ws.api.pipe.Fiber._doRun(Fiber.java:841)
                            com.sun.xml.ws.api.pipe.Fiber.doRun(Fiber.java:804)
                            com.sun.xml.ws.api.pipe.Fiber.runSync(Fiber.java:706)
                            com.sun.xml.ws.server.WSEndpointImpl$2.process(WSEndpointImpl.java:430)
                            com.sun.xml.ws.transport.http.HttpAdapter$HttpToolkit.handle(HttpAdapter.java:640)
                            com.sun.xml.ws.transport.http.HttpAdapter.handle(HttpAdapter.java:265)
                            com.sun.xml.ws.transport.http.servlet.ServletAdapter.handle(ServletAdapter.java:164)
                            weblogic.wsee.jaxws.WLSServletAdapter.handle(WLSServletAdapter.java:172)
                            weblogic.wsee.jaxws.HttpServletAdapter$AuthorizedInvoke.run(HttpServletAdapter.java:708)
                            weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
                            weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
                            weblogic.wsee.util.ServerSecurityHelper.authenticatedInvoke(ServerSecurityHelper.java:103)
                            weblogic.wsee.jaxws.HttpServletAdapter$3.run(HttpServletAdapter.java:311)
                            weblogic.wsee.jaxws.HttpServletAdapter.post(HttpServletAdapter.java:336)
                            weblogic.wsee.jaxws.JAXWSServlet.doRequest(JAXWSServlet.java:99)
                            weblogic.servlet.http.AbstractAsyncServlet.service(AbstractAsyncServlet.java:99)
                            javax.servlet.http.HttpServlet.service(HttpServlet.java:845)
                            weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
                            weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
                            weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
                            weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:338)
                            weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:222)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.__run(WebAppServletContext.java:3254)
                            weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java)
                            weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                            weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
                            weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
                            weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
                            weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2091)
                            weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
                            weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1513)
                            weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)
                            weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
                            weblogic.work.ExecuteThread.run(ExecuteThread.java:221)