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 {
      try {
      CallableStatement cs = oConn.prepareCall("{call MYSTOREDPROC(?)}");
      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:


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

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