This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Count() Invalid curser state" Watch "SQL Count() Invalid curser state" New topic
Author

SQL Count() Invalid curser state

John Martinson
Greenhorn

Joined: Jun 17, 2005
Posts: 22
Okay,
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] +"\');";
System.out.println(myStmt);
rs = stmt.executeQuery(myStmt);
rs.beforeFirst();
rs.next();
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
Greenhorn

Joined: Jun 17, 2005
Posts: 22


yeilds "true" so rs.next(); is not failing.
John Martinson
Greenhorn

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 ( rs.next() ) if a row exists before calling any methods on the ResultSet.
[ June 21, 2005: Message edited by: Jamie Robertson ]
 
Don't get me started about those stupid light bulbs.
 
subject: SQL Count() Invalid curser state
 
Similar Threads
Closing ResultSet questions
how can i get column name of a table
Error executing Oracle function from JSP page
how do i delete multiple records
Problem in ResultSet