The moose likes JDBC and Relational Databases and the fly likes SQL Count() Invalid curser state Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL Count() Invalid curser state" Watch "SQL Count() Invalid curser state" New topic

SQL Count() Invalid curser state

John Martinson

Joined: Jun 17, 2005
Posts: 22
I'm getting an Invalid cursir stat Error when I try to execute the following code.
myStmt = "Select COUNT(Closure) " +
" FROM moded" +
" WHERE " +
"(closure = \'OPEN\' AND " +
"[logged on] > #"+dBegin+"# AND " +
"[logged on] < #" +dEnd + "# AND " +
"field38 = \'" +catCount[i][0] +"\');";
rs = stmt.executeQuery(myStmt);
System.out.println(rs.getInt(1)); <------
Error occurs here, and I don't know why. Should the rs be 1 int?

Thank you in advance
John Martinson
Craig Jackson
Ranch Hand

Joined: Mar 19, 2002
Posts: 405
Could it be that the command:

returned "false", which basically means that your query did not find any matches?
John Martinson

Joined: Jun 17, 2005
Posts: 22

yeilds "true" so; is not failing.
John Martinson

Joined: Jun 17, 2005
Posts: 22
Problem resolved. No Idea what it was I just changed retyped my SQL statement to make it clearer to read and it worked. No idear what made it work but here's the code for those really demented people who might want to figure it out.

Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Old where clause: WHERE closure = \'OPEN\'
New where clause: WHERE closure = 'OPEN'

the old query could not find a row that matched closure = \'OPEN\', so as stated earlier rs.beforFirst() method would "bomb" out because no rows were returned. When you changed to closure = 'OPEN' it found a row, and everything worked as planned. you should always check (if ( ) if a row exists before calling any methods on the ResultSet.
[ June 21, 2005: Message edited by: Jamie Robertson ]
I agree. Here's the link:
subject: SQL Count() Invalid curser state
It's not a secret anymore!