I'm trying to use a Weblogic connection pool and Oracle OCI drivers to call an Oracle stored procedure and return a REF CURSOR.
Weblogic 5.1 sp11
Oracle 8.1.6
The WL connection pool and OCI driver combination does not appear to work. The pool is created on WebLogic startup as expected.
Weblogic Properties Snippet
weblogic.jdbc.connectionPool.prmdPool=\
url=jdbc
racle
ci8:@dbOracle,\
driver=oracle.jdbc.driver.OracleDriver,\
loginDelaySecs=1,\
initialCapacity=1,\
maxCapacity=40,\
capacityIncrement=1,\
allowShrinking=true,\
shrinkPeriodMins=15,\
props=user=testuser;password=*;
Java Code Snippet
this.setConnectionURL("jdbc:weblogic
ool
rmdPool");
this.setJDBCDriverName("weblogic.jdbc.pool.Driver");
cstatement.registerOutParameter(2, OracleTypes.CURSOR);
cstatement.execute();
rs = (ResultSet)cstatement.getObject(2);
I think because the stored procedure request gets filtered through the WebLogic driver, which does not recognize OracleTypes.CURSOR, an exception is thrown. The underlying Oracle driver requires the OracleTypes.CURSOR type for the Ref Cursor to be returned as a ResultSet.
Has anyone had this issue or have suggestions as to a resolution.
Thanks,
Scott