private void dropData() throws RetsServerException, SQLException { ConnectionHelper helper = RetsServer.createHelper(); Connection connection = null; Statement statement = null; try { connection = helper.getConnection(); statement = connection.createStatement(); statement.execute("delete from rets_property_res"); helper.commit(); } finally { if (statement != null) statement.close(); helper.close(LOG); } }