Incompatible type for declaration. Can't convert int to java.sql.ResultSet.

[Maria Modeste]

I'm running an sql statement and using the ResultSet class in java, but I am having the following error message:

Incompatible type for declaration. Can't convert int to java.sql.ResultSet.
ResultSet rs=stmt.executeUpdate(sql);

I understand that executeUpdate does not return a resultset, it does return an int, but how can I modify my code to get it to work?

My code is as follows:
String sql = "SELECT patient.patientName, patientClaim.claimNo, claim.claimNo, claim.submittedDate,"+
"claim.totalCost, claim.SOB_ID, claim.visitID, claimStatus.statusID, status.StatusName,"+
"employee.employeeID, SOB.claimType FROM SOB INNER JOIN (status INNER JOIN "+
"((employee INNER JOIN ((claim INNER JOIN (patient INNER JOIN patientClaim ON"+
"patient.patientID = patientClaim.patientID) ON claim.claimNo = patientClaim.claimNo)"+
"INNER JOIN employeeClaim ON claim.claimNo = employeeClaim.claimNo) ON employee.employeeID"+
"= employeeClaim.employeeID) INNER JOIN claimStatus ON (patientClaim.claimNo = claimStatus.claimNo) AND (claim.claimNo" +
"= claimStatus.claimNo)) ON status.statusID = claimStatus.statusID) ON SOB.SOB_ID = claim.SOB_ID"+
"WHERE (((status.StatusName)='Pending') AND ((employee.employeeID)="request.getParameter("userID"));";


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

[consultoriajava]

Very easy Maria, as executeUpdate dosent returns a ResultSet but an int you should something like this:

int returnCode = stmt.executeUpdate(sql);

Answer provided by http://www.consultoriajava.com

[Maria Modeste]

The reason why I am not using an integer is because I cannot invoke a method on an int.

lower down in the code, I need to loop through the ResultSet and display the results such as while
rs.next(). If I declare rs of type int, I cannot loop through.

[consultoriajava]

If you want to launch a query you should use the method executeQuery() instead of executeUpdate()

Answer provided by http://www.consultoriajava.com

[Maria Modeste]

It's amazing, I used executeQuery( ) before and I still had the same error message. Now I am using it again and it seems to be working!

However, I am getting another error message when I loop through the ResultSet. The code goes as follows:
<%
while (rs.next())


out.println("<tr> <td>"+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("patientName")+ "</td></tr>");



%>

The error message is:

"[ODBC Driver Manager] Invalid cursor state"

[consultoriajava]

Your code seems to be ok (not great but should work).

It would be of help to see your previous code, the error you are receiving is usual when you try to do

rs.getString("...");

when you havent done yet

rs.next()

Answer provided by experts at http://www.consultoriajava.com