Re: Does JDBC have client-side and server-side cursors like ADO/ODBC? -- JAVA400-L

Charles,

I believe the server sends back blocks of records to the client, so for a
certain number of records the .next () method requires no communication
back to the server, but when the cache of records is used up, another block
will be retrieved from the server, they aren't retrieved one-at-a-time.
You should be able to alter this behaviour by setting the 'block criteria'
and 'block size' properties on the JDBC connection, but I've never had a
need to do this so haven't tried it.  If you look in the InfoCentre in the
Javadoc for the various connection classes there is more info about this.

Hope this helps,

Nigel Gay.
Computer Patent Annuities.



|---------+------------------------------>
|         |           CWilt@xxxxxxxxxxxx |
|         |           Sent by:           |
|         |           java400-l-bounces@m|
|         |           idrange.com        |
|         |                              |
|         |                              |
|         |           03/11/2004 10:26 AM|
|         |           Please respond to  |
|         |           Java Programming on|
|         |           and around the     |
|         |           iSeries / AS400    |
|         |                              |
|---------+------------------------------>
  
>--------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                 |
  |       To:       java400-l@xxxxxxxxxxxx                                      
                                 |
  |       cc:                                                                   
                                 |
  |       Subject:  Does JDBC have client-side and server-side cursors like 
ADO/ODBC?                            |
  
>--------------------------------------------------------------------------------------------------------------|




Using JDBC to connect the iSeries.

Going to have a stored procedure return a results set.

Trying to figure out if JDBC provides both "server-side" and "client-side"
cursors like ADO/ODBC does.

If so, which is the default and how do you use the other?

If not, is a JDBC cursor server-side or client-side?



For definition:

In a server-side cursor, each row set to the client when the client does
the
"next" method.

In a client-side cursor, the entire result set is sent to the client.
Thus,
no network traffic occurs moving back and forth in the results set.


Thanks in advance,


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

--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.








********************************************************************************
The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee; access to this
email by anyone else is unauthorised.

If you are not the intended recipient: (1) you are kindly requested
to return a copy of this message to the sender indicating that you
have received it in error, and to destroy the received copy; and (2)
any disclosure or distribution of this message, as well as any action
taken or omitted to be taken in reliance on its content, is prohibited
and may be unlawful.
********************************************************************************