ResultSet is not serializable, so you cannot pass it on. You could use
CachedRowSet, or put the values into a serializable Lisa/Array
Nathan
----- Original Message -----
From: "Papo Napolitano" <[EMAIL PROTECTED]>
To: "jboss" <[EMAIL PROTECTED]>
Sent: Tuesday, November 13, 2001 1:24 PM
Subject: [JBoss-user] Error running a class that returns a ResultSet
> Hi!
>
> I've a class that execute a query to a database and the returns the
> ResultSet to JSP.
> After the ResultSet was returned I got this error:
>
> [EmbeddedCatalinaServiceSX] StandardWrapperValve[jsp]: Servlet.service()
for
> servlet jsp threw exception
> java.io.NotSerializableException: org.jboss.pool.jdbc.ResultSetInPool
>
> I'm running JBoss 2.4.2 and Tomcat 4.0.
>
> try {
> Statement stmt = this.dbConnection.createStatement() ;
> ResultSet rs = stmt.executeQuery("SELECT * from users") ;
> .
> .
> .
>
> return rs ;
>
> } catch (SQLException e) {
> .
> .
> .
> }
>
> Any idea ??
>
> Regards,
>
> Papo
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
