-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

View unanswered posts | View active topics


Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]


Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 
  Previous topic | Next topic 
Author Message
EdLaFave
 Post subject: AbstractBatcher - exception clearing maxRows/queryTimeout
PostPosted: Wed Dec 03, 2008 4:38 pm 
Newbie

Joined: Mon Jan 28, 2008 1:55 pm
Posts: 19
I'm using Hibernate, Spring, and Microsoft SQL Server 2005. At seemingly random times I get an error that prevents me from loading a User object from the database. After the error occurs I can try again with success. Any ideas on why this is happening?

I just realized the Microsoft SQL JDBC Driver, sqljdbc.jar, that we've been using is about 1/2 the size as the current one available for download on Microsofts site. Perhaps using the new JDBC driver will correct the issue.

Hibernate version:
3
Mapping documents:
Code:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
        "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
   
   <typedef name="SettingType" class="emst.persistence.GenericEnumUserType">
      <param name="enumClass">emst.dao.user.SettingType</param>
   </typedef>
   <class name="emst.dao.user.User" table="UserData">
       <id name="loginName" length="100">
         <generator class="assigned"/>
      </id>
      <property name="receiveUpdates"/>
      <property name="password" type="binary"/>   
      <property name="approved"/>            
      <property name="fontSize"/>            
      <map name="settings" table="UserSettings" cascade="all" lazy="false">
         <key column="userId"/>
         <map-key column="settingType" type="SettingType"/>
         <element column="settingValue" type="boolean"/>      
      </map>
   </class>
</hibernate-mapping>

Configuration File- Spring xml file to setup the Session Factory
Code:
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
      <property name="driverClassName">
         <value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>
      </property>
      <property name="url">
         <value>${jdbc.baseUrl};database=${jdbc.databaseName};user=${jdbc.username};password=${jdbc.password}</value>
      </property>
      <property name="username">
         <value>${jdbc.username}</value>
      </property>
      <property name="password">
         <value>${jdbc.password}</value>
      </property>
   </bean>
   <bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
      <property name="dataSource">
         <ref local="dataSource"/>
      </property>
      <property name="hibernateProperties">
         <props>
            <prop key="hibernate.cache.use_second_level_cache">false</prop>
            <prop key="hibernate.hbm2ddl.auto">update</prop>
            <prop key="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</prop>
            <prop key="hibernate.query.substitutions">${hibernate.query.substitutions}</prop>
            <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
            <prop key="hibernate.c3p0.minPoolSize">5</prop>
            <prop key="hibernate.c3p0.maxPoolSize">20</prop>
            <prop key="hibernate.c3p0.timeout">600</prop>
            <prop key="hibernate.c3p0.max_statement">50</prop>
         </props>
      </property>
      <!-- Must references all OR mapping files. -->
      <property name="mappingResources">
         <list>
            <value>emst/dao/user/User.hbm.xml</value>
            </list>
      </property>

Code between sessionFactory.openSession() and session.close():
Code:
User user = userDao.getByKey(username);

Full stack trace of any exception that occurs:
Code:
WARN : [02.12.08 12:57:36 PM] org.hibernate.jdbc.AbstractBatcher - exception clearing maxRows/queryTimeout
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.checkClosed(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerStatement.getMaxRows(Unknown Source)
   at org.apache.commons.dbcp.DelegatingStatement.getMaxRows(DelegatingStatement.java:237)
   at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:276)
   at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:212)
   at org.hibernate.loader.Loader.getResultSet(Loader.java:1801)
   at org.hibernate.loader.Loader.doQuery(Loader.java:674)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
   at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
   at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
   at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
   at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044)
   at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
   at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
   at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
   at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
   at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
   at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
   at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
   at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
   at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:528)
   at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
   at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
   at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:522)
   at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:516)
   at emst.dao.AbstractDao.getByKey(AbstractDao.java:106)
   at emst.remoting.services.LoginService.login(LoginService.java:60)
   at sun.reflect.GeneratedMethodAccessor1090.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:406)
   at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
   at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1417)
   at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:878)
   at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)
   at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
   at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:49)
   at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
   at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)
   at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:274)
   at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:377)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
   at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
   at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
   at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
   at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
   at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
   at java.lang.Thread.run(Unknown Source)
