could not inspect JDBC autocommit mode

在使用hibernate连接池（ProxoolConf.xml）时经常出现
这个异常（could not inspect JDBC autocommit mode）一直没有得到解决，希望能帮忙看下，耽误你宝贵时间了：
1.hibernate.cfg.xml

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
          "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
          "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<!-- Generated by MyEclipse Hibernate Tools.                   -->
<hibernate-configuration>

 <session-factory>
  <property name="proxool.pool_alias">pool1</property>
  <property name="proxool.xml">ProxoolConf.xml</property>
  <property name="connection.provider_class">
   org.hibernate.connection.ProxoolConnectionProvider
  </property>
  <property name="current_session_context_class">thread</property>
  <mapping resource="com/test/vo/Hotsell.hbm.xml" />
  <mapping resource="com/test/vo/Administrator.hbm.xml" />
 </session-factory>

</hibernate-configuration>

 

2.ProxoolConf.xml配置

 

<?xml version="1.0" encoding="utf-8"?>
<!-- the proxool configuration can be embedded within your own application's.
 Anything outside the "proxool" tag is ignored. -->
<something-else-entirely>
 <proxool>
  <alias>pool1</alias>
  <!--proxool只能管理由自己产生的连接-->
  <driver-url>
   jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=gb2312
  </driver-url>
  <driver-class>org.gjt.mm.mysql.Driver</driver-class>
  <driver-properties>
   <property name="user" value="root" />
   <property name="password" value="root" />
  </driver-properties>
  <!-- proxool自动侦察各个连接状态的时间间隔(毫秒),侦察到空闲的连接就马上回收,超时的销毁-->
  <house-keeping-sleep-time>90000</house-keeping-sleep-time>
  <!-- 指因未有空闲连接可以分配而在队列中等候的最大请求数,超过这个请求数的用户连接就不会被接受-->
  <maximum-new-connections>20</maximum-new-connections>
  <!-- 最少保持的空闲连接数-->
  <prototype-count>5</prototype-count>
  <!-- 允许最大连接数,超过了这个连接，再有请求时，就排在队列中等候，最大的等待请求数由maximum-new-connections决定-->
  <maximum-connection-count>100</maximum-connection-count>
  <!-- 最小连接数-->
  <minimum-connection-count>10</minimum-connection-count>
 </proxool>
</something-else-entirely>

 

3.出现异常

 

org.apache.jasper.JasperException:
could not inspect JDBC autocommit mode
at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspSer
vletWrapper.java:460)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:373)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
29)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDisp
atcher.java:679)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationD
ispatcher.java:584)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDis
patcher.java:497)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary
.java:965)
at org.apache.jsp.views.index.protocol_jsp._jspService(protocol_jsp.java
:80)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper
.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
29)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at com.icxq.filter.EncodingFilter.doFilter(EncodingFilter.java:35)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
rocessConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
int.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFol
lowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadP
ool.java:689)
at java.lang.Thread.run(Thread.java:595)

评论

3 楼 yisshengyouni 2012-07-10  

不知道这么多年过去了楼主解决没有，
解决了分享下吧
[e-mail]

2 楼 sopships 2009-05-04  

楼主解决没有啊？？我也遇到了这个问题，楼主怎么解决的？？

1 楼 east_java 2008-10-17  

现在解决了吗?