使用sql2005
jdbc配置如下：
使用LoadRunner 录制脚本， 打开首页，然后进入一篇文章。并发300 出现如下错误。
2010-06-03 04:50 WARN c.m.v.c.i.NewPooledConnection - [c3p0] A PooledConnection that has already signalled a Connection error is still in use!
2010-06-03 04:50 WARN c.m.v.c.i.NewPooledConnection - [c3p0] Another error has occurred [ com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。 ] which will not be reported to listeners!
com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) [sqljdbc.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(Unknown Source) [sqljdbc.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.clearWarnings(Unknown Source) [sqljdbc.jar:na]
at com.mchange.v2.c3p0.impl.NewProxyConnection.clearWarnings(NewProxyConnection.java:933) [c3p0-0.9.1.2.jar:0.9.1.2]
at org.hibernate.util.JDBCExceptionReporter.logAndClearWarnings(JDBCExceptionReporter.java:54) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.jdbc.ConnectionManager.closeConnection(ConnectionManager.java:472) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.jdbc.ConnectionManager.cleanup(ConnectionManager.java:408) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.jdbc.ConnectionManager.close(ConnectionManager.java:347) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.impl.SessionImpl.close(SessionImpl.java:325) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.springframework.orm.hibernate3.SessionFactoryUtils.closeSession(SessionFactoryUtils.java:791) [spring-orm-2.5.6.jar:2.5.6]
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.closeSession(OpenSessionInViewFilter.java:280) [spring-orm-2.5.6.jar:2.5.6]
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:208) [spring-orm-2.5.6.jar:2.5.6]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) [spring-web-2.5.6.jar:2.5.6]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina.jar:6.0.26]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:6.0.26]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) [catalina.jar:6.0.26]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina.jar:6.0.26]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina.jar:6.0.26]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina.jar:6.0.26]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina.jar:6.0.26]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [catalina.jar:6.0.26]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) [tomcat-coyote.jar:6.0.26]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat-coyote.jar:6.0.26]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) [tomcat-coyote.jar:6.0.26]
at java.lang.Thread.run(Thread.java:595) [na:1.5.0_14]
2010-6-3 16:50:14 org.apache.catalina.core.StandardWrapperValve invoke
信息: 2010-06-03 04:50 ERROR o.h.t.JDBCTransaction - JDBC begin failed
com.microsoft.sqlserver.jdbc.SQLServerException: 该连接已关闭。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source) [sqljdbc.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(Unknown Source) [sqljdbc.jar:na]
at com.microsoft.sqlserver.jdbc.SQLServerConnection.getAutoCommit(Unknown Source) [sqljdbc.jar:na]
at com.mchange.v2.c3p0.impl.NewProxyConnection.getAutoCommit(NewProxyConnection.java:985) [c3p0-0.9.1.2.jar:0.9.1.2]
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353) [hibernate-core-3.3.1.GA.jar:3.3.1.GA]
at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:558) [spring-orm-2.5.6.jar:2.5.6]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374) [spring-tx-2.5.6.jar:2.5.6]
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263) [spring-tx-2.5.6.jar:2.5.6]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101) [spring-tx-2.5.6.jar:2.5.6]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) [spring-aop-2.5.6.jar:2.5.6]
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) [spring-aop-2.5.6.jar:2.5.6]
at $Proxy9.getWebsite(Unknown Source) [na:na]
at com.jeecms.core.FrontAction.getWeb(FrontAction.java:68) [FrontAction.class:na]
at com.jeecms.core.FrontAction.getTplBase(FrontAction.java:84) [FrontAction.class:na]
at sun.reflect.GeneratedMethodAccessor961.invoke(Unknown Source) [na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [na:1.5.0_14]
at java.lang.reflect.Method.invoke(Method.java:585) [na:1.5.0_14]
at ognl.OgnlRuntime.invokeMethod(OgnlRuntime.java:517) [ognl-2.6.11.jar:na]
at ognl.OgnlRuntime.getMethodValue(OgnlRuntime.java:931) [ognl-2.6.11.jar:na]
at ognl.ObjectPropertyAccessor.getPossibleProperty(ObjectPropertyAccessor.java:53) [ognl-2.6.11.jar:na]
at ognl.ObjectPropertyAccessor.getProperty(ObjectPropertyAccessor.java:121) [ognl-2.6.11.jar:na]
at com.opensymphony.xwork2.ognl.accessor.ObjectAccessor.getProperty(ObjectAccessor.java:17) [xwork-2.1.2.jar:na]
at ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1643) [ognl-2.6.11.jar:na]
at com.opensymphony.xwork2.ognl.accessor.CompoundRootAccessor.getProperty(CompoundRootAccessor.java:106) [xwork-2.1.2.jar:na]
at ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1643) [ognl-2.6.11.jar:na]
at ognl.ASTProperty.getValueBody(ASTProperty.java:92) [ognl-2.6.11.jar:na]
at ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170) [ognl-2.6.11.jar:na]
at ognl.SimpleNode.getValue(SimpleNode.java:210) [ognl-2.6.11.jar:na]
at ognl.Ognl.getValue(Ognl.java:333) [ognl-2.6.11.jar:na]
at ognl.Ognl.getValue(Ognl.java:310) [ognl-2.6.11.jar:na]
at com.opensymphony.xwork2.ognl.OgnlUtil.getValue(OgnlUtil.java:196) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.ognl.OgnlValueStack.findValue(OgnlValueStack.java:229) [xwork-2.1.2.jar:na]
at org.apache.struts2.views.freemarker.ScopesHashModel.get(ScopesHashModel.java:70) [struts-core-2.1.6.jar:na]
at freemarker.core.Environment.getGlobalVariable(Environment.java:1062) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.getVariable(Environment.java:1048) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Identifier._getAsTemplateModel(Identifier.java:70) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Expression.getStringValue(Expression.java:93) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.DollarVariable.accept(DollarVariable.java:76) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.MixedContent.accept(MixedContent.java:92) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.renderElementToString(Environment.java:1568) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.StringLiteral.getStringValue(StringLiteral.java:101) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Include.accept(Include.java:124) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.IfBlock.accept(IfBlock.java:82) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.IfBlock.accept(IfBlock.java:82) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Macro$Context.runMacro(Macro.java:168) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:602) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.UnifiedCall.accept(UnifiedCall.java:106) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.MixedContent.accept(MixedContent.java:92) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.visit(Environment.java:209) [freemarker-2.3.15.jar:2.3.15]
at freemarker.core.Environment.process(Environment.java:189) [freemarker-2.3.15.jar:2.3.15]
at freemarker.template.Template.process(Template.java:237) [freemarker-2.3.15.jar:2.3.15]
at org.apache.struts2.views.freemarker.FreemarkerResult.doExecute(FreemarkerResult.java:187) [struts-core-2.1.6.jar:na]
at org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:186) [struts-core-2.1.6.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:361) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:265) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) [xwork-2.1.2.jar:na]
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) [struts-core-2.1.6.jar:na]
at com.opensymphony.xwork2.ActionChainResult.execute(ActionChainResult.java:222) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:361) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:265) [xwork-2.1.2.jar:na]
at com.jeecms.common.struts2.interceptor.UrlInterceptor.doIntercept(UrlInterceptor.java:91) [UrlInterceptor.class:na]
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) [xwork-2.1.2.jar:na]
at com.jeecms.core.web.CookieIdentityInterceptor.doIntercept(CookieIdentityInterceptor.java:59) [CookieIdentityInterceptor.class:na]
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) [xwork-2.1.2.jar:na]
at com.jeecms.common.struts2.interceptor.DomainNameInterceptor.doIntercept(DomainNameInterceptor.java:24) [DomainNameInterceptor.class:na]
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176) [xwork-2.1.2.jar:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) [xwork-2.1.2.jar:na]
at com.jeecms.common.struts2.interceptor.ProcessingStartInterceptor.intercept(ProcessingStartInterceptor.java:32) [ProcessingStartInterceptor.class:na]
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236) [xwork-2.1.2.jar:na]
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52) [struts-core-2.1.6.jar:na]
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:532) [struts-core-2.1.6.jar:na]
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395) [struts-core-2.1.6.jar:na]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina.jar:6.0.26]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:6.0.26]
at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) [spring-orm-2.5.6.jar:2.5.6]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) [spring-web-2.5.6.jar:2.5.6]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) [catalina.jar:6.0.26]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) [catalina.jar:6.0.26]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219) [catalina.jar:6.0.26]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) [catalina.jar:6.0.26]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) [catalina.jar:6.0.26]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [catalina.jar:6.0.26]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [catalina.jar:6.0.26]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) [catalina.jar:6.0.26]
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) [tomcat-coyote.jar:6.0.26]
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) [tomcat-coyote.jar:6.0.26]
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) [tomcat-coyote.jar:6.0.26]
at java.lang.Thread.run(Thread.java:595) [na:1.5.0_14] |
|
