Oracle10g/11g, scrollable cursors, and JDBC scrollable result

From: jms <>
Date: Tue, 30 Sep 2008 16:51:50 -0700 (PDT)
Message-ID: <>

According to the following documents from Oracle's JDBC drivers for 10g and 11g:

To quote:

"Oracle JDBC Implementation for Result Set Scrollability

Because the underlying server does not support scrollable cursors, Oracle JDBC must implement scrollability in a separate layer.

It is important to be aware that this is accomplished by using a client-side memory cache to store rows of a scrollable result set.

Because all rows of any scrollable result set are stored in the client- side cache, a situation where the result set contains many rows, many columns, or very large columns might cause the client-side Java virtual machine (JVM) to fail. Do not specify scrollability for a large result set."

But Oracle's own documentation for the database server itself says that it does support scrollable cursors:

So the question is ... what does Oracle's JDBC thin driver actually do ?? Does it use a scrollable cursor or not ? If not, which one does ?

John Received on Tue Sep 30 2008 - 18:51:50 CDT

Original text of this message