Forum:

JDBC and Relational Databases

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

Ranch Hand

Posts: 84

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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>

Mark E Hansen

Ranch Hand

Posts: 650

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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?

Bear Bibeault

Sheriff

Posts: 67750

173

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Moved to the JDBC forum.

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Babu Singh

Ranch Hand

Posts: 84

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

Babu Singh

Ranch Hand

Posts: 84

posted 14 years ago