Hi, all i have a very hard problem trying to configure the C3P0 conexion pool, i'm sure that the problem is in the automaticTestTable property of the ComboPooledDataSource.
I use Oracle and i think that the problem is related with the schemas.
I think that when C3P0 try to test the connections that are idle it use a sql sentence that doesn't take into account the schemas of Oracle and in consecuence the sentence rise an exception like this:
Quote:
[FINER] com.mchange.v2.c3p0.impl.NewPooledConnection@1c6f1f4 handling a throwable.java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:304)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:271)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:625)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:499)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:941)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:531)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1036)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2904)
Any suggestion will be very appreciated,
Baromir.
Login
FAQ
Search