javax.servlet.ServletException: General error

[Maria Modeste]

I have an SQL statement that is returning a ResultSet and looping through rows in the database.

I've run the SQL in the database and it works perfectly, but when I run it on the browser, I am getting the following message:
javax.servlet.ServletException: General error


The code is as follows:
String sql = "SELECT patient.FName,patient.LName, patientClaim.claimNo, claim.claimNo, claim.submittedDate,"
+"claim.totalCost, claim.SOB_ID, claim.visitID, claimStatus.statusID, status.StatusName,"
+"employee.employeeID, SOB.claimType FROM SOB, status, employee, claim, patient, employeeClaim ,"
+"claimStatus, patientClaim WHERE patient.patientID = patientClaim.patientID AND claim.claimNo = patientClaim.claimNo"
+"AND claim.claimNo = employeeClaim.claimNo AND employeeClaim.employeeID = employee.employeeID AND"
+" patientClaim.claimNo = claimStatus.claimNo AND claim.claimNo = claimStatus.claimNo AND status.statusID = claimStatus.statusID AND"
+" SOB.SOB_ID = claim.SOB_ID AND status.StatusName='Pending' AND employeeClaim.employeeID =9;";


Statement stmt =con.createStatement();
ResultSet rs = stmt.executeQuery(sql);


%>

<table border = "1" align = "center">
<tr>
<th> Claim No </th>
<th> Submitted Date</th>
<th> Total Cost </th>
<th> Date of Symptoms</th>
<th> Claim Status</th>
<th> Patient Name</th>
</tr>
<%
while (rs.next())




out.println("<tr> <td>");

out.println("+rs.getInt("claimNo")+"</td>");

out.println("<td>"+rs.getDate("submittedDate") +"</td>");

out.println("<td>"+rs.getInt("totalCost") +"</td>");

out.println("<td>"+rs.getDate("dateOfSymptoms") +"</td>");

out.println("<td>"+rs.getString("statusName") +"</td>");

out.print("<td>"+rs.getString("FName")+ "</td></tr>");



%>


</table>

<% rs.close(); %>

If I change the line with the out.println("claimNo") I get an error message of invalid cursor state.

Can anyone kindly suggest a way out of this problem.
PS. I have run a simpler sql statement such as select * from claim and I got the same error message.

[Maria Modeste]

Does anyone out there know how to fix this?

[stdunbar]

I'm not sure how to fix it exactly but I can point out at least one issue:

 String sql = "SELECT patient.FName,patient.LName, patientClaim.claimNo,
claim.claimNo, claim.submittedDate,"

...

 out.println("+rs.getInt("claimNo")+"</td>");

Right away, which claimNo should JDBC get out of the ResultSet - you have patientClaim.claimNo and claim.claimNo? You may be better off using the integer version of the ResultSet get methods than the String version. For example, maybe you'd instead like something like:

...
out.println("+rs.getInt(3)+"</td>");
out.println("<td>"+rs.getDate(4) +"</td>");
...

though you can mix and match the integer versions and the string versions.