jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Inconsistent Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Inconsistent "Invalid Cursor State" Error" Watch "Inconsistent "Invalid Cursor State" Error" New topic

Inconsistent "Invalid Cursor State" Error

kundi kx

Joined: Feb 03, 2003
Posts: 10
I am not wasting your time for a syntax error correction. I have run out of clues on this problem.
The error comes from within a bean method, when the method is called by a jsp search page within some specific search terms.
The bean method works fine with most of the search terms, displaying a number of matching record. (The search term is parsed to give the matching pattern of an sql - "... name like '<search term>%' ... ".) It works fine in most cases. But when I tried to match a 'G%', it failed and gave me "Invalid Cursor State" error _after_ outputing 5 matching records, halting on the 6th record. I have also tested my bean sql statement with this special 'G%' case within Pervasive SQL Executor with no error.

The above information is how far I get with my investigation. SQLWarning didn't give me anything. I am using Pervasive, through JDBC/ODBC. Also using Tomcat 4.1.18, jdk1.4.
The error is inconsistent in the sense that not all search term causes it. But it is very consistent to give error whenever I search by this G term, and also stop on the 6th record. And that 6th record seemed normal when I looked at it from Pervasive SQL console.

Someone please point at some rocks I could flip to find this bug.
I agree. Here's the link: http://aspose.com/file-tools
subject: Inconsistent "Invalid Cursor State" Error
It's not a secret anymore!