Apache Tomcat/7.0.64 - Error report

澳门皇冠娱乐场

HTTP Status 500 - org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select count(*) as col_0_0_ from HD_PORTLSP.PORTLSP_NEWS portlspnew0_ where portlspnew0_.PN_CHANNEL='1' order by to_number(portlspnew0_.PN_ORDER) desc]; SQL state [72000]; error code [1000]; ORA-01000: maximum open cursors exceeded


type Exception report

message org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select count(*) as col_0_0_ from HD_PORTLSP.PORTLSP_NEWS portlspnew0_ where portlspnew0_.PN_CHANNEL='1' order by to_number(portlspnew0_.PN_ORDER) desc]; SQL state [72000]; error code [1000]; ORA-01000: maximum open cursors exceeded

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.jboss.resteasy.spi.UnhandledException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select count(*) as col_0_0_ from HD_PORTLSP.PORTLSP_NEWS portlspnew0_ where portlspnew0_.PN_CHANNEL='1' order by to_number(portlspnew0_.PN_ORDER) desc]; SQL state [72000]; error code [1000]; ORA-01000: maximum open cursors exceeded
; nested exception is java.sql.SQLException: ORA-01000: maximum open cursors exceeded

	org.jboss.resteasy.core.SynchronousDispatcher.unwrapException(SynchronousDispatcher.java:345)
	org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:321)
	org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:214)
	org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:190)
	org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:534)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)
	org.jboss.resteasy.core.SynchronousDispatcher.invokePropagateNotFound(SynchronousDispatcher.java:155)
	org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:212)
	org.jboss.resteasy.plugins.server.servlet.FilterDispatcher.doFilter(FilterDispatcher.java:59)
	com.filter.EncodingFilter.doFilter(EncodingFilter.java:37)

root cause

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select count(*) as col_0_0_ from HD_PORTLSP.PORTLSP_NEWS portlspnew0_ where portlspnew0_.PN_CHANNEL='1' order by to_number(portlspnew0_.PN_ORDER) desc]; SQL state [72000]; error code [1000]; ORA-01000: maximum open cursors exceeded
; nested exception is java.sql.SQLException: ORA-01000: maximum open cursors exceeded

	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
	org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
	org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
	org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)
	org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:343)
	net.huadong.common.dao.impl.HibernateEntityDAO.query(HibernateEntityDAO.java:92)
	net.huadong.common.dao.impl.HibernateEntityDAO.query(HibernateEntityDAO.java:71)
	sun.reflect.GeneratedMethodAccessor9142.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	com.sun.proxy.$Proxy125.query(Unknown Source)
	net.huadong.chinaports.service.NewsService.listNews(NewsService.java:21)
	net.huadong.chinaports.service.NewsService$$FastClassByCGLIB$$57e6e4dd.invoke(<generated>)
	net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
	org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
	net.huadong.chinaports.service.NewsService$$EnhancerByCGLIB$$998b1f93.listNews(<generated>)
	net.huadong.chinaports.resource.NewsResource.getPortlspNewsView(NewsResource.java:580)
	sun.reflect.GeneratedMethodAccessor9677.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
	org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)
	org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)
	org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)
	org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)
	org.jboss.resteasy.core.SynchronousDispatcher.invokePropagateNotFound(SynchronousDispatcher.java:155)
	org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:212)
	org.jboss.resteasy.plugins.server.servlet.FilterDispatcher.doFilter(FilterDispatcher.java:59)
	com.filter.EncodingFilter.doFilter(EncodingFilter.java:37)

root cause

java.sql.SQLException: ORA-01000: maximum open cursors exceeded

	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
	oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
	oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
	oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
	oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
	oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
	oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
	oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:776)
	oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:897)
	oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
	oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
	oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
	oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
	org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
	org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
	org.hibernate.loader.Loader.getResultSet(Loader.java:1808)
	org.hibernate.loader.Loader.doQuery(Loader.java:697)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
	org.hibernate.loader.Loader.doList(Loader.java:2228)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125)
	org.hibernate.loader.Loader.list(Loader.java:2120)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361)
	org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
	org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:835)
	net.huadong.common.dao.impl.HibernateEntityDAO$2.doInHibernate(HibernateEntityDAO.java:107)
	org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
	org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:343)
	net.huadong.common.dao.impl.HibernateEntityDAO.query(HibernateEntityDAO.java:92)
	net.huadong.common.dao.impl.HibernateEntityDAO.query(HibernateEntityDAO.java:71)
	sun.reflect.GeneratedMethodAccessor9142.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
	com.sun.proxy.$Proxy125.query(Unknown Source)
	net.huadong.chinaports.service.NewsService.listNews(NewsService.java:21)
	net.huadong.chinaports.service.NewsService$$FastClassByCGLIB$$57e6e4dd.invoke(<generated>)
	net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
	org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
	net.huadong.chinaports.service.NewsService$$EnhancerByCGLIB$$998b1f93.listNews(<generated>)
	net.huadong.chinaports.resource.NewsResource.getPortlspNewsView(NewsResource.java:580)
	sun.reflect.GeneratedMethodAccessor9677.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:498)
	org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
	org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)
	org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)
	org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)
	org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)
	org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)
	org.jboss.resteasy.core.SynchronousDispatcher.invokePropagateNotFound(SynchronousDispatcher.java:155)
	org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:212)
	org.jboss.resteasy.plugins.server.servlet.FilterDispatcher.doFilter(FilterDispatcher.java:59)
	com.filter.EncodingFilter.doFilter(EncodingFilter.java:37)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.64 logs.


Apache Tomcat/7.0.64