WARN : [02.12.08 12:57:36 PM] org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: 08S01
ERROR: [02.12.08 12:57:36 PM] org.hibernate.util.JDBCExceptionReporter - Connection reset by peer: socket write error
WARN : [02.12.08 12:57:36 PM] org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
ERROR: [02.12.08 12:57:36 PM] org.hibernate.util.JDBCExceptionReporter - Already closed.
WARN : [02.12.08 12:57:36 PM] org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
ERROR: [02.12.08 12:57:36 PM] org.hibernate.util.JDBCExceptionReporter - Already closed.
[EMST]12/02/2008 12:57:36.168 [ERROR] Error processing remote invocation: org.springframework.dao.DataAccessResourceFailureException: could not load an entity: [emst.dao.user.User#demo]; nested exception is org.hibernate.exception.JDBCConnectionException: could not load an entity: [emst.dao.user.User#demo]
  incomingMessage: Flex Message (flex.messaging.messages.RemotingMessage)
    operation = login
    clientId = 2D9639A2-E909-9CF7-9022-34771FD072F9
    destination = LoginService
    messageId = D24901CB-A5F5-7413-9CC1-F947833CCE68
    timestamp = 1228247856121
    timeToLive = 0
    body = null
    hdr(DSId) = 2D95918D-201A-AA34-72B4-5476C710530C
    hdr(DSEndpoint) = my-amf
org.springframework.dao.DataAccessResourceFailureException: could not load an entity: [emst.dao.user.User#demo]; nested exception is org.hibernate.exception.JDBCConnectionException: could not load an entity: [emst.dao.user.User#demo]
   at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:612)
   at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
   at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
   at org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
   at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:522)
   at org.springframework.orm.hibernate3.HibernateTemplate.get(HibernateTemplate.java:516)
   at emst.dao.AbstractDao.getByKey(AbstractDao.java:106)
   at emst.remoting.services.LoginService.login(LoginService.java:60)
   at sun.reflect.GeneratedMethodAccessor1090.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
   at java.lang.reflect.Method.invoke(Unknown Source)
   at flex.messaging.services.remoting.adapters.JavaAdapter.invoke(JavaAdapter.java:406)
   at flex.messaging.services.RemotingService.serviceMessage(RemotingService.java:183)
   at flex.messaging.MessageBroker.routeMessageToService(MessageBroker.java:1417)
   at flex.messaging.endpoints.AbstractEndpoint.serviceMessage(AbstractEndpoint.java:878)
   at flex.messaging.endpoints.amf.MessageBrokerFilter.invoke(MessageBrokerFilter.java:121)
   at flex.messaging.endpoints.amf.LegacyFilter.invoke(LegacyFilter.java:158)
   at flex.messaging.endpoints.amf.SessionFilter.invoke(SessionFilter.java:49)
   at flex.messaging.endpoints.amf.BatchProcessFilter.invoke(BatchProcessFilter.java:67)
   at flex.messaging.endpoints.amf.SerializationFilter.invoke(SerializationFilter.java:146)
   at flex.messaging.endpoints.BaseHTTPEndpoint.service(BaseHTTPEndpoint.java:274)
   at flex.messaging.MessageBrokerServlet.service(MessageBrokerServlet.java:377)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
   at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
   at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
   at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767)
   at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697)
   at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889)
   at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
   at java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.JDBCConnectionException: could not load an entity: [emst.dao.user.User#demo]
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:74)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
   at org.hibernate.loader.Loader.loadEntity(Loader.java:1874)
   at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:48)
   at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:42)
   at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3044)
   at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:395)
   at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:375)
   at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:139)
   at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:195)
   at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:103)
   at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:878)
   at org.hibernate.impl.SessionImpl.get(SessionImpl.java:815)
   at org.hibernate.impl.SessionImpl.get(SessionImpl.java:808)
   at org.springframework.orm.hibernate3.HibernateTemplate$1.doInHibernate(HibernateTemplate.java:528)
   at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:419)
   ... 35 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset by peer: socket write error
   at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
   at com.microsoft.sqlserver.jdbc.TDSWriter.flush(Unknown Source)
   at com.microsoft.sqlserver.jdbc.TDSWriter.endRequest(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source)
   at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source)
   at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(Unknown Source)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
   at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
   at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
   at org.hibernate.loader.Loader.doQuery(Loader.java:674)
   at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
   at org.hibernate.loader.Loader.loadEntity(Loader.java:1860)
   ... 48 more

Name and version of the database you are using:
Microsoft SQL Server 2005
Top
 Profile  
 
jlpuff
 Post subject: Re: AbstractBatcher - exception clearing maxRows/queryTimeout
PostPosted: Tue Jun 02, 2009 11:27 am 
Newbie

Joined: Tue Jun 02, 2009 11:25 am
Posts: 1
Did you ever figure out the solution to this? I see the same issue.
Top
 Profile  
 
mikeR94
 Post subject: Re: AbstractBatcher - exception clearing maxRows/queryTimeout
PostPosted: Tue Jun 09, 2009 4:36 am 
Newbie

Joined: Tue Jun 09, 2009 4:33 am
Posts: 2
Hello,

I also got the same problem, does ayone has a solution?

Thanks
Top
 Profile  
 
arpit.chugh4
 Post subject: Re: AbstractBatcher - exception clearing maxRows/queryTimeout
PostPosted: Thu Jul 09, 2015 6:14 am 
Newbie

Joined: Tue Jun 30, 2015 9:43 am
Posts: 1
Hi,

