Important Notice - Forums is archived
To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.
ResultSet Functions Problems
Hi friends,
I'm getting results from database like below but ResultSet function does not behave normal :)
for example I have table which contains authors. datas in it:
AuthorID AuthorName
1 Tom Robbins
2 John Fowles
3 Paul Auster
4 J.R.R Tolkein
I believe that I can get the all datas which are in table with using this
esultSet rs = stmt.executeQuery("SELECT * FROM authors");
I believe because in debug mod I can't find datas in rs - there are lots of things in rs :/
anyway,
after getting datas to rs, rs.next() is reading datas three by three in while loop (or sometime seven by seven if there is more datas then this example )
and
(first entering to loop) first output is "Paul Auster" which should be "Tom Robbins"
(second entering) bamm, output is "SQLException: After end of result set"
I think it is trying to read sixth data in rs, but why?
any suggestions???
thanks lot,
Regards..
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
// create a connection to the db
Connection conn = DriverManager.getConnection(
"jdbc:mysql://localhost/books", "root", "11111");
// get some results
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("SELECT * FROM authors");
rs.beforeFirst();
while (rs.next()) {
System.out.println( rs.getString("AuthorName") );
}
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
}