import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class bug72331 { public static final String URL = "jdbc:mysql://127.0.0.1:13000/information_schema?useCursorFetch=true"; public static final String USER = "root"; public static final String PASS = ""; public static final String STATEMENT = "select MAX_STATEMENT_TIME=1 1 from tables t join tables tt where t.engine='myisam';"; public static void main(String[] args) { try { Connection conn = DriverManager.getConnection(URL, USER, PASS); PreparedStatement pstmt = conn.prepareStatement(STATEMENT); pstmt.setFetchSize(100); //try { ResultSet rs = pstmt.executeQuery(); while (rs.next()) { System.out.println(rs.getInt(0)); } //} //catch (SQLException e) { //e.printStackTrace(); //} } catch (SQLException e) { e.printStackTrace(); } } }