Return-Path: Delivered-To: apmail-commons-user-archive@www.apache.org Received: (qmail 25764 invoked from network); 12 Apr 2010 13:27:24 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 12 Apr 2010 13:27:24 -0000 Received: (qmail 61050 invoked by uid 500); 12 Apr 2010 13:27:22 -0000 Delivered-To: apmail-commons-user-archive@commons.apache.org Received: (qmail 60951 invoked by uid 500); 12 Apr 2010 13:27:22 -0000 Mailing-List: contact user-help@commons.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "Commons Users List" Delivered-To: mailing list user@commons.apache.org Received: (qmail 60943 invoked by uid 99); 12 Apr 2010 13:27:22 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Apr 2010 13:27:22 +0000 X-ASF-Spam-Status: No, hits=-0.3 required=10.0 tests=AWL,RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [74.125.92.144] (HELO qw-out-1920.google.com) (74.125.92.144) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 Apr 2010 13:27:14 +0000 Received: by qw-out-1920.google.com with SMTP id 4so1914122qwk.60 for ; Mon, 12 Apr 2010 06:26:52 -0700 (PDT) MIME-Version: 1.0 Sender: jcarman@carmanconsulting.com Received: by 10.229.75.76 with HTTP; Mon, 12 Apr 2010 06:26:32 -0700 (PDT) In-Reply-To: <78443CA84DAF1E4C9B4F521A61376E75D60E7E067F@HQADAVXC02.int.chickasaw.net> References: <78443CA84DAF1E4C9B4F521A61376E75D60E46C739@HQADAVXC02.int.chickasaw.net> <4BBB1334.9000806@gmail.com> <78443CA84DAF1E4C9B4F521A61376E75D60E585537@HQADAVXC02.int.chickasaw.net> <78443CA84DAF1E4C9B4F521A61376E75D60E647B63@HQADAVXC02.int.chickasaw.net> <78443CA84DAF1E4C9B4F521A61376E75D60E7E067F@HQADAVXC02.int.chickasaw.net> From: James Carman Date: Mon, 12 Apr 2010 09:26:32 -0400 X-Google-Sender-Auth: 514986750be19e9c Received: by 10.229.215.72 with SMTP id hd8mr2779136qcb.43.1271078812343; Mon, 12 Apr 2010 06:26:52 -0700 (PDT) Message-ID: Subject: Re: [dbcp] Re: "Connection reset" exceptions To: Commons Users List Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable What about trying a different pooling technology (or no pooling at all) and see if you still have problems. Maybe DBCP isn't to blame at all? On Mon, Apr 12, 2010 at 9:18 AM, Bruno Melloni wrote: > Thanks Martin. The url, username and password are not blank, they are ins= erted into the context by Spring's PropertyOverrideConfigurer. =A0All of th= e queries are in a try/catch block already. > > -----Original Message----- > From: Bruno Melloni > Sent: Wednesday, April 07, 2010 9:55 AM > To: Bruno Melloni; Commons Users List > Subject: RE: [dbcp] Re: "Connection reset" exceptions > > Looks like my email ate few of the responses, but I found them on the Mar= kMail archive. =A0I am following up on them and it looks promising, I'll re= port on the result. > > Here are answers to the questions I missed, and additional findings: > > - My query is intense and returns quite a bit of data and might run for a= while. =A0Could this cause some kind of timeout? =A0If so, is there a DBCP= attribute I can set to increase the timeout? > > - My DBA looked at the DB logs. =A0Found that the problem started in Febr= uary. =A0From the DB side it "looks like" the client is shutting down befor= e all the data is returned - which makes no sense, since when using Spring = you get the whole list of results at once [Map results =3D = c.execute(inParams);]. > > - I did not have testOnBorrow turned on. =A0I added it. > > - I was using the Microsoft 2.0 driver for SQL Server 2008. =A0Searching = for the TDS error I found an entry in http://blogs.msdn.com/jdbcteam/archiv= e/2009/04/03/announcing-microsoft-sql-server-jdbc-driver-2-0.aspx that seem= s to indicate that as late as Aug 25 2009 there was a bug in the driver tha= t throws the TDS/Connection reset error under some conditions. =A0There als= o seems to be a bug related to closing PreparedStatements when the underlyi= ng connection has closed. =A0According to my version control, my driver is = from April 2009 - the buggy one. MS released a new 3.0 CTP driver for SQL s= erver 2008 (http://www.microsoft.com/downloads/details.aspx?FamilyID=3Df914= 793a-6fb4-475f-9537-b8fcb776befd&displaylang=3Den). =A0I am switching to th= e new driver. =A0Some users reported better results using the jTDS driver f= rom sourceforge (not trying that yet). > > - Somebody asked for my DataSource configuration. =A0Here it is: > > =A0 > =A0 =A0 > =A0 =A0 > =A0 =A0 > =A0 =A0 > =A0 =A0 > =A0 =A0 > =A0 > > Where the empty values are being inserted by PropertyOverrideConfigurer. > > > -----Original Message----- > From: Bruno Melloni > Sent: Tuesday, April 06, 2010 12:03 PM > To: Bruno Melloni; Commons Users List > Subject: RE: [dbcp] Re: "Connection reset" exceptions > > Update: =A0Upgrading to the current version of DBCP and Pool made no diff= erence. > > -----Original Message----- > From: Bruno Melloni > Sent: Tuesday, April 06, 2010 8:50 AM > To: Commons Users List > Subject: RE: [dbcp] Re: "Connection reset" exceptions > > Thanks Phil, > > My apologies on the missing [dbcp] prefix. =A0This is the first time I us= e the mailing list and I followed the 'mailing lists' link from the DBCP pr= oject without giving it much thought. =A0I didn't realize that the dbcp mai= ling list was shared across all of the commons projects. > > Versions: I am using Java 6, DBCP 1.2.1, Pool 1.3. =A0Now that I looked a= t the versions, it seems like an obvious thing to try is to upgrade to the = current versions. =A0I'll start with that immediately. > > More background: > - The problem seems to happen in a very random way. > - It happens on a command line application as well as on an a web service= (called by cmd line app) running on jBoss. > - On the command line application it happens using Spring JDBC, on the we= b service it happens using Spring/JPA/Hibernate. > - It seems to happen about 10-20 times and then it causes the process to = hang. > - One time it reached the hung point quickly (after processing about 1000= queries) and the next run it took longer (after 8000 queries). > - The problem never happened for months, then it started (the code change= d, but not in any way that should affect this - it is possible that somethi= ng was changed on the DB servers but I have no access to that information). > - Although unlikely, I would not rule out network instability. > > - My research seems to point to SQL Server closing idle connections (surp= rising since the client process is running 20 parallel threads and they are= very active). > - All of the non-dbcp solution suggestions I saw for the "Connection rese= t" exception also recommended setting an idle test period and timeout. =A0I= don't know if DBCP has (or needs configuring) that capability. =A0Example:= =A0http://mrather.blogspot.com/2008/09/hibernate-and-connection-pools.html= (this example is typical of the recommended solutions I found on Google, a= nd it claims that there is a bug in DBCP - but that might be an obsolete st= atement). > > Log (complete) from the command line application: > > 13:57:17,637 =A0INFO net.cndc.mb.client.Main:50 - log4j initialized. > 13:57:21,559 =A0INFO net.cndc.mb.client.Processor:76 - Processing batch f= or hostname: CEADAVDEV02 > 13:57:22,668 =A0INFO net.cndc.mb.client.Processor:96 - Launched 20 thread= s for processor: CEADAVDEV02 > 14:10:08,585 ERROR net.cndc.gp2cog.client.Gp2cogCeCustomDaoImpl:64 - Exce= ption thrown retrieving rows to process: CallableStatementCallback; uncateg= orized SQLException for SQL [{call GP2COG_ReturnResultsSet(?, ?, ?, ?)}]; S= QL state [null]; error code [0]; Connection reset; nested exception is com.= microsoft.sqlserver.jdbc.SQLServerException: Connection reset > 15:34:37,834 ERROR net.cndc.gp2cog.client.Gp2cogCeCustomDaoImpl:64 - Exce= ption thrown retrieving rows to process: CallableStatementCallback; uncateg= orized SQLException for SQL [{call GP2COG_ReturnResultsSet(?, ?, ?, ?)}]; S= QL state [null]; error code [0]; Connection reset; nested exception is com.= microsoft.sqlserver.jdbc.SQLServerException: Connection reset > 15:54:53,311 ERROR net.cndc.gp2cog.client.Gp2cogCeCustomDaoImpl:64 - Exce= ption thrown retrieving rows to process: CallableStatementCallback; SQL [{c= all GP2COG_ReturnResultsSet(?, ?, ?, ?)}]; Connection reset; nested excepti= on is com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset > 16:54:35,815 ERROR net.cndc.gp2cog.client.Gp2cogCeCustomDaoImpl:64 - Exce= ption thrown retrieving rows to process: CallableStatementCallback; uncateg= orized SQLException for SQL [{call GP2COG_ReturnResultsSet(?, ?, ?, ?)}]; S= QL state [null]; error code [0]; Connection reset; nested exception is com.= microsoft.sqlserver.jdbc.SQLServerException: Connection reset > 17:10:18,934 ERROR net.cndc.gp2cog.client.Gp2cogCeCustomDaoImpl:64 - Exce= ption thrown retrieving rows to process: CallableStatementCallback; uncateg= orized SQLException for SQL [{call GP2COG_ReturnResultsSet(?, ?, ?, ?)}]; S= QL state [null]; error code [0]; Connection reset; nested exception is com.= microsoft.sqlserver.jdbc.SQLServerException: Connection reset > 17:29:05,224 ERROR net.cndc.gp2cog.client.Gp2cogCeCustomDaoImpl:64 - Exce= ption thrown retrieving rows to process: CallableStatementCallback; uncateg= orized SQLException for SQL [{call GP2COG_ReturnResultsSet(?, ?, ?, ?)}]; S= QL state [null]; error code [0]; Connection reset; nested exception is com.= microsoft.sqlserver.jdbc.SQLServerException: Connection reset > 17:56:02,182 ERROR net.cndc.gp2cog.client.Gp2cogCeCustomDaoImpl:64 - Exce= ption thrown retrieving rows to process: CallableStatementCallback; uncateg= orized SQLException for SQL [{call GP2COG_ReturnResultsSet(?, ?, ?, ?)}]; S= QL state [null]; error code [0]; Connection reset; nested exception is com.= microsoft.sqlserver.jdbc.SQLServerException: Connection reset > 20:02:14,446 ERROR net.cndc.gp2cog.client.Gp2cogCeCustomDaoImpl:64 - Exce= ption thrown retrieving rows to process: CallableStatementCallback; SQL [{c= all GP2COG_ReturnResultsSet(?, ?, ?, ?)}]; Connection reset; nested excepti= on is com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset > > Log (snippet) from the web service: > > 2010-04-05 09:42:20,438 ERROR [STDERR] Apr 5, 2010 9:42:20 AM com.microso= ft.sqlserver.jdbc.TDSReader throwInvalidTDS > SEVERE: ConnectionID:45 got unexpected value in TDS response at offset:77= 8 > 2010-04-05 09:42:20,438 WARN =A0[org.hibernate.jdbc.AbstractBatcher] exce= ption clearing maxRows/queryTimeout > com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed= . > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerException.makeFro= mDriverError(SQLServerException.java:170) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkC= losed(SQLServerConnection.java:304) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerStatement.checkCl= osed(SQLServerStatement.java:904) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerStatement.getMaxR= ows(SQLServerStatement.java:937) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.DelegatingStatement.getMaxRows(= DelegatingStatement.java:234) > =A0 =A0 =A0 =A0at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(= AbstractBatcher.java:277) > =A0 =A0 =A0 =A0at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(= AbstractBatcher.java:213) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doQuery(Loader.java:726) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doQueryAndInitializeNonLazy= Collections(Loader.java:236) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doList(Loader.java:2220) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader= .java:2104) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.list(Loader.java:2099) > =A0 =A0 =A0 =A0at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.j= ava:378) > =A0 =A0 =A0 =A0at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTra= nslatorImpl.java:341) > =A0 =A0 =A0 =A0at org.hibernate.engine.query.HQLQueryPlan.performList(HQL= QueryPlan.java:172) > =A0 =A0 =A0 =A0at org.hibernate.impl.SessionImpl.list(SessionImpl.java:11= 21) > =A0 =A0 =A0 =A0at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) > =A0 =A0 =A0 =A0at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.j= ava:81) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorDaoImpl.findByHostnam= e(MBProcessorDaoImpl.java:56) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.springframework.aop.support.AopUtils.invokeJoinpoin= tUsingReflection(AopUtils.java:307) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:149) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= Interceptor.invoke(TransactionInterceptor.java:106) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:171) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.JdkDynamicAopProxy.in= voke(JdkDynamicAopProxy.java:204) > =A0 =A0 =A0 =A0at $Proxy147.findByHostname(Unknown Source) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorServiceImpl.recordWor= kUnitResults(MBProcessorServiceImpl.java:115) > =A0 =A0 =A0 =A0at net.cndc.mb.service.ws.MassBatchImpl.recordWorkUnitResu= lts(MassBatchImpl.java:69) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.performI= nvocation(AbstractInvoker.java:166) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:82) > =A0 =A0 =A0 =A0at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMet= hodInvoker.java:55) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:68) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.= run(ServiceInvokerInterceptor.java:57) > =A0 =A0 =A0 =A0at java.util.concurrent.Executors$RunnableAdapter.call(Exe= cutors.java:441) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask$Sync.innerRun(FutureTas= k.java:303) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask.run(FutureTask.java:138= ) > =A0 =A0 =A0 =A0at org.apache.cxf.workqueue.SynchronousExecutor.execute(Sy= nchronousExecutor.java:37) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor.ha= ndleMessage(ServiceInvokerInterceptor.java:95) > =A0 =A0 =A0 =A0at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(= PhaseInterceptorChain.java:236) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.ChainInitiationObserver.onMess= age(ChainInitiationObserver.java:89) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletDestination.inv= oke(ServletDestination.java:99) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= keDestination(ServletController.java:368) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= ke(ServletController.java:183) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.inv= oke(AbstractCXFServlet.java:163) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.doP= ost(AbstractCXFServlet.java:141) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :637) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :717) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:290) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter= (ReplyHeaderFilter.java:96) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:235) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardWrapperValve.invoke(St= andardWrapperValve.java:230) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardContextValve.invoke(St= andardContextValve.java:173) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.SecurityAssociationValve.= invoke(SecurityAssociationValve.java:182) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.JaccContextValve.invoke(J= accContextValve.java:84) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardHostValve.invoke(Stand= ardHostValve.java:128) > =A0 =A0 =A0 =A0at org.apache.catalina.valves.ErrorReportValve.invoke(Erro= rReportValve.java:104) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.service.jca.CachedConnectionValve.= invoke(CachedConnectionValve.java:157) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardEngineValve.invoke(Sta= ndardEngineValve.java:109) > =A0 =A0 =A0 =A0at org.apache.catalina.connector.CoyoteAdapter.service(Coy= oteAdapter.java:241) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Processor.process(Http11= Processor.java:844) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Protocol$Http11Connectio= nHandler.process(Http11Protocol.java:583) > =A0 =A0 =A0 =A0at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEn= dpoint.java:447) > =A0 =A0 =A0 =A0at java.lang.Thread.run(Thread.java:619) > 2010-04-05 09:42:20,438 WARN =A0[org.hibernate.util.JDBCExceptionReporter= ] SQL Error: 0, SQLState: 08S01 > 2010-04-05 09:42:20,438 ERROR [org.hibernate.util.JDBCExceptionReporter] = The TDS protocol stream is not valid. > 2010-04-05 09:42:20,438 ERROR [net.cndc.mb.service.db.MBProcessorDaoImpl]= findByHostname Exception for hostname=3DCEADAVDEV02 > javax.persistence.PersistenceException: org.hibernate.exception.JDBCConne= ctionException: could not execute query > =A0 =A0 =A0 =A0at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersis= tenceException(AbstractEntityManagerImpl.java:637) > =A0 =A0 =A0 =A0at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.j= ava:107) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorDaoImpl.findByHostnam= e(MBProcessorDaoImpl.java:56) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.springframework.aop.support.AopUtils.invokeJoinpoin= tUsingReflection(AopUtils.java:307) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:149) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= Interceptor.invoke(TransactionInterceptor.java:106) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:171) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.JdkDynamicAopProxy.in= voke(JdkDynamicAopProxy.java:204) > =A0 =A0 =A0 =A0at $Proxy147.findByHostname(Unknown Source) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorServiceImpl.recordWor= kUnitResults(MBProcessorServiceImpl.java:115) > =A0 =A0 =A0 =A0at net.cndc.mb.service.ws.MassBatchImpl.recordWorkUnitResu= lts(MassBatchImpl.java:69) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.performI= nvocation(AbstractInvoker.java:166) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:82) > =A0 =A0 =A0 =A0at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMet= hodInvoker.java:55) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:68) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.= run(ServiceInvokerInterceptor.java:57) > =A0 =A0 =A0 =A0at java.util.concurrent.Executors$RunnableAdapter.call(Exe= cutors.java:441) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask$Sync.innerRun(FutureTas= k.java:303) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask.run(FutureTask.java:138= ) > =A0 =A0 =A0 =A0at org.apache.cxf.workqueue.SynchronousExecutor.execute(Sy= nchronousExecutor.java:37) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor.ha= ndleMessage(ServiceInvokerInterceptor.java:95) > =A0 =A0 =A0 =A0at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(= PhaseInterceptorChain.java:236) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.ChainInitiationObserver.onMess= age(ChainInitiationObserver.java:89) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletDestination.inv= oke(ServletDestination.java:99) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= keDestination(ServletController.java:368) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= ke(ServletController.java:183) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.inv= oke(AbstractCXFServlet.java:163) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.doP= ost(AbstractCXFServlet.java:141) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :637) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :717) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:290) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter= (ReplyHeaderFilter.java:96) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:235) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardWrapperValve.invoke(St= andardWrapperValve.java:230) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardContextValve.invoke(St= andardContextValve.java:173) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.SecurityAssociationValve.= invoke(SecurityAssociationValve.java:182) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.JaccContextValve.invoke(J= accContextValve.java:84) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardHostValve.invoke(Stand= ardHostValve.java:128) > =A0 =A0 =A0 =A0at org.apache.catalina.valves.ErrorReportValve.invoke(Erro= rReportValve.java:104) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.service.jca.CachedConnectionValve.= invoke(CachedConnectionValve.java:157) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardEngineValve.invoke(Sta= ndardEngineValve.java:109) > =A0 =A0 =A0 =A0at org.apache.catalina.connector.CoyoteAdapter.service(Coy= oteAdapter.java:241) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Processor.process(Http11= Processor.java:844) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Protocol$Http11Connectio= nHandler.process(Http11Protocol.java:583) > =A0 =A0 =A0 =A0at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEn= dpoint.java:447) > =A0 =A0 =A0 =A0at java.lang.Thread.run(Thread.java:619) > Caused by: org.hibernate.exception.JDBCConnectionException: could not exe= cute query > =A0 =A0 =A0 =A0at org.hibernate.exception.SQLStateConverter.convert(SQLSt= ateConverter.java:74) > =A0 =A0 =A0 =A0at org.hibernate.exception.JDBCExceptionHelper.convert(JDB= CExceptionHelper.java:43) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doList(Loader.java:2223) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader= .java:2104) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.list(Loader.java:2099) > =A0 =A0 =A0 =A0at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.j= ava:378) > =A0 =A0 =A0 =A0at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTra= nslatorImpl.java:341) > =A0 =A0 =A0 =A0at org.hibernate.engine.query.HQLQueryPlan.performList(HQL= QueryPlan.java:172) > =A0 =A0 =A0 =A0at org.hibernate.impl.SessionImpl.list(SessionImpl.java:11= 21) > =A0 =A0 =A0 =A0at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) > =A0 =A0 =A0 =A0at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.j= ava:81) > =A0 =A0 =A0 =A0... 53 more > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TDS proto= col stream is not valid. > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.termin= ate(SQLServerConnection.java:1368) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.termin= ate(SQLServerConnection.java:1355) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.throwI= nvalidTDS(SQLServerConnection.java:1344) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.TDSReader.throwInvalidTDS(= IOBuffer.java:3190) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBu= ffer$FetchBufferTokenHandler.onRetValue(SQLServerResultSet.java:4624) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.= java:66) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBu= ffer.nextRow(SQLServerResultSet.java:4696) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBu= fferNext(SQLServerResultSet.java:1683) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQ= LServerResultSet.java:956) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.DelegatingResultSet.next(Delega= tingResultSet.java:168) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doQuery(Loader.java:697) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doQueryAndInitializeNonLazy= Collections(Loader.java:236) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doList(Loader.java:2220) > =A0 =A0 =A0 =A0... 61 more > 2010-04-05 09:42:20,438 ERROR [org.hibernate.transaction.JDBCTransaction]= Could not toggle autocommit > com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed= . > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerException.makeFro= mDriverError(SQLServerException.java:170) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkC= losed(SQLServerConnection.java:304) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAut= oCommit(SQLServerConnection.java:1592) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.DelegatingConnection.setAutoCom= mit(DelegatingConnection.java:268) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConn= ectionWrapper.setAutoCommit(PoolingDataSource.java:293) > =A0 =A0 =A0 =A0at org.hibernate.transaction.JDBCTransaction.toggleAutoCom= mit(JDBCTransaction.java:194) > =A0 =A0 =A0 =A0at org.hibernate.transaction.JDBCTransaction.rollbackAndRe= setAutoCommit(JDBCTransaction.java:186) > =A0 =A0 =A0 =A0at org.hibernate.transaction.JDBCTransaction.rollback(JDBC= Transaction.java:162) > =A0 =A0 =A0 =A0at org.hibernate.ejb.TransactionImpl.commit(TransactionImp= l.java:50) > =A0 =A0 =A0 =A0at org.springframework.orm.jpa.JpaTransactionManager.doCom= mit(JpaTransactionManager.java:456) > =A0 =A0 =A0 =A0at org.springframework.transaction.support.AbstractPlatfor= mTransactionManager.processCommit(AbstractPlatformTransactionManager.java:7= 32) > =A0 =A0 =A0 =A0at org.springframework.transaction.support.AbstractPlatfor= mTransactionManager.commit(AbstractPlatformTransactionManager.java:701) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= AspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.jav= a:359) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= Interceptor.invoke(TransactionInterceptor.java:110) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:171) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.JdkDynamicAopProxy.in= voke(JdkDynamicAopProxy.java:204) > =A0 =A0 =A0 =A0at $Proxy147.findByHostname(Unknown Source) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorServiceImpl.recordWor= kUnitResults(MBProcessorServiceImpl.java:115) > =A0 =A0 =A0 =A0at net.cndc.mb.service.ws.MassBatchImpl.recordWorkUnitResu= lts(MassBatchImpl.java:69) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.performI= nvocation(AbstractInvoker.java:166) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:82) > =A0 =A0 =A0 =A0at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMet= hodInvoker.java:55) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:68) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.= run(ServiceInvokerInterceptor.java:57) > =A0 =A0 =A0 =A0at java.util.concurrent.Executors$RunnableAdapter.call(Exe= cutors.java:441) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask$Sync.innerRun(FutureTas= k.java:303) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask.run(FutureTask.java:138= ) > =A0 =A0 =A0 =A0at org.apache.cxf.workqueue.SynchronousExecutor.execute(Sy= nchronousExecutor.java:37) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor.ha= ndleMessage(ServiceInvokerInterceptor.java:95) > =A0 =A0 =A0 =A0at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(= PhaseInterceptorChain.java:236) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.ChainInitiationObserver.onMess= age(ChainInitiationObserver.java:89) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletDestination.inv= oke(ServletDestination.java:99) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= keDestination(ServletController.java:368) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= ke(ServletController.java:183) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.inv= oke(AbstractCXFServlet.java:163) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.doP= ost(AbstractCXFServlet.java:141) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :637) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :717) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:290) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter= (ReplyHeaderFilter.java:96) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:235) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardWrapperValve.invoke(St= andardWrapperValve.java:230) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardContextValve.invoke(St= andardContextValve.java:173) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.SecurityAssociationValve.= invoke(SecurityAssociationValve.java:182) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.JaccContextValve.invoke(J= accContextValve.java:84) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardHostValve.invoke(Stand= ardHostValve.java:128) > =A0 =A0 =A0 =A0at org.apache.catalina.valves.ErrorReportValve.invoke(Erro= rReportValve.java:104) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.service.jca.CachedConnectionValve.= invoke(CachedConnectionValve.java:157) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardEngineValve.invoke(Sta= ndardEngineValve.java:109) > =A0 =A0 =A0 =A0at org.apache.catalina.connector.CoyoteAdapter.service(Coy= oteAdapter.java:241) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Processor.process(Http11= Processor.java:844) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Protocol$Http11Connectio= nHandler.process(Http11Protocol.java:583) > =A0 =A0 =A0 =A0at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEn= dpoint.java:447) > =A0 =A0 =A0 =A0at java.lang.Thread.run(Thread.java:619) > 2010-04-05 09:42:20,438 ERROR [org.hibernate.transaction.JDBCTransaction]= JDBC rollback failed > com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed= . > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerException.makeFro= mDriverError(SQLServerException.java:170) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkC= losed(SQLServerConnection.java:304) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollba= ck(SQLServerConnection.java:1655) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.DelegatingConnection.rollback(D= elegatingConnection.java:265) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConn= ectionWrapper.rollback(PoolingDataSource.java:288) > =A0 =A0 =A0 =A0at org.hibernate.transaction.JDBCTransaction.rollbackAndRe= setAutoCommit(JDBCTransaction.java:183) > =A0 =A0 =A0 =A0at org.hibernate.transaction.JDBCTransaction.rollback(JDBC= Transaction.java:162) > =A0 =A0 =A0 =A0at org.hibernate.ejb.TransactionImpl.commit(TransactionImp= l.java:50) > =A0 =A0 =A0 =A0at org.springframework.orm.jpa.JpaTransactionManager.doCom= mit(JpaTransactionManager.java:456) > =A0 =A0 =A0 =A0at org.springframework.transaction.support.AbstractPlatfor= mTransactionManager.processCommit(AbstractPlatformTransactionManager.java:7= 32) > =A0 =A0 =A0 =A0at org.springframework.transaction.support.AbstractPlatfor= mTransactionManager.commit(AbstractPlatformTransactionManager.java:701) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= AspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.jav= a:359) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= Interceptor.invoke(TransactionInterceptor.java:110) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:171) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.JdkDynamicAopProxy.in= voke(JdkDynamicAopProxy.java:204) > =A0 =A0 =A0 =A0at $Proxy147.findByHostname(Unknown Source) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorServiceImpl.recordWor= kUnitResults(MBProcessorServiceImpl.java:115) > =A0 =A0 =A0 =A0at net.cndc.mb.service.ws.MassBatchImpl.recordWorkUnitResu= lts(MassBatchImpl.java:69) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.performI= nvocation(AbstractInvoker.java:166) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:82) > =A0 =A0 =A0 =A0at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMet= hodInvoker.java:55) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:68) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.= run(ServiceInvokerInterceptor.java:57) > =A0 =A0 =A0 =A0at java.util.concurrent.Executors$RunnableAdapter.call(Exe= cutors.java:441) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask$Sync.innerRun(FutureTas= k.java:303) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask.run(FutureTask.java:138= ) > =A0 =A0 =A0 =A0at org.apache.cxf.workqueue.SynchronousExecutor.execute(Sy= nchronousExecutor.java:37) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor.ha= ndleMessage(ServiceInvokerInterceptor.java:95) > =A0 =A0 =A0 =A0at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(= PhaseInterceptorChain.java:236) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.ChainInitiationObserver.onMess= age(ChainInitiationObserver.java:89) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletDestination.inv= oke(ServletDestination.java:99) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= keDestination(ServletController.java:368) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= ke(ServletController.java:183) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.inv= oke(AbstractCXFServlet.java:163) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.doP= ost(AbstractCXFServlet.java:141) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :637) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :717) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:290) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter= (ReplyHeaderFilter.java:96) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:235) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardWrapperValve.invoke(St= andardWrapperValve.java:230) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardContextValve.invoke(St= andardContextValve.java:173) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.SecurityAssociationValve.= invoke(SecurityAssociationValve.java:182) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.JaccContextValve.invoke(J= accContextValve.java:84) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardHostValve.invoke(Stand= ardHostValve.java:128) > =A0 =A0 =A0 =A0at org.apache.catalina.valves.ErrorReportValve.invoke(Erro= rReportValve.java:104) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.service.jca.CachedConnectionValve.= invoke(CachedConnectionValve.java:157) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardEngineValve.invoke(Sta= ndardEngineValve.java:109) > =A0 =A0 =A0 =A0at org.apache.catalina.connector.CoyoteAdapter.service(Coy= oteAdapter.java:241) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Processor.process(Http11= Processor.java:844) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Protocol$Http11Connectio= nHandler.process(Http11Protocol.java:583) > =A0 =A0 =A0 =A0at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEn= dpoint.java:447) > =A0 =A0 =A0 =A0at java.lang.Thread.run(Thread.java:619) > 2010-04-05 09:42:20,438 WARN =A0[org.hibernate.util.JDBCExceptionReporter= ] SQL Error: 0, SQLState: null > 2010-04-05 09:42:20,438 ERROR [org.hibernate.util.JDBCExceptionReporter] = Already closed. > 2010-04-05 09:42:20,438 WARN =A0[org.hibernate.util.JDBCExceptionReporter= ] SQL Error: 0, SQLState: null > 2010-04-05 09:42:20,438 ERROR [org.hibernate.util.JDBCExceptionReporter] = Already closed. > 2010-04-05 09:42:20,438 ERROR [org.springframework.transaction.intercepto= r.TransactionInterceptor] Application exception overridden by commit except= ion > net.cndc.mb.common.MBException: Error retrieving processor with hostname= =3DCEADAVDEV02 > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorDaoImpl.findByHostnam= e(MBProcessorDaoImpl.java:64) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.springframework.aop.support.AopUtils.invokeJoinpoin= tUsingReflection(AopUtils.java:307) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:149) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= Interceptor.invoke(TransactionInterceptor.java:106) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:171) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.JdkDynamicAopProxy.in= voke(JdkDynamicAopProxy.java:204) > =A0 =A0 =A0 =A0at $Proxy147.findByHostname(Unknown Source) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorServiceImpl.recordWor= kUnitResults(MBProcessorServiceImpl.java:115) > =A0 =A0 =A0 =A0at net.cndc.mb.service.ws.MassBatchImpl.recordWorkUnitResu= lts(MassBatchImpl.java:69) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.performI= nvocation(AbstractInvoker.java:166) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:82) > =A0 =A0 =A0 =A0at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMet= hodInvoker.java:55) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:68) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.= run(ServiceInvokerInterceptor.java:57) > =A0 =A0 =A0 =A0at java.util.concurrent.Executors$RunnableAdapter.call(Exe= cutors.java:441) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask$Sync.innerRun(FutureTas= k.java:303) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask.run(FutureTask.java:138= ) > =A0 =A0 =A0 =A0at org.apache.cxf.workqueue.SynchronousExecutor.execute(Sy= nchronousExecutor.java:37) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor.ha= ndleMessage(ServiceInvokerInterceptor.java:95) > =A0 =A0 =A0 =A0at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(= PhaseInterceptorChain.java:236) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.ChainInitiationObserver.onMess= age(ChainInitiationObserver.java:89) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletDestination.inv= oke(ServletDestination.java:99) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= keDestination(ServletController.java:368) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= ke(ServletController.java:183) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.inv= oke(AbstractCXFServlet.java:163) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.doP= ost(AbstractCXFServlet.java:141) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :637) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :717) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:290) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter= (ReplyHeaderFilter.java:96) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:235) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardWrapperValve.invoke(St= andardWrapperValve.java:230) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardContextValve.invoke(St= andardContextValve.java:173) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.SecurityAssociationValve.= invoke(SecurityAssociationValve.java:182) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.JaccContextValve.invoke(J= accContextValve.java:84) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardHostValve.invoke(Stand= ardHostValve.java:128) > =A0 =A0 =A0 =A0at org.apache.catalina.valves.ErrorReportValve.invoke(Erro= rReportValve.java:104) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.service.jca.CachedConnectionValve.= invoke(CachedConnectionValve.java:157) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardEngineValve.invoke(Sta= ndardEngineValve.java:109) > =A0 =A0 =A0 =A0at org.apache.catalina.connector.CoyoteAdapter.service(Coy= oteAdapter.java:241) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Processor.process(Http11= Processor.java:844) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Protocol$Http11Connectio= nHandler.process(Http11Protocol.java:583) > =A0 =A0 =A0 =A0at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEn= dpoint.java:447) > =A0 =A0 =A0 =A0at java.lang.Thread.run(Thread.java:619) > 2010-04-05 09:42:25,454 ERROR [STDERR] Apr 5, 2010 9:42:25 AM com.microso= ft.sqlserver.jdbc.TDSReader throwInvalidTDS > SEVERE: ConnectionID:48 got unexpected value in TDS response at offset:77= 8 > 2010-04-05 09:42:25,454 WARN =A0[org.hibernate.jdbc.AbstractBatcher] exce= ption clearing maxRows/queryTimeout > com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed= . > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerException.makeFro= mDriverError(SQLServerException.java:170) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkC= losed(SQLServerConnection.java:304) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerStatement.checkCl= osed(SQLServerStatement.java:904) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerStatement.getMaxR= ows(SQLServerStatement.java:937) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.DelegatingStatement.getMaxRows(= DelegatingStatement.java:234) > =A0 =A0 =A0 =A0at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(= AbstractBatcher.java:277) > =A0 =A0 =A0 =A0at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(= AbstractBatcher.java:213) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doQuery(Loader.java:726) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doQueryAndInitializeNonLazy= Collections(Loader.java:236) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doList(Loader.java:2220) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader= .java:2104) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.list(Loader.java:2099) > =A0 =A0 =A0 =A0at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.j= ava:378) > =A0 =A0 =A0 =A0at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTra= nslatorImpl.java:341) > =A0 =A0 =A0 =A0at org.hibernate.engine.query.HQLQueryPlan.performList(HQL= QueryPlan.java:172) > =A0 =A0 =A0 =A0at org.hibernate.impl.SessionImpl.list(SessionImpl.java:11= 21) > =A0 =A0 =A0 =A0at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) > =A0 =A0 =A0 =A0at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.j= ava:81) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorDaoImpl.findByHostnam= e(MBProcessorDaoImpl.java:56) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.springframework.aop.support.AopUtils.invokeJoinpoin= tUsingReflection(AopUtils.java:307) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:149) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= Interceptor.invoke(TransactionInterceptor.java:106) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:171) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.JdkDynamicAopProxy.in= voke(JdkDynamicAopProxy.java:204) > =A0 =A0 =A0 =A0at $Proxy147.findByHostname(Unknown Source) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorServiceImpl.recordWor= kUnitResults(MBProcessorServiceImpl.java:115) > =A0 =A0 =A0 =A0at net.cndc.mb.service.ws.MassBatchImpl.recordWorkUnitResu= lts(MassBatchImpl.java:69) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.performI= nvocation(AbstractInvoker.java:166) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:82) > =A0 =A0 =A0 =A0at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMet= hodInvoker.java:55) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:68) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.= run(ServiceInvokerInterceptor.java:57) > =A0 =A0 =A0 =A0at java.util.concurrent.Executors$RunnableAdapter.call(Exe= cutors.java:441) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask$Sync.innerRun(FutureTas= k.java:303) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask.run(FutureTask.java:138= ) > =A0 =A0 =A0 =A0at org.apache.cxf.workqueue.SynchronousExecutor.execute(Sy= nchronousExecutor.java:37) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor.ha= ndleMessage(ServiceInvokerInterceptor.java:95) > =A0 =A0 =A0 =A0at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(= PhaseInterceptorChain.java:236) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.ChainInitiationObserver.onMess= age(ChainInitiationObserver.java:89) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletDestination.inv= oke(ServletDestination.java:99) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= keDestination(ServletController.java:368) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= ke(ServletController.java:183) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.inv= oke(AbstractCXFServlet.java:163) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.doP= ost(AbstractCXFServlet.java:141) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :637) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :717) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:290) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter= (ReplyHeaderFilter.java:96) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:235) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardWrapperValve.invoke(St= andardWrapperValve.java:230) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardContextValve.invoke(St= andardContextValve.java:173) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.SecurityAssociationValve.= invoke(SecurityAssociationValve.java:182) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.JaccContextValve.invoke(J= accContextValve.java:84) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardHostValve.invoke(Stand= ardHostValve.java:128) > =A0 =A0 =A0 =A0at org.apache.catalina.valves.ErrorReportValve.invoke(Erro= rReportValve.java:104) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.service.jca.CachedConnectionValve.= invoke(CachedConnectionValve.java:157) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardEngineValve.invoke(Sta= ndardEngineValve.java:109) > =A0 =A0 =A0 =A0at org.apache.catalina.connector.CoyoteAdapter.service(Coy= oteAdapter.java:241) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Processor.process(Http11= Processor.java:844) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Protocol$Http11Connectio= nHandler.process(Http11Protocol.java:583) > =A0 =A0 =A0 =A0at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEn= dpoint.java:447) > =A0 =A0 =A0 =A0at java.lang.Thread.run(Thread.java:619) > 2010-04-05 09:42:25,454 WARN =A0[org.hibernate.util.JDBCExceptionReporter= ] SQL Error: 0, SQLState: 08S01 > 2010-04-05 09:42:25,454 ERROR [org.hibernate.util.JDBCExceptionReporter] = The TDS protocol stream is not valid. > 2010-04-05 09:42:25,454 ERROR [net.cndc.mb.service.db.MBProcessorDaoImpl]= findByHostname Exception for hostname=3DCEADAVDEV02 > javax.persistence.PersistenceException: org.hibernate.exception.JDBCConne= ctionException: could not execute query > =A0 =A0 =A0 =A0at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersis= tenceException(AbstractEntityManagerImpl.java:637) > =A0 =A0 =A0 =A0at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.j= ava:107) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorDaoImpl.findByHostnam= e(MBProcessorDaoImpl.java:56) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor249.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.springframework.aop.support.AopUtils.invokeJoinpoin= tUsingReflection(AopUtils.java:307) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:149) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= Interceptor.invoke(TransactionInterceptor.java:106) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:171) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.JdkDynamicAopProxy.in= voke(JdkDynamicAopProxy.java:204) > =A0 =A0 =A0 =A0at $Proxy147.findByHostname(Unknown Source) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorServiceImpl.recordWor= kUnitResults(MBProcessorServiceImpl.java:115) > =A0 =A0 =A0 =A0at net.cndc.mb.service.ws.MassBatchImpl.recordWorkUnitResu= lts(MassBatchImpl.java:69) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.performI= nvocation(AbstractInvoker.java:166) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:82) > =A0 =A0 =A0 =A0at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMet= hodInvoker.java:55) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:68) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.= run(ServiceInvokerInterceptor.java:57) > =A0 =A0 =A0 =A0at java.util.concurrent.Executors$RunnableAdapter.call(Exe= cutors.java:441) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask$Sync.innerRun(FutureTas= k.java:303) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask.run(FutureTask.java:138= ) > =A0 =A0 =A0 =A0at org.apache.cxf.workqueue.SynchronousExecutor.execute(Sy= nchronousExecutor.java:37) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor.ha= ndleMessage(ServiceInvokerInterceptor.java:95) > =A0 =A0 =A0 =A0at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(= PhaseInterceptorChain.java:236) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.ChainInitiationObserver.onMess= age(ChainInitiationObserver.java:89) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletDestination.inv= oke(ServletDestination.java:99) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= keDestination(ServletController.java:368) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= ke(ServletController.java:183) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.inv= oke(AbstractCXFServlet.java:163) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.doP= ost(AbstractCXFServlet.java:141) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :637) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :717) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:290) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter= (ReplyHeaderFilter.java:96) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:235) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardWrapperValve.invoke(St= andardWrapperValve.java:230) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardContextValve.invoke(St= andardContextValve.java:173) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.SecurityAssociationValve.= invoke(SecurityAssociationValve.java:182) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.JaccContextValve.invoke(J= accContextValve.java:84) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardHostValve.invoke(Stand= ardHostValve.java:128) > =A0 =A0 =A0 =A0at org.apache.catalina.valves.ErrorReportValve.invoke(Erro= rReportValve.java:104) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.service.jca.CachedConnectionValve.= invoke(CachedConnectionValve.java:157) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardEngineValve.invoke(Sta= ndardEngineValve.java:109) > =A0 =A0 =A0 =A0at org.apache.catalina.connector.CoyoteAdapter.service(Coy= oteAdapter.java:241) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Processor.process(Http11= Processor.java:844) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Protocol$Http11Connectio= nHandler.process(Http11Protocol.java:583) > =A0 =A0 =A0 =A0at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEn= dpoint.java:447) > =A0 =A0 =A0 =A0at java.lang.Thread.run(Thread.java:619) > Caused by: org.hibernate.exception.JDBCConnectionException: could not exe= cute query > =A0 =A0 =A0 =A0at org.hibernate.exception.SQLStateConverter.convert(SQLSt= ateConverter.java:74) > =A0 =A0 =A0 =A0at org.hibernate.exception.JDBCExceptionHelper.convert(JDB= CExceptionHelper.java:43) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doList(Loader.java:2223) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader= .java:2104) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.list(Loader.java:2099) > =A0 =A0 =A0 =A0at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.j= ava:378) > =A0 =A0 =A0 =A0at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTra= nslatorImpl.java:341) > =A0 =A0 =A0 =A0at org.hibernate.engine.query.HQLQueryPlan.performList(HQL= QueryPlan.java:172) > =A0 =A0 =A0 =A0at org.hibernate.impl.SessionImpl.list(SessionImpl.java:11= 21) > =A0 =A0 =A0 =A0at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) > =A0 =A0 =A0 =A0at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.j= ava:81) > =A0 =A0 =A0 =A0... 53 more > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The TDS proto= col stream is not valid. > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.termin= ate(SQLServerConnection.java:1368) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.termin= ate(SQLServerConnection.java:1355) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.throwI= nvalidTDS(SQLServerConnection.java:1344) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.TDSReader.throwInvalidTDS(= IOBuffer.java:3190) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBu= ffer$FetchBufferTokenHandler.onRetValue(SQLServerResultSet.java:4624) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.= java:66) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBu= ffer.nextRow(SQLServerResultSet.java:4696) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBu= fferNext(SQLServerResultSet.java:1683) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQ= LServerResultSet.java:956) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.DelegatingResultSet.next(Delega= tingResultSet.java:168) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doQuery(Loader.java:697) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doQueryAndInitializeNonLazy= Collections(Loader.java:236) > =A0 =A0 =A0 =A0at org.hibernate.loader.Loader.doList(Loader.java:2220) > =A0 =A0 =A0 =A0... 61 more > 2010-04-05 09:42:25,454 ERROR [org.hibernate.transaction.JDBCTransaction]= Could not toggle autocommit > com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed= . > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerException.makeFro= mDriverError(SQLServerException.java:170) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkC= losed(SQLServerConnection.java:304) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAut= oCommit(SQLServerConnection.java:1592) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.DelegatingConnection.setAutoCom= mit(DelegatingConnection.java:268) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConn= ectionWrapper.setAutoCommit(PoolingDataSource.java:293) > =A0 =A0 =A0 =A0at org.hibernate.transaction.JDBCTransaction.toggleAutoCom= mit(JDBCTransaction.java:194) > =A0 =A0 =A0 =A0at org.hibernate.transaction.JDBCTransaction.rollbackAndRe= setAutoCommit(JDBCTransaction.java:186) > =A0 =A0 =A0 =A0at org.hibernate.transaction.JDBCTransaction.rollback(JDBC= Transaction.java:162) > =A0 =A0 =A0 =A0at org.hibernate.ejb.TransactionImpl.commit(TransactionImp= l.java:50) > =A0 =A0 =A0 =A0at org.springframework.orm.jpa.JpaTransactionManager.doCom= mit(JpaTransactionManager.java:456) > =A0 =A0 =A0 =A0at org.springframework.transaction.support.AbstractPlatfor= mTransactionManager.processCommit(AbstractPlatformTransactionManager.java:7= 32) > =A0 =A0 =A0 =A0at org.springframework.transaction.support.AbstractPlatfor= mTransactionManager.commit(AbstractPlatformTransactionManager.java:701) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= AspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.jav= a:359) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= Interceptor.invoke(TransactionInterceptor.java:110) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:171) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.JdkDynamicAopProxy.in= voke(JdkDynamicAopProxy.java:204) > =A0 =A0 =A0 =A0at $Proxy147.findByHostname(Unknown Source) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorServiceImpl.recordWor= kUnitResults(MBProcessorServiceImpl.java:115) > =A0 =A0 =A0 =A0at net.cndc.mb.service.ws.MassBatchImpl.recordWorkUnitResu= lts(MassBatchImpl.java:69) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.performI= nvocation(AbstractInvoker.java:166) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:82) > =A0 =A0 =A0 =A0at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMet= hodInvoker.java:55) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:68) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.= run(ServiceInvokerInterceptor.java:57) > =A0 =A0 =A0 =A0at java.util.concurrent.Executors$RunnableAdapter.call(Exe= cutors.java:441) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask$Sync.innerRun(FutureTas= k.java:303) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask.run(FutureTask.java:138= ) > =A0 =A0 =A0 =A0at org.apache.cxf.workqueue.SynchronousExecutor.execute(Sy= nchronousExecutor.java:37) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor.ha= ndleMessage(ServiceInvokerInterceptor.java:95) > =A0 =A0 =A0 =A0at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(= PhaseInterceptorChain.java:236) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.ChainInitiationObserver.onMess= age(ChainInitiationObserver.java:89) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletDestination.inv= oke(ServletDestination.java:99) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= keDestination(ServletController.java:368) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= ke(ServletController.java:183) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.inv= oke(AbstractCXFServlet.java:163) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.doP= ost(AbstractCXFServlet.java:141) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :637) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :717) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:290) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter= (ReplyHeaderFilter.java:96) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:235) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardWrapperValve.invoke(St= andardWrapperValve.java:230) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardContextValve.invoke(St= andardContextValve.java:173) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.SecurityAssociationValve.= invoke(SecurityAssociationValve.java:182) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.JaccContextValve.invoke(J= accContextValve.java:84) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardHostValve.invoke(Stand= ardHostValve.java:128) > =A0 =A0 =A0 =A0at org.apache.catalina.valves.ErrorReportValve.invoke(Erro= rReportValve.java:104) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.service.jca.CachedConnectionValve.= invoke(CachedConnectionValve.java:157) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardEngineValve.invoke(Sta= ndardEngineValve.java:109) > =A0 =A0 =A0 =A0at org.apache.catalina.connector.CoyoteAdapter.service(Coy= oteAdapter.java:241) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Processor.process(Http11= Processor.java:844) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Protocol$Http11Connectio= nHandler.process(Http11Protocol.java:583) > =A0 =A0 =A0 =A0at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEn= dpoint.java:447) > =A0 =A0 =A0 =A0at java.lang.Thread.run(Thread.java:619) > 2010-04-05 09:42:25,454 ERROR [org.hibernate.transaction.JDBCTransaction]= JDBC rollback failed > com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed= . > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerException.makeFro= mDriverError(SQLServerException.java:170) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkC= losed(SQLServerConnection.java:304) > =A0 =A0 =A0 =A0at com.microsoft.sqlserver.jdbc.SQLServerConnection.rollba= ck(SQLServerConnection.java:1655) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.DelegatingConnection.rollback(D= elegatingConnection.java:265) > =A0 =A0 =A0 =A0at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConn= ectionWrapper.rollback(PoolingDataSource.java:288) > =A0 =A0 =A0 =A0at org.hibernate.transaction.JDBCTransaction.rollbackAndRe= setAutoCommit(JDBCTransaction.java:183) > =A0 =A0 =A0 =A0at org.hibernate.transaction.JDBCTransaction.rollback(JDBC= Transaction.java:162) > =A0 =A0 =A0 =A0at org.hibernate.ejb.TransactionImpl.commit(TransactionImp= l.java:50) > =A0 =A0 =A0 =A0at org.springframework.orm.jpa.JpaTransactionManager.doCom= mit(JpaTransactionManager.java:456) > =A0 =A0 =A0 =A0at org.springframework.transaction.support.AbstractPlatfor= mTransactionManager.processCommit(AbstractPlatformTransactionManager.java:7= 32) > =A0 =A0 =A0 =A0at org.springframework.transaction.support.AbstractPlatfor= mTransactionManager.commit(AbstractPlatformTransactionManager.java:701) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= AspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.jav= a:359) > =A0 =A0 =A0 =A0at org.springframework.transaction.interceptor.Transaction= Interceptor.invoke(TransactionInterceptor.java:110) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.ReflectiveMethodInvoc= ation.proceed(ReflectiveMethodInvocation.java:171) > =A0 =A0 =A0 =A0at org.springframework.aop.framework.JdkDynamicAopProxy.in= voke(JdkDynamicAopProxy.java:204) > =A0 =A0 =A0 =A0at $Proxy147.findByHostname(Unknown Source) > =A0 =A0 =A0 =A0at net.cndc.mb.service.db.MBProcessorServiceImpl.recordWor= kUnitResults(MBProcessorServiceImpl.java:115) > =A0 =A0 =A0 =A0at net.cndc.mb.service.ws.MassBatchImpl.recordWorkUnitResu= lts(MassBatchImpl.java:69) > =A0 =A0 =A0 =A0at sun.reflect.GeneratedMethodAccessor258.invoke(Unknown S= ource) > =A0 =A0 =A0 =A0at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delegat= ingMethodAccessorImpl.java:25) > =A0 =A0 =A0 =A0at java.lang.reflect.Method.invoke(Method.java:597) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.performI= nvocation(AbstractInvoker.java:166) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:82) > =A0 =A0 =A0 =A0at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMet= hodInvoker.java:55) > =A0 =A0 =A0 =A0at org.apache.cxf.service.invoker.AbstractInvoker.invoke(A= bstractInvoker.java:68) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.= run(ServiceInvokerInterceptor.java:57) > =A0 =A0 =A0 =A0at java.util.concurrent.Executors$RunnableAdapter.call(Exe= cutors.java:441) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask$Sync.innerRun(FutureTas= k.java:303) > =A0 =A0 =A0 =A0at java.util.concurrent.FutureTask.run(FutureTask.java:138= ) > =A0 =A0 =A0 =A0at org.apache.cxf.workqueue.SynchronousExecutor.execute(Sy= nchronousExecutor.java:37) > =A0 =A0 =A0 =A0at org.apache.cxf.interceptor.ServiceInvokerInterceptor.ha= ndleMessage(ServiceInvokerInterceptor.java:95) > =A0 =A0 =A0 =A0at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(= PhaseInterceptorChain.java:236) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.ChainInitiationObserver.onMess= age(ChainInitiationObserver.java:89) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletDestination.inv= oke(ServletDestination.java:99) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= keDestination(ServletController.java:368) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.ServletController.invo= ke(ServletController.java:183) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.inv= oke(AbstractCXFServlet.java:163) > =A0 =A0 =A0 =A0at org.apache.cxf.transport.servlet.AbstractCXFServlet.doP= ost(AbstractCXFServlet.java:141) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :637) > =A0 =A0 =A0 =A0at javax.servlet.http.HttpServlet.service(HttpServlet.java= :717) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:290) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter= (ReplyHeaderFilter.java:96) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.interna= lDoFilter(ApplicationFilterChain.java:235) > =A0 =A0 =A0 =A0at org.apache.catalina.core.ApplicationFilterChain.doFilte= r(ApplicationFilterChain.java:206) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardWrapperValve.invoke(St= andardWrapperValve.java:230) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardContextValve.invoke(St= andardContextValve.java:173) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.SecurityAssociationValve.= invoke(SecurityAssociationValve.java:182) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.security.JaccContextValve.invoke(J= accContextValve.java:84) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardHostValve.invoke(Stand= ardHostValve.java:128) > =A0 =A0 =A0 =A0at org.apache.catalina.valves.ErrorReportValve.invoke(Erro= rReportValve.java:104) > =A0 =A0 =A0 =A0at org.jboss.web.tomcat.service.jca.CachedConnectionValve.= invoke(CachedConnectionValve.java:157) > =A0 =A0 =A0 =A0at org.apache.catalina.core.StandardEngineValve.invoke(Sta= ndardEngineValve.java:109) > =A0 =A0 =A0 =A0at org.apache.catalina.connector.CoyoteAdapter.service(Coy= oteAdapter.java:241) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Processor.process(Http11= Processor.java:844) > =A0 =A0 =A0 =A0at org.apache.coyote.http11.Http11Protocol$Http11Connectio= nHandler.process(Http11Protocol.java:583) > =A0 =A0 =A0 =A0at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEn= dpoint.java:447) > =A0 =A0 =A0 =A0at java.lang.Thread.run(Thread.java:619) > 2010-04-05 09:42:25,454 WARN =A0[org.hibernate.util.JDBCExceptionReporter= ] SQL Error: 0, SQLState: null > 2010-04-05 09:42:25,454 ERROR [org.hibernate.util.JDBCExceptionReporter] = Already closed. > 2010-04-05 09:42:25,454 WARN =A0[org.hibernate.util.JDBCExceptionReporter= ] SQL Error: 0, SQLState: null > 2010-04-05 09:42:25,454 ERROR [org.hibernate.util.JDBCExceptionReporter] = Already closed. > > -----Original Message----- > From: Phil Steitz [mailto:phil.steitz@gmail.com] > Sent: Tuesday, April 06, 2010 5:56 AM > To: Commons Users List > Subject: [dbcp] Re: "Connection reset" exceptions > > Bruno Melloni wrote: >> I started getting these on a long-running command-line application, with= Spring, SQL Server and DBCP for the DataSource. =A0 What I found by googli= ng seems to point towards: >> >> >> a) =A0 =A0 =A0The database times out on idle connections and resets them= . =A0Then DBCP does not know how to handle it and fails. >> >> b) =A0 =A0 =A0A network failure causes a failure that triggers the error= . >> >> The only solutions I found suggest that there is a bug in DBCP and that = I should switch to the c3p0 DataSource/connection pool. =A0But I suspect th= at there must be a way (perhaps through config settings) to make DBCP not h= ave these issues. =A0I would welcome any help that I can get. >> >> Thank you. >> >> > > First, note the [dbcp] prepended to the subject. =A0Putting the > component name at the start of the subject is our convention on this > list. > > Now to your problem. It would be useful to have a little more > information: > > 1) What versions of commons dbcp and commons pool are you running? > The latest versions at this time are dbcp 1.3 (for JDK 1.4-1.5) or > dbcp 1.4 (JDK 1.6) and pool 1.5.4. > > 2) Can you please provide a sample stack trace of the exception that > you are getting? > > Thanks! > > Phil > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscribe@commons.apache.org > For additional commands, e-mail: user-help@commons.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: user-unsubscribe@commons.apache.org > For additional commands, e-mail: user-help@commons.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@commons.apache.org For additional commands, e-mail: user-help@commons.apache.org