when trying to call the next method on a result set generated by a select statement I get the exception:java.sql.SQLException: ResultSet not open. Verify that autocommit is OFF.
By default, a connection is in auto-commit mode. To set autocommit OFF, add localConnection.setAutoCommit(false); to your program, after you have created the connection, and before you have issued your query. thanks, bryan