jsp Can't start a cloned connection while in manual transaction mode解决

最新推荐文章于 2015-04-26 16:53:23 发布
最新推荐文章于 2015-04-26 16:53:23 发布
阅读量1.8k 收藏
点赞数
文章标签： jsp sqlserver microsoft hibernate jdbc exception
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Mrtom/article/details/2296173
版权

今天很郁闷。。在做查询的时候，不知道什么地方出现错误总是抛出异常如：

1.在游览器上显示：

HTTP Status 500 -

type Exception report

message

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

exception 

javax.servlet.ServletException
	org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:516)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:423)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	com.stuman.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:89)

 

root cause 

java.lang.NullPointerException
	com.stuman.web.struts.action.TeacherAction.getStuInfo(TeacherAction.java:364)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	java.lang.reflect.Method.invoke(Unknown Source)
	org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
	com.stuman.web.struts.action.BaseAction.execute(BaseAction.java:51)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	com.stuman.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:89)

 

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

Apache Tomcat/5.5.23

 

 

在后台显示：Hibernate: select enrol0_.class_id as class1_, enrol0_.stu_id as stu2_, enrol0_.accept as accept5_, enrol0_.score as score5_, enrol0_.class_id as class1_5_, enrol0_.stu_id as stu2_5_ from stu.dbo.enrol enrol0_ where class_id='2' and stu_id='2'
Hibernate: select classes0_.id as id0_, classes0_.tea_id as tea2_4_0_, classes0_.cour_id as cour3_4_0_, classes0_.room_id as room4_4_0_, classes0_.cour_time as cour5_4_0_ from stu.dbo.classes classes0_ where classes0_.id=?
2008-04-16 10:38:13,390 - org.hibernate.util.JDBCExceptionReporter -29594 [http-8080-Processor23] WARN  org.hibernate.util.JDBCExceptionReporter  - SQL Error: 0, SQLState: 08007
2008-04-16 10:38:13,390 - org.hibernate.util.JDBCExceptionReporter -29594 [http-8080-Processor23] ERROR org.hibernate.util.JDBCExceptionReporter  - [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
2008-04-16 10:38:13,390 - org.hibernate.util.JDBCExceptionReporter -29594 [http-8080-Processor23] WARN  org.hibernate.util.JDBCExceptionReporter  - SQL Error: 0, SQLState: 08007
2008-04-16 10:38:13,390 - org.hibernate.util.JDBCExceptionReporter -29594 [http-8080-Processor23] ERROR org.hibernate.util.JDBCExceptionReporter  - [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
2008-04-16 10:38:13,406 - org.hibernate.event.def.DefaultLoadEventListener -29610 [http-8080-Processor23] INFO  org.hibernate.event.def.DefaultLoadEventListener  - Error performing load command
org.hibernate.exception.JDBCConnectionException: could not load an entity: [com.stuman.domain.Classes#2]
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:66)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
 at org.hibernate.loader.Loader.loadEntity(Loader.java:1359)
 at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:116)
 at org.hibernate.loader.entity.EntityLoader.load(EntityLoader.java:101)
 at org.hibernate.persister.entity.BasicEntityPersister.load(BasicEntityPersister.java:2471)
 at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:351)
 at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:332)
 at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:113)
 at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:151)
 at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:79)
 at org.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:655)
 at org.hibernate.type.EntityType.resolveIdentifier(EntityType.java:261)
 at org.hibernate.type.EntityType.resolve(EntityType.java:286)
 at org.hibernate.type.ComponentType.resolve(ComponentType.java:445)
 at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:182)
 at org.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:759)
 at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:292)
 at org.hibernate.loader.Loader.doQuery(Loader.java:412)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
 at org.hibernate.loader.Loader.doList(Loader.java:1593)
 at org.hibernate.loader.Loader.list(Loader.java:1577)
 at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
 at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
 at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
 at com.stuman.dao.imp.EnrolDAOImp.getEnrolByID(EnrolDAOImp.java:91)
 at com.stuman.web.struts.action.TeacherAction.getStuInfo(TeacherAction.java:358)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
 at com.stuman.web.struts.action.BaseAction.execute(BaseAction.java:51)
 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:690)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.stuman.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:89)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
 at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.
 at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
 at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source)
 at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown Source)
 at com.microsoft.jdbc.base.BaseStatement.<init>(Unknown Source)
 at com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
 at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)
 at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396)
 at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:334)
 at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:88)
 at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1162)
 at org.hibernate.loader.Loader.doQuery(Loader.java:390)
 at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
 at org.hibernate.loader.Loader.loadEntity(Loader.java:1345)
 ... 54 more
