SQLException

Thu, 03 Sep 2009 15:56:34 -0700

Hi,
I am trying to view all records in a Database through an html page called via a servlet. However the page returns the first row(record) only. I keep getting the following error in Apache Tomcat console window:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Invalid Descriptor Index

below is a code snippet from my servlet

Statement myStatement = databaseConnection.createStatement();  ResultSet results = myStatement.executeQuery("SELECT * FROM Classmates");

out.println("<TABLE BORDER=2, HSPACE=7>");
out.println("<TH>Name<TH>Address<TH>Town<TH>County<
;TH>Telephone<TH>");
while (results.next())
{
out.println("<TR>");
out.println("<TD>" + results.getString(1) + "</TD>");
out.println("<TD>" + results.getString(2) + "</TD>");
out.println("<TD>" + results.getString(3) + "</TD>");
out.println("<TD>" + results.getString(4) + "</TD>");
out.println("<TD>" + results.getString(5) + "</TD>");
out.println("<TD>" + results.getString(6) + "</TD>");
out.println("</TR>");
}
results.close();
out.println("</TABLE>");
out.println("</BODY></HTML>");

How can i fix this error?

'SQLException' Thread RSS Feed

SQLException