[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-java
Subject:    Re: ResultSet Streaming
From:       Mark Matthews <mark () mysql ! com>
Date:       2006-03-11 1:11:13
Message-ID: 441223B1.30108 () mysql ! com
[Download RAW message or body]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Robert DiFalco wrote:
> But it requires you to alter the SQL statement to use it? Is that
> correct? Or is it just the connection property. 

Robert,

Just the connection URL, for example:

jdbc:mysql://my-5-0-server/test?user=...&password=....&useCursorFetch=true

Then anytime you call .setFetchSize() on a statement, you'll get the row
fetching behavior you're looking for.

You can set a default fetch size to be used for all newly-created
statements with the URL property "defaultFetchSize" (it defaults to 0,
which means retrieve all rows).

Once again, this feature is experimental on the server side, which is
why it's not publicized widely, so let us know if you run into any issues.

	-Mark
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFEEiOxtvXNTca6JD8RAp1RAJ9OgIDNrKAm71fMdkdaorpBJTSfCACeNmRD
4oTRDSm67sBr10tLz58PIRc=
=rxSn
-----END PGP SIGNATURE-----

-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/java?unsub=mysql-java@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]