Hey all,
I am using:
Database: MySQL 5.0
JDBC Driver: mysql-connector-java-5.0.8-bin.jar
Running this method, which I believe should return each row upon each iteration, but does not.
if(resultSet.next()) {
do {
Console.print("Webpage title: " + resultSet.getString("Title"));
}
while(resultSet.next());
When I run the query in my DB tool, 3 rows are retrieved as expected
When I run the code in java, just one row is retrieved.
Any ideas? Spent two evenings trying to figure this out but I'm stumped!
Thanks!
WM