Result Set Empty Java. Also I noticed that it happens when you execute procedure or insert in the databse and you dont commit your transactions. JDBC returning empty result set.
As part of a program i am developing a query is executed i then get that ResultSet. FOR ME EVEN THOUGH RESULT SET IS EMPTY IT IS GOING INTO FIRST BLOCK AND PRINTING RESULT SET HAS GOT SOMETHING. SQLite ResultSet is empty.
JDBC returning empty result set.
While rsnext I am processing result set now else outprintlnreThis JDBC Java tutorial describes how to use JDBC API to create insert into update String. As part of a program i am developing a query is executed i then get that ResultSet. The result is always an empty resultset. Assuming you are working with a newly returned ResultSet whose cursor is pointing before the first row an easier way to check this is to just call isBeforeFirstThis avoids having to back-track if the data is to be read.