Home » Developer & Programmer » JDeveloper, Java & XML » JDBC/OCI driver feature
JDBC/OCI driver feature [message #92670] Fri, 12 November 2004 20:43
Shahram Javidnia
Messages: 1
Registered: November 2004
Junior Member
As you know, OCI has a new feature named Scrollable Cursor which is supported through OCIStmtFetch2().

In the following JDBC code, the driver does not return OCI-backed cursor, instead it returns a cached result set which has performance penalties for my application:

con = getConnection();
stmt = con.prepareStatement(STMT, ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

How can I force JDBC/OCI driver to use OCIStmtFetch2() when creating a ResultSet object?

Thx.
Previous Topic: oracle universal installer error
Next Topic: JDBC: Multithreaded CLOB insertion in Oracle 9i
Goto Forum:
  


Current Time: Fri Mar 29 01:16:12 CDT 2024