Hi
I am using JSDK2.1, JDK1.3 and MS-Access in our project. The query is being
executed in a function and the resultset is passed to another function. The next
function displays the contents of the resultset. This strategy works fine for a
standalone program but when this logic is put in the servlet, SQLException is
thrown.
The error message is: Error code0 Message[Microsoft][ODBC Driver Manager]
Invalid cursor state.
The code layout is somewhat like this:
doGet()
{
ResultSet rs = null;
rs = stmt.executeQuery();
displayRecs( rs);
}
public void displayRecs( ResultSet rs )
{
while(rs.next()
{
/* Code for painting HTML page */
}
}
Please let me know where I am going wrong. This may be a very silly problem,
when I cannot figure out the problem. It runs in standalone mode but not in a
servlet.
Thanks in advance
Regards
Shivashis
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
