I have encountered following problem:
"Missing IN or OUT parameter at index:: ..."
if I use ComboPooledDataSource, activate statement caching (with MaxStatements or MaxStatementsPerConnection) and use prepared statement that execute insert and returns auto-generated keys.
Oracle version - 10.2.1XE (both server and JDBC driver).
See attached gkc3p0.zip for all details.
mumu_create.sql - creates table and sequence for test programs.
gk.java - program that operates without c3p0 (gets connection from DriverManager) and reexecutes the same prepared statement many times; run without errors.
gkC3P0.java - program that uses CombpPooled datasource;
in setMaxStaements(180) is commented out, then run without errors, if it is commented in, above mentioned exception occurs.
Just for completness - error seems to be Oracle-specific, for Derby and DB2/400 it does not occur.
Log in to post a comment.