2008-04-16 10:38:13,406 - com.stuman.dao.imp.EnrolDAOImp -29610 [http-8080-Processor23] FATAL com.stuman.dao.imp.EnrolDAOImp  - org.hibernate.exception.JDBCConnectionException: could not load an entity: [com.stuman.domain.Classes#2]
enrol==null
2008-04-16 10:38:13,421 - org.apache.struts.action.RequestProcessor -29625 [http-8080-Processor23] WARN  org.apache.struts.action.RequestProcessor  - Unhandled Exception thrown: class java.lang.NullPointerException
2008-04-16 10:38:13,421 - org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/MyStuMan].[action] -29625 [http-8080-Processor23] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/MyStuMan].[action]  - Servlet.service() for servlet action threw exception
java.lang.NullPointerException
 at com.stuman.web.struts.action.TeacherAction.getStuInfo(TeacherAction.java:364)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
 at java.lang.reflect.Method.invoke(Unknown Source)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
 at com.stuman.web.struts.action.BaseAction.execute(BaseAction.java:51)
 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:690)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.stuman.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:89)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
 at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
 at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
 at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
 at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
 at java.lang.Thread.run(Unknown Source)

请教了老师后才发现：在hibernate的数据库连接配置要加上一句jdbc:microsoft:sqlserver://localhost:1433;SelectMethod=cursor;DatabaseName=stu

运行发现真的没有事。我觉得可能是我在做两个个查询。。。

导致问题的出现。

