title: Does Oracle support Server-Side Scrollable Cursors via JDBC?
body: <p>Currently working in the deployment of an OFBiz based ERP, we've come to the following problem: some of the code of the framework calls the resultSet.last() to know the total rows of the resultset. Using the Oracle JDBC Driver v11 and v10, it tries to cache all of the rows in the client memory, crashing the JVM because it doesn't have enough heap space.</p>
  
  <p>After researching, the problem seems to be that the Oracle JDBC implements the Scrollable Cursor in the client-side, instead of in the server, by the use of a cache. Using the datadirect driver, that issue is solved, but it seems that the call to resultset.last() takes too much to complete, thus the application server aborts the transaction</p>
  
  <p>is there any way to implemente scrollable cursors via jdbc in oracle without resorting to the datadirect driver?</p>
  
  <p>and what is the fastest way to know the length of a given resultSet??</p>
  
  <p>Thanks in advance
  Ismael</p>