This is a multi-part message in MIME format.
------=_NextPart_000_2458_01C1CB51.77324FE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Read and respond to this message at:
http://sourceforge.net/forum/message.php?msg_id=1509427
By: kevem
Yes, setFetchSize is supported for cursored resultsets.
In autocommit mode you don't have a choice, the only way to obtain a resultset
is by fetching all of its rows.
If autocommit is off, you may choose between fetching the set in one go, and
using a cursor to fetch in pieces.
You choose this via the ResultSetType parameter when creating a Statement,
TYPE_FORWARD_ONLY uses cursors, TYPE_SCROLL_INSENSITIVE fetches the whole set.
jxDBCon supports cursored ResultSets for more than 6 months now.
Please continue evaluating the driver!
Keve
______________________________________________________________________
You are receiving this email because you elected to monitor this forum.
To stop monitoring this forum, login to SourceForge and visit:
http://sourceforge.net/forum/monitor.php?forum_id=81298
------=_NextPart_000_2458_01C1CB51.77324FE0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Somebody asked about the official JDBC driver vs. jxdbcon and this =
morning there was some talk about cursors and result sets, so here is =
something relevant to that:<BR><font face=3D"Arial, Helvetica, =
sans-serif" size=3D"2" =
style=3D"font-size:13.5px">______________________________________________=
_________________<BR>Get your own FREE email account at =
iVillage.com!<br>http://webmail.ivillage.com/</font><BR><BR><-----Origina=
l Message-----><BR> <BR>Read and respond to this message at: =
<BR>http://sourceforge.net/forum/message.php?msg_id=3D1509427<BR>By: =
kevem<BR><BR>Yes, setFetchSize is supported for cursored =
resultsets.<BR><BR>In autocommit mode you don't have a choice, the only =
way to obtain a resultset<BR>is by fetching all of its rows.<BR>If =
autocommit is off, you may choose between fetching the set in one go, =
and<BR>using a cursor to fetch in pieces.<BR>You choose this via the =
ResultSetType parameter when creating a Statement,<BR>TYPE_FORWARD_ONLY =
uses cursors, TYPE_SCROLL_INSENSITIVE fetches the whole set.<BR>jxDBCon =
supports cursored ResultSets for more than 6 months now.<BR>
------=_NextPart_000_2458_01C1CB51.77324FE0--