Mrtom
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Removing Credentials from a Cloned EBS Production Database (Doc
03-27
Removing Credentials from a Cloned EBS Production Database (Doc ID 419475.1)
How to Detect Cloned Tags in a Reliable Way
11-07
国外研究成果，主要是描述RFID相关的攻击技术等。对于理论研究很有帮助。
Can't start a cloned connection while in manual transaction mode.错误的解决方案
生活在爪洼岛上
02-24 3793
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Cant start a cloned connection while in manual transaction mode. at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown So
Can't start a cloned connection while in manual transaction mode.
生活在爪洼岛上
08-22 765
Cant start a cloned connection while in manual transaction mode. sql server数据库在代码中数据是手动提交的，包了上面的错误，将手动提交的设置删除就没问题了。我不知道在建表的时候要怎么设置才能不报错。以下是网上的解释：原因一般是当你在一个SQL SERVER的JDBC连接上执行多个STATEMENTS的操作，
Can't start a cloned connection while in manual transaction mode的解决方法
阿布个人学习自留地
09-21 1443
出现该异常的原因是原来的Hibernate的连接池的连接速度以及管理模式都不够好,所以本人换了第三方的c3p0连接池.之后就出现了这个异常.在网上查了一下原因在手工事务模式 (AutoCommit=false) 下，如果使用直接 (SelectMethod=direct) 模式，当您尝试对使用 JDBC 驱动程序的 SQL Server 数据库执行多个语句时，将会出现此问题。直接模式是该驱动程序的
Can't start a cloned connection while in manual transaction mode.解决方法
风达的专栏
10-28 1528
 在进行HQL查询是出现的错误：使用iterate进行查询，代码如下，报出Cant start a cloned connection while in manual transaction mode.错误，            Iterator iter = session.createQuery("from Student").iterate();     
sql server 出现Can't start a cloned connection while in manual transaction mode 的解决方法
coolzeze的专栏
04-21 1666
最近使用hibernate在sql server上进行开发可行性验证的工作，默认的连接URL为一直使用jdbc:microsoft:sqlserver://localhost:1433;databaseName=cow。但在一个事务中先取出数据，再进行更新时发现一个很奇怪的问题，sql server 提示Cant start a cloned connection while in manu
Expression and methylation status of imprinted gene IGF2R in lung of deceased cloned transgenic dairy goat
03-12
转基因克隆奶山羊肺脏中印迹基因IGF2R的DNA甲基化水平，张艳丽，张国敏，奶山羊是转基因克隆法制备乳腺生物反应器的理想模型，然而克隆动物往往存在肺脏发育异常。基因组印迹对肺脏的正常生长发育起着重
Two-staged nuclear transfer can enhance the developmental ability of goat—sheep interspecies nuclear transfer embryos in vitro
02-20
The technique of interspecies somatic cell nuclear transfer, in which interspecies cloned embryos can be reconstructed by using domestic animal oocytes as nuclear recipients and endangered animal or ...
Dashboard-cloned
05-22
创建一个静态仪表盘因此，我们已经谈论了很多有关react ， state和props 。 现在该采取行动了。 在本实验中，我们将利用到目前为止学到的概念来创建下面提供的仪表板模拟的静态版本。操作说明分叉并克隆此回购切换到...
Can't start a cloned connection while in manual transaction mode
ivan_zhang_blog的专栏
04-20 2151
 解决方案：(1)你在尝试打开一个克隆连接，有两种解决办法： 每个数据库的连接在执行完毕后，关闭，第二，在连接时，判断是否已经有连接存在，有则使用现成的连接。 数据库连接可以设置成一个常量，不需要到处定义。便于维护。解决方案：(2)你在DatabaseURL字符串中加入SelectMethod=Cursor;如下 jdbc:microsoft:sqlserver://127.0.0
[Microsoft][SQLServer JDBC Driver]Can't start a cloned connection while in manual transaction mode
nickshen3的专栏
08-11 1442
SYMPTOMSloadTOCNode(1, symptoms);While using the Microsoft SQL Server 2000 Driver for JDBC, you may experience the following exception:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver
Sql Server2000 Can't start a cloned connection while in manual transaction mode
生活简单化
04-03 903
Sql Server2000设置事务时 conn.setAutoCommit(false); //执行语句sql1,sql2 conn.commit(); 结果出现Can't start a cloned connection while in manual transaction mode错误，从网上找到原因及解决办法如下： 原因一般是当你在一个SQL SERVER的JDBC连接上执行
Can't start a cloned connection while in manual transaction mode错误
liangjw1018的专栏
11-28 96
MENTS的操作，或者是手动事务状态（AutoCommit=false) 并且使用默认的模式. direct (SelectMethod=direct) 模式. 解决办法 当你使用手动事务模式时，必须把SelectMethod 属性的值设置为 Cursor, 或者是确保在你的连接只有一个STATEMENT操作。 修改url 加入SelectMethod=cursor即可 如:jdbc:microsoft:sqlserver://localhost:1433;DatabaseName
iBatis使用SQLServer出现Can't start a cloned connection while in manual transaction mode.错误
waltertan1988的博客
04-26 487
今天使用spring+iBatis+SQL Server2000做东东，可在执行query时老抛异常： Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Can't start a cloned connection while in manual transaction mode.      
unable to find element in cloned iframe怎么解决
最新发布
05-05
"unable to find element in cloned iframe" 错误通常是由于在克隆的 iframe 中查找元素时出现的问题。有几种方法可以解决这个问题： 1. 确保你的 iframe 已经加载完成，然后再查找元素。你可以在 window.onload ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值