java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state

i am getting this error.

please check this some part of the code.

<%@ page language="java" import="java.lang.*" import="java.sql.*" import="java.io.*" import="java.net.*"%>
<%! ResultSet rs=null; %>
<%! Connection con=null; %>
<html>
<head>

<%

try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   con=DriverManager.getConnection("jdbc:odbc:dsource");
      System.out.println("First connection ok.");

System.out.println("Connection created***********");

Statement st=con.createStatement();
System.out.println("statement created...............");
String qr="select * from res";
System.out.println("Record select.............................");

rs=st.executeQuery(qr);
System.out.println("Query executed");
while(rs.next())
System.out.println("finding rs");
{
%><table bgcolor="#CFE7E7" border="1" align="center">
<tr  align="center">

<td width="150"height="30"><%
System.out.println("now dispalying..1");
System.out.println(rs.getString(1));
out.println(rs.getString(1));%>
<td width="150"height="30"><%
System.out.println("now dispalying...2");
out.println(rs.getString(2));%>
<td width="150"height="30"><%out.println(rs.getString(3));%>
<td width="150"height="30"><%out.println(rs.getString(4));%>
</tr>
</table>
<%
}
rs.close();
con.close();
}catch(Exception e){
System.out.println(e);
out.println(e);}
}

%>
</table>
</body>
</html>

Are you really placing your application logic in your JSP page? You really shouldn't do this. Place your application logic in a Servlet instead (in fact, place your application logic in utility classes which are called from your servlet). Then, just have the JSP page display the results. Read up on Model-View-Controller (MVC). This way, you can easily test your application logic without the need to actually execute the JSP.

As for your specific problem, it sounds like your connection doesn't like the fact that you're getting the result value more than once. Rather than calling rs.getString(1) multiple times, why not assign the value to a variable, then use that variable in the multiple places as necessary?

Moved to the JDBC forum.

i checked the code on simply notepad but same exception occurs.

i am finding java.sql.SQLException:[Microsoft][ODBC Driver Manager] Invalid cursor state.

please suggest.

command prompt result are:

please check the code

Its solved.

thanks.

Sheesh, I didn't even see that. I even saw that line printed twice and didn't catch it

Glad you got it resolved.

Now move your application logic out of your JSP and into a Servlet

thanks Mark for your advice.