Hi,
Is your Database MSAccess?
If yes then try Statement
s=cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
for a full blown Explain Explaination Please go through Java Docs.
HTH
Best Regards
Moin.
Enrique Prados Valiente wrote:
> Hi!
> I'm using Tomcat and JSP but there are problem, my JSP don' work.....
> I have this code in my JSP
> (code.....)
> Statement
>s=cn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
>
> (more code........)
>
> if (!rs.isFirst()) rs.previous();
>
> %><tr>
> <td><%=rs.getString(1)%></td><%
>
> }
>
> (more code........)
>
> In begin of my JSP there is this code line <%@ page language="java"
>import="java.sql.*,java.io.*,java.util.*" %>
>
> but when I run the server and JSP, it appears this error
>
> [Microsoft][ODBC Driver Manager] Invalid cursor state
>
> I think that Jsp fails in this code line, <td><%=rs.getString(1)%></td><%
>
>
> Can anyone out there help me?
> Thanks in advance,
> Enrique.