Problem Using JSP with Microsoft Access db

Hi folks,

Greetings from Vancouver, Canada. I'm having a problem using jsp (tomcat and Eclipse) to pull int values from an Access database.

In MS-Access db:
My table is Conferences, and the columns are:
"ID" (int)
"CITY" (String)
"AIRPORT" (String)
"SEATS" (int)

My jsp code below connects fine to the MS-Access db. But it is only able to retrieve 2 columns back:
results.getString("CITY") and
results.getString("AIRPORT")

It can't retrieve a 3rd column

Also, I'm not able to use results.getInt("SEATS") or results.getString("SEATS"). It keeps saying no data found.

BTW, Can the resultset pull different datatypes? Can it retrieve a string column and then retrieve integers from another column?

I thought it could handle different datatypes.

My Code is below:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<html>
<head></head>
<body>
<%@ page import="java.sql.*" %>
<%Connection conn=null;
try{ Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:Conferences", "", "");}
catch (Exception exc) { out.println(exc.toString() + " "); }
Statement statement = conn.createStatement();
String s = "SELECT * FROM SingleItem";
Statement statement = conn.createStatement();%>

<font size="+2" face="arial"><b>Conference Registration</b></font>
<form action="confirm.jsp" method="post">
<table border=1 bgcolor="tan" width="100%" align="center">
<tr>
<td>Select One</td><td>City</td><td>Tickets Remaining</td></tr>
<tr>
<%
ResultSet results = statement.executeQuery("SELECT * FROM Conferences");
while (results.next()) {
if (results.getInt("SEATS") > 0) {%>

<td><input type="radio" name="show" value="<%= results.getInt("SEATS")%>"></td> //This line works
<% }
else { %>
<td> </td>
<% } %>
<td><%= results.getString("CITY") %></td>
<td><%= results.getString("AIRPORT")%></td>
<td><%= results.getInt("SEATS")%></td> // This line doesn't work, keep getting no data found below.
</tr>

<% } %>
</table>

<p>
<input type="submit" value="Confirm">
</form>
</body>
</html>

The error Code is:

java.sql.SQLException: No data found
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger(Unknown Source)
sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger(Unknown Source)
sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Unknown Source)
sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Unknown Source)
org.apache.jsp.conference_jsp._jspService(conference_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

Help! I'm really stuck! I've taken a 1st year college semester in Java so I have some knowledge of Java. Please post your suggestions or your improved code.

Peter