| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
