RE: Does JDBC have client-side and server-side cursors like ADO/O DBC?

[CWilt@xxxxxxxxxxxx]

Chris,

Thanks for the info.

As far as which driver I'm using, are you looking for version info?  I'm
using the jt400 that comes with iSeries Access v5r3.

Charles Wilt
iSeries Systems Administrator / Programmer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121


> -----Original Message-----
> From: chris.delashmutt@xxxxxxxxxxxxx 
> [mailto:chris.delashmutt@xxxxxxxxxxxxx]
> Sent: Wednesday, November 03, 2004 9:39 AM
> To: Java Programming on and around the iSeries / AS400
> Subject: Re: Does JDBC have client-side and server-side 
> cursors like ADO/ODBC?
> 
> 
> 
> The short answer is that it depends.
> 
> In my experience with Type 4 (remote access) JDBC Drivers, 
> rows sent lazily
> to the client side.  This means that only the data for a row 
> (or possibly a
> small block of rows) is sent to the client at once.  However, I don't
> believe the spec states which way a driver has to work.  I 
> would venture a
> guess that most of your high end JDBC drivers (SQL Server, 
> DB/2, iSeries
> Toolkit, Oracle, etc) should operate that way.
> 
> It should be easy to test, however, by writing a small test 
> harness that
> creates a query that returns a small number of rows (50 or so?) and
> exhausts that ResultSet.  Next, create a query that uses 
> similar SQL as the
> first query but returns a large number of rows (1 million?) and then
> exhausts this new ResultSet as well.  Run each harness in 
> profiling mode
> and you should be able to track memory usage.  If you see a 
> large spike in
> memory usage on the second test compared to the first test, 
> then you could
> say that the driver is probably sending more of the ResultSet 
> data down to
> the client than the first.  Of course, this is perhaps an
> over-simplification.
> 
> It would be helpful to know which JDBC Driver you are working with.
> 
> Chris DeLashmutt
> Senior R&D Analyst
> LeasePlan USA
> 1165 Sanctuary Pkwy., Alpharetta, GA 30004
> Phone: 678-202-8695
> Fax: 678-921-4895
> ClearCase problems? Check out the LeasePlan ClearCase FAQ for answers!
> 
> 
>                                                               
>                                                               
>