I am still facing this issue has anyone find the solution.

2015-07-09 06:29:58,280 [WebContainer : 24] WARN org.hibernate.jdbc.AbstractBatcher - exception clearing maxRows/queryTimeout
com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcWrapper.createClosedException(WSJdbcWrapper.java:114)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:1852)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.getMaxRows(WSJdbcStatement.java:1270)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298)
at org.hibernate.jdbc.AbstractBatcher.closeStatements(AbstractBatcher.java:369)
at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:320)
at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:248)
at org.hibernate.transaction.CacheSynchronization.afterCompletion(CacheSynchronization.java:118)
at org.hibernate.transaction.WebSphereExtendedJTATransactionLookup$TransactionManagerAdapter$TransactionAdapter$1.invoke(WebSphereExtendedJTATransactionLookup.java:206)
at $Proxy137.afterCompletion(Unknown Source)
at com.ibm.ws.jtaextensions.SynchronizationCallbackWrapper.afterCompletion(SynchronizationCallbackWrapper.java:75)
at com.ibm.tx.jta.impl.RegisteredSyncs.coreDistributeAfter(RegisteredSyncs.java:359)
at com.ibm.ws.tx.jta.RegisteredSyncs.distributeAfter(RegisteredSyncs.java:319)
at com.ibm.tx.jta.impl.EmbeddableTransactionImpl.distributeAfter(EmbeddableTransactionImpl.java:193)
at com.ibm.tx.jta.impl.TransactionImpl.postCompletion(TransactionImpl.java:2943)
at com.ibm.tx.jta.impl.TransactionImpl.postCompletion(TransactionImpl.java:2856)
at com.ibm.tx.jta.impl.TransactionImpl.commitXAResources(TransactionImpl.java:1851)
at com.ibm.ws.tx.jta.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:569)
at com.ibm.tx.jta.impl.TransactionImpl.processCommit(TransactionImpl.java:1015)
at com.ibm.tx.jta.impl.TransactionImpl.commit(TransactionImpl.java:949)
at com.ibm.ws.tx.jta.TranManagerImpl.commit(TranManagerImpl.java:438)
at com.ibm.tx.jta.impl.TranManagerSet.commit(TranManagerSet.java:181)
at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:950)
at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:265)
at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:579)
at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4873)
at com.ahold.ers.alert.ejb.alert.EJSLocalStatelessAlertListManager_938347c3.readAlertList(Unknown Source)
at sun.reflect.GeneratedMethodAccessor4732.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.ejb.access.LocalSlsbInvokerInterceptor.invokeInContext(LocalSlsbInvokerInterceptor.java:70)
at org.springframework.ejb.access.AbstractSlsbInvokerInterceptor.invoke(AbstractSlsbInvokerInterceptor.java:188)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy27.readAlertList(Unknown Source)
at com.ahold.ers.web.actions.AlertListAction.queryList(AlertListAction.java:201)
at com.ahold.ers.web.actions.AlertListAction.access$200(AlertListAction.java:48)
at com.ahold.ers.web.actions.AlertListAction$QueryAction.execute(AlertListAction.java:373)
at com.ahold.ers.web.actions.AlertListAction.execute(AlertListAction.java:65)
at com.ahold.ers.web.ReplenishmentAction.execute(ReplenishmentAction.java:185)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)
at com.ahold.ers.web.servlet.ReplenishmentActionServlet.service(ReplenishmentActionServlet.java:88)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1224)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:774)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:456)
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)
at com.ahold.ers.web.servlet.filter.PerformanceMonitorFilter.doFilter(PerformanceMonitorFilter.java:52)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ahold.ers.web.servlet.filter.TimeMeasurementFilter.doFilter(TimeMeasurementFilter.java:30)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ahold.ers.web.servlet.filter.ApplyExpiresHeaderFilter.doFilter(ApplyExpiresHeaderFilter.java:44)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:895)
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:557)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:607)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:984)
at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1069)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1690)

Regards,
Arpit chugh
Top
 Profile  
 
ashokreddy.karne
 Post subject: Re: AbstractBatcher - exception clearing maxRows/queryTimeout
PostPosted: Fri Nov 18, 2016 10:03 am 
Newbie

Joined: Thu Nov 17, 2016 5:18 pm
Posts: 2
Hi All,

I am facing this issue. Any ideas please?



2016-11-17 14:47:18,563 INFO [STDOUT] (http-0.0.0.0-8080-5) 14:47:18,559 WARN [AbstractBatcher] exception clearing maxRows/queryTimeout
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:388)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.checkClosed(SQLServerStatement.java:978)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getMaxRows(SQLServerStatement.java:1011)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1822)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2228)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
at org.hibernate.loader.Loader.list(Loader.java:2120)

Thanks
Ashok
Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  Page 1 of 1
  [ 5 posts ] 

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.