Hi,

I'm having problems with connection pool C3P0, I update the jar file to:

c3p0-0.9.0.4
c3p0-oracle-thin-extras-0.9.0.4

But, the problem don't stop.
Can You help me?

Rogério.


Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
Hibernate 2

Mapping documents:

# File: hibernate.cfg.xml
- <session-factory>
- <!-- properties -->
<property name="dialect">net.sf.hibernate.dialect.OracleDialect</property>
<property name="show_sql">false</property>
<property name="use_outer_join">false</property>
<property name="connection.username">consignet</property>
<property name="connection.password">consignet</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">myStringConnection</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.max_size">20</property>
<property name="hibernate.c3p0.timeout">1800</property>
<property name="hibernate.c3p0.max_statements">100</property>
<property name="hibernate.c3p0.idle_test_period">100</property>
<property name="hibernate.jdbc.batch_size">0</property>
- <!-- mapping files -->
...

#C3P0.properties

c3p0.idleConnectionTestPeriod=100
c3p0.automaticTestTable=C3P0TESTCONNECTION

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:
09/05/2006 08:03:35 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 17002, SQLState: null
09/05/2006 08:03:35 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Exceção de E/S: Connection reset
09/05/2006 08:03:35 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 17002, SQLState: null
09/05/2006 08:03:35 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Exceção de E/S: Connection reset
09/05/2006 08:03:35 net.sf.hibernate.JDBCException <init>
SEVERE: Could not execute query
java.sql.SQLException: Exceção de E/S: Connection reset
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:445)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:460)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:185)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:168)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:614)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:492)
at sun.reflect.GeneratedMethodAccessor214.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache$3.run(GooGooStatementCache.java:469)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)
09/05/2006 08:03:35 br.com.db1.database.UsuarioDAO getByCondition
SEVERE: Error on query UsuarioDAO --> Could not execute query
Could not execute query
net.sf.hibernate.JDBCException: Could not execute query
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1547)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at br.com.db1.database.UsuarioDAO.getByCondition(UsuarioDAO.java:70)
at br.com.db1.business.UsuarioBusiness.getUsuario(UsuarioBusiness.java:110)
at br.com.db1.business.ConsigFacade.getUsuario(ConsigFacade.java:212)
at br.com.db1.consignet.struts.action.LoginAction.login(LoginAction.java:70)
at sun.reflect.GeneratedMethodAccessor1022.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:276)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:196)
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.doPost(ActionServlet.java:415)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at br.com.db1.consignet.servlet.LoginFilter.doFilter(LoginFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Exceção de E/S: Connection reset
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:445)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:460)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:185)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:168)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:614)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:492)
at sun.reflect.GeneratedMethodAccessor214.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache$3.run(GooGooStatementCache.java:469)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)
09/05/2006 08:03:41 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 17002, SQLState: null
09/05/2006 08:03:41 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Exceção de E/S: Broken pipe
09/05/2006 08:03:41 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 17002, SQLState: null
09/05/2006 08:03:41 net.sf.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Exceção de E/S: Broken pipe
09/05/2006 08:03:41 net.sf.hibernate.JDBCException <init>
SEVERE: Could not execute query
java.sql.SQLException: Exceção de E/S: Broken pipe
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:211)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:324)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:445)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:460)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:185)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:168)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:614)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:492)
at sun.reflect.GeneratedMethodAccessor214.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache$3.run(GooGooStatementCache.java:469)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)

Name and version of the database you are using:

Oracle 8i

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt: