Error Type Mismatch

[Kamlesh Ugale]

Hello
i m tring to retrive data From Stored Procedure Using Jsp
i hv Error : Type mismatch: cannot convert from ResultSet to CallableStatement

Code : In Jsp Page

<%

 DataBean db = new DataBean();  /*Create Connection Obj */
 		 String str="",color="",status="";
	 ResultSet rs=null;
    CallableStatement cstmt=null;
 		 int i=0,cnt=0;
 
 
 		 try
		 {
		   if(db.makeConnection())
		   {
 			 cstmt = db.prepareCall("{call  payment()}");
		    
			/* System.out.print("Name iS "+name);
 			  str="select name,rollno,course,coursefee,email,ledgerno from admission where coursefee in( ";
             str+= " select sum(installmentamount)  from transaction ts ,admission a ";
             str+= " where ts.ledgerno= a.ledgerno group by ts.ledgerno )";
			   */
			  rs = cstmt.executeQuery();
 		   }
 		  
		  
            //cstmt = db.prepareCall(str);
 		 
		  //  rs = cstmt.executeQuery();

         	//rs=db.executeSQL(str);
			 while(rs.next())
			 {
			   cnt++;
			   i++;
			   if(cnt%2==0)
			   { color="#CCCCCC"; }
			   else
			   { color="#999999"; }
			   
%>
<tr bgcolor="<%=color%>">
<td class="labelr"><%=i%></td>
<td class="labelr"><%=rs.getString("name")%></td>
<td class="labelr"><%=rs.getString("rollno")%></td>
<td class="labelr"><%=rs.getString("ledgerno")%></td>
<td class="labelr"><%=rs.getString("email")%></td>
<td class="labelr"><%=rs.getString("course")%></td>
<td class="labelr"><%=rs.getString("coursefee")%> </td>
<td class="labelr"> </td>
</tr>
<%
		}
			 rs.close();
		 
		 }
		 catch(Exception ex)
		 { System.out.println(ex); }  
 %>

[Jeanne Boyarsky]

Kamlesh,
Welcome to JavaRanch! I added [ code ] tags around the code to make it easier to read.

[Jeanne Boyarsky]

Which line in that code throws the error?

It would also be good to point that that best practices say not to have Java code in a JSP.