RE: Subset of a ResultSet - Dorel Vaida - com.mysql.lists.java

3 messages in com.mysql.lists.javaRE: Subset of a ResultSet

From	Sent On	Attachments
Ozgur Sahoglu	03 Dec 2002 15:01
Dorel Vaida	03 Dec 2002 23:50
Dorel Vaida	05 Dec 2002 07:50

Subject:	RE: Subset of a ResultSet
From:	Dorel Vaida (Dore...@ags.ro)
Date:	12/05/2002 07:50:44 AM
List:	com.mysql.lists.java

test. sorry. changed email address

-----Original Message----- From: Dorel Vaida Sent: Wednesday, December 04, 2002 9:51 AM To: Ozgur Sahoglu; ja...@lists.mysql.com Subject: RE: Subset of a ResultSet

I think what you are looking for is a disconnected RowSet. This is a JDBC 2.0 feature. See javax.sql.RowSet. Yo can even serialize it an send it to the client, than read data from it just like you would read from a ResultSet. Except that the 'disconnected' RowSet disconnects from the database after fetching data.

Hope it helps.

-----Original Message----- From: Ozgur Sahoglu [mailto:ozgu...@sdsu.edu] Sent: Wednesday, December 04, 2002 1:01 AM To: ja...@lists.mysql.com Subject: Subset of a ResultSet

Hi All,

I wanna send a small subset (10 records at a time) of my ResultSet to the clients for my database application. There are ways to come around this problem, but I wanna learn if it is possible to return a subset of a ResultSet with a method. Any comments?

Ozgur Sahoglu

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <java...@lists.mysql.com> To unsubscribe, e-mail <java-unsubscribe-dorel.vaida=gebs...@lists.mysql.com>