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.
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.