This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes SQL Exception: Invalid cursor 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 Exception: Invalid cursor state" Watch "SQL Exception: Invalid cursor state" New topic
Author

SQL Exception: Invalid cursor state

duplessis van aswegen
Greenhorn

Joined: Aug 01, 2011
Posts: 2
Hi guys, I'm coding a simple translation program that uses a SQL database to retrieve the words from both languages and then,
when you choose a word from the list, translate it to the corresponding word in the other language.

Here's the Error:

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state

And here's the code:



Any help would be appreciated.
Thanks.
duplessis van aswegen
Greenhorn

Joined: Aug 01, 2011
Posts: 2
nevermind guys I fixed it...
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 32481
    
214

Welcome to CodeRanch!

I assume you fixed it by adding rs.next(). If it was something else, please share so others can learn from your experience.


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
 
Have you checked out Aspose?
 
subject: SQL Exception: Invalid cursor state
 
It's not a secret anymore!