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".