I have posted this request couple of days and nobody has solved my problem yet. I am stuck with this problem
for almost a week.
So here is goes.......
I have an Applet-Servlet Communication which is done in JBuilder 7.0 using JDK 1.3
This is what Exactly what i am doing.
I am trying to reverse iterate through a resultset.
I am using JDBC-ODBC Bridge.
Before i had this Exception this is what i had before and it worked fine
I was doing the DB connection in
Servlet to collect the Image names and sending that object back
to the
Applet which displays the Image names in JLIST. After selecting the image name it goes back to the
Servlet to get the Image object and i was passing that object back to Applet to displays the tiff images.
But now what they want us to do is to use the XML to do the DB connection and get the Image names from DB and
display it in the Applet(jlisT GUI).
So from the ResultSet which contains the Image names i have to create a XML file and Display the image names.
This is what i am doing to create the XML file.
I am taking the ResultSet that i have in Servlet side. And from that i wrote this class which takes this resultset and creates the XML File.
XML file is created but it would not display the Image names in the Applet;
because after going through this class the ResultSet is at the end.
And i am using this resultSet again to display the image names in JLISt. But because it is at the end of the ResultSet I am getting this Exception.
===============================
java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY
===============================
Also i have tried this:
======================================================================
PreparedStatement pstmt = con.prepareStatement("SELECT * from...",
ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
======================================================================
ANd did not make any difference.
So upon conclusion of this messy request.
Any help is highly appreciated.
Thanks in advance.