Re: Oracle 8i type4 jdbc driver (classes1.2.zip) refreshRow() error...

From: Martin Ramshaw <mramshaw_at_alumni.concordia.ca>
Date: Thu, 30 Mar 2000 13:15:11 -0000
Message-ID: <6jPE4.3073$142.39034@newscontent-01.sprint.ca>

Sounds like a combination of two things; server-side buffering and a scroll-sensitive resultSet. From your comments, I'd guess the server-side buffer caches somewhere between 6-8 records.

When you need to access records not in the cache, the buffer needs to be refreshed from the database (since you have defined the resultSet as scroll-sensitive). I'd look at increasing the buffer cache size, or else using a scroll-insensitive resultSet.

All of the above assumes that resultSet.relative() works correctly (as you say it does) which indicates that you really *do* have a JDBC 2.0 driver.

My $0.02.

david h wrote in message <38E10297.A8113F51_at_ualberta.ca>...
>Hi there,
>
>I am implementing a distributed app using Oracle8 Server and the Oracle
>8i 8.1.6 driver for JDK 1.2.x . I have created a prepared statment
>which uses the scrollable result set as follows:

<snip> Received on Thu Mar 30 2000 - 07:15:11 CST