Re: [JDBC] default fetch size

2001-09-16 Thread Barry Lind
Dave, The protocol for the clients to talk with the backend server doesn't support the concept of a fetch size. When a query is executed it's entire result is sent to the client. (You can explicitly work around this by using cursors see the DECLARE and FETCH sql commands). thanks, --Barry

[JDBC] default fetch size

2001-09-15 Thread Dave Thompson
Hi all, I'm doing some research into tightly coupling data mining applications to PostgreSQL, and have a couple of questions: 1) What's the default fetch size set by the jdbc driver (jdbc7.0-1.2.jar)? 2) Is there any way to change this other than by editing the source code? The setFetchSize and