To be precise, JDBC 2.0 features a RowSet interface with two
implementation varieties: CachedRowSet and JdbcRowSet. Only CachedRowSet
is serializable, does not hold onto a connection and _does_ support a
conventional JDBC 1.x ResultSet data source. The drawback is that it
fetches the entire result and sends it to the client.

Fred Loney
Spirited Software, Inc.
www.spiritedsw.com

----- Original Message -----
From: "Ramesh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 5:46 AM
Subject: Re: Can i have ResultSet as return value .


> hi
>   The result set is not available after the conenction is closed. It
is not
> serializable and you can not
> return it to a client application, but you have a cached result set,
called
> Rowset in JDBC2.0. All the DB
> vendors are not supporting it, it can be returned by a method
> thanks
> ramesh
>
> -----Original Message-----
> From: A mailing list for Enterprise JavaBeans development
> [mailto:[EMAIL PROTECTED]]On Behalf Of EJB G
> Sent: Wednesday, December 12, 2001 7:06 PM
> To: [EMAIL PROTECTED]
> Subject: Can i have ResultSet as return value .
>
>
> Can Remote method
> in EJB remote have java.sql.Resultset as return
> value.
> According to me its no as ResultSet is not
> serializable.

===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".

Reply via email to