Hello,
I'm facing a problem trying to call a stored procedure using the c3p0 connection pooling.
The SP parameters values are being set dynamically : in one call only the ones on odd position, in other call the others (or something like that)
I've tried setting the parameters values by their name and not index and I get the same result.

After a few calls like that (I can't determine) I'm getting

java.sql.SQLException: Invalid column index
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.OraclePreparedStatement.setLongInternal(OraclePreparedStatement.java:4018)
at oracle.jdbc.driver.OracleCallableStatement.setLong(OracleCallableStatement.java:2117)
at com.mchange.v2.c3p0.impl.NewProxyCallableStatement.setLong(NewProxyCallableStatement.java:1325)


I'm using c3p0-0.9.1.2.jar and hibernate3.jar on a oracle 10g db