File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Servlets and the fly likes applet-servlet - creating objects from resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Servlets
Bookmark "applet-servlet - creating objects from resultset" Watch "applet-servlet - creating objects from resultset" New topic

applet-servlet - creating objects from resultset

chelakkad ben
Ranch Hand

Joined: Feb 09, 2005
Posts: 62
Could somebody pl help me solve this problem ?

i am trying to send a vector of student objects from servlet to applet.I have a student class(student) for creating the student objects,add to a vector and then send the vector back to the applet.Now the query in the servlet returns a resultset having a number of records and about 50 fields(columns).I
need to loop through the resultset to create the object for each record.
Is there any method by which u can pass the first RECORD
in the resultset as a parameter of type RESULTSET to the class student constructor, to create the student object?
.tried this code....
rsDet = (ResultSet)cst.getObject(5);
Vector vS = new Vector();
vS.addElement( new student(rsDet) );
but got the error..
exception....Closed Resultset: next
java.sql.SQLException: Closed Resultset: next
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.check_error(
at server_frs.getSubDet(

The query returns three records....No error msg is thrown however when the first record is added to the vector. Only during the second loop, i think ,the error is thrown.
If a fn is used, then u need to send 50 variables for each record to create the object. I want to avoid that.
Any idea on how to send each record from the resultset to create the object?
Would appreciate any help
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

May I be so bold as to suggest that you try the javax.sql.rowset.CachedRowSet interface (instead of a "Vector"), since it is probably more appropriate to the situation you describe.

Of-course, you need to locate an implementation of the interface. Since it appears that you are using an Oracle database (although I could not ascertain the version), you may find an implementation through the following Web page:

Good Luck,
chelakkad ben
Ranch Hand

Joined: Feb 09, 2005
Posts: 62
Hello Avi
Thanks for the reply,Avi. CachedRowSet seems a good idea!! Afterall i can scoll throught the resultset in the client and display..It
is scrollable too.But will it work with IE 5 and above?
Ben Souther

Joined: Dec 11, 2004
Posts: 13410

If it's in an applet and you've made the needed libraries (jars) available it won't matter what browser it's in.

Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
I agree. Here's the link:
subject: applet-servlet - creating objects from resultset
It's not a secret anymore!