7 Replies Latest reply on Jan 10, 2002 9:38 PM by David Jencks

    ResultSet - NotSerializableException ??? Please Help!

    Alan Newbie

      I am trying to call an EJB of mine from a servlet. My ejb method has the following code (JBOSS 2.4.3-Tomcat 3.2.3, Win2k, SqlServer2000):

      public ResultSet myMethod() throws RemoteException {
      this.setConnection();
      try {
      CallableStatement cs = oConn.prepareCall("{call MYSTOREDPROC(?)}");
      cs.setInt(1,1);
      ResultSet rs = cs.executeQuery();
      return rs;
      }
      catch(Exception e) {
      ...
      }
      }
      this code executes fine, with no exception. I can call this method fine with the following code:

      ejbMyBean.myMethod();

      BUT! when I call it with:

      rs = ejbMyBean.myMethod();

      I get the following exception from the Servlet:

      [Default] java.lang.reflect.UndeclaredThrowableException:
      [Default] java.io.NotSerializableException: sun.jdbc.odbc.JdbcOdbcResultSet
      [Default] <<no stack trace available>>
      [Default]

      I have no idea what this means! Any help is greatly appreciated.

      Thanks,
      Alan