Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

an illigal cursor status.

 
Levien de Reu
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello

Can anyone give me al clue?
I want to execute a the following query on an MS access DB via jdbc-odbc bridge
Class.forName(DRIVER);
Connection con = DriverManager.getConnection(URL);
Statement st = con.createStatement();
con.setAutoCommit(true);
ResultSet rs = st.executeQuery("SELECT MAX(persId) FROM Persoon");
System.out.println(rs.getInt("persId"));

I would like it to return the max value of the int persId.
But i get an 'Illigal cursor status' (SQLException id=43).
I'm working with tomcat 5.0 and eclipse.

I hope someone knows what i'm doing..............wrong.

thanks

Levien.
 
Dirk Schreckmann
Sheriff
Posts: 7023
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Welcome to JavaRanch, Levien de Reu!

I'm moving this to the JDBC forum...
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34422
347
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Levien,
Since you are using an aggregate function (max), the column name is not defined. You have two choices:

1) Use a column number:

2) Give the column a name:


Also make sure you are calling rs.next() before accessing the column. Otherwise, the cursor is pointing to a position before that of the result.
 
Levien de Reu
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jeanne,

Many Thanx, it works !
Except the get method, i used a getInt.
But i assume that was what you ment.




bye
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34422
347
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, I meant getInt(). Glad to hear you have it working.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic