关于hibernate的连接池问题

程序是用struts和hibernate写的，数据库是oracle
程序一开始用的是hibernate自带的连接池，程序在使用一段时间后，就常常报错，数据库的IO异常错误。
然后又在hibernate的配置文件中加入了DBCP连接池，但是程序运行的时候会报“打开游标超过最大数”的错误。
又换成了C3P0连接池，程序执行查询操作的时候没问题，但是执行更新数据库的时候就会报“Problem with checked-in Statement, discarding”错误。
最后改用tomcat的连接池，程序可以正常运行，但是还不知道用户增多，运行时间加长以后会不会还有错误。

程序在执行数据库操作后都会session.close()，我觉得应该不存在数据库资源没有释放的问题，但就是原来用hibernate自带的连接池，运行时间长以后就会报数据库IO异常，所以想加一个连接池改善一下性能，但第三方的连接池总是不能正常使用，这是为什么？
最后用了tomcat提供的连接池，程序性能会有改善吗？数据库资源是不是由连接池自己管理了？

 

 

 Problem with checked-in Statement, discarding.
java.lang.NullPointerException
 at oracle.jdbc.dbaccess.DBData.clearItem(DBData.java:431)
 at oracle.jdbc.dbaccess.DBDataSetImpl.clearItem(DBDataSetImpl.java:3528)
 at oracle.jdbc.driver.OraclePreparedStatement.clearParameters(OraclePreparedStatement.java:3401)
 at com.mchange.v2.c3p0.stmt.GooGooStatementCache.refreshStatement(GooGooStatementCache.java:460)
 at com.mchange.v2.c3p0.stmt.GooGooStatementCache.checkinStatement(GooGooStatementCache.java:139)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnection$1WrapperStatementHelper.doClose(C3P0PooledConnection.java:511)
 at com.mchange.v2.c3p0.impl.C3P0PooledConnection$2.close(C3P0PooledConnection.java:570)
 at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:471)
 at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:218)
 at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:198)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
 at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:296)
 at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009)
 at com.lanxin.common.base.impl.HibernateDAO.remove(HibernateDAO.java:251)
 at com.lanxin.module.org.bizlogic.impl.UserLogic.remove(UserLogic.java:88)
 at com.lanxin.module.org.action.UserAction.executeRemove(UserAction.java:220)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
 at java.lang.reflect.Method.invoke(Method.java:597)
 at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270)
 at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187)
 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
 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.lanxin.common.filter.LoginFilter.doFilter(LoginFilter.java:72)
 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
 at com.lanxin.common.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:43)
 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:213)
 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:174)
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
 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:689)
 at java.lang.Thread.run(Thread.java:619)

 

配置文件如下：

        <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
        <!-- JDBC URL -->
        <property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
        <!-- 数据库用户名 -->
        <property name="connection.username">cw_sys</property>
        <!-- 数据库密码 -->
        <property name="connection.password">lanxin</property>
        <property name="c3p0.min_size">5</property>
        <property name="c3p0.max_size">20</property>
        <property name="c3p0.timeout">1800</property>
        <property name="c3p0.max_statements">20</property>

        <property name="show_sql">false</property>
        <property name="dialect">
             org.hibernate.dialect.Oracle9Dialect
        </property>

网上Google一下,答案五花八门，最后确定两种解决方法：

第一种，有的说把<property name="c3p0.max_statements">0</property>

第二种，说是JDBC驱动的问题

试了第一种，发现设置为0以后，Tomcat启动就不能启动

第二种，我的Oracle是10g的，换了安装程序中的ojdbc14.jar后，还真的不报错了，看来还是要驱动和当前操作的数据库对应