• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Weblogic Connection Pool and Oracle OCI Drivers

 
scott gaidos
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic