Java JDBC ignores setFetchSize?

by

Try turning auto-commit off:

// make sure autocommit is off
connection.setAutoCommit(false);

 st = connection.createStatement();
 st.setFetchSize(1000);
 System.out.println("start query ");
 rs = st.executeQuery(queryString);
 System.out.println("done query");

Reference

More Related Contents:

  1. Is it possible to specify the schema when connecting to postgres with JDBC?
  2. How to get a value from the last inserted row? [duplicate]
  3. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  4. What is the most recommended way to store time in PostgreSQL using Java?
  5. How to read all rows from huge table?
  6. Driver JDBC PostgreSQL with Android [duplicate]
  7. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  8. how to copy data from file to PostgreSQL using JDBC?
  9. Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
  10. Convert a Result Set from SQL Array to Array of Strings
  11. Postgres UUID JDBC not working
  12. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  13. Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern
  14. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  15. How to establish a connection pool in JDBC?
  16. JDBC Class.forName vs DriverManager.registerDriver
  17. what is @JoinColumn and how it is used in Hibernate
  18. Why does autoReconnect=true not seem to work?
  19. How does Class.forName() work?
  20. JDBC returning MySQLSyntaxError Exception with correct statement
  21. Adding jdbc driver to classpath
  22. JDBC SQLServerException: “This driver is not configured for integrated authentication.”
  23. ojdbc14.jar vs. ojdbc6.jar
  24. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  25. Connection cannot be cast to oracle.jdbc.OracleConnection
  26. NoClassDefFoundError sun/io/ByteToCharConverter with InterBase JDBC driver
  27. Why do we use a DataSource instead of a DriverManager?
  28. Do I need to close ‘PreparedStatement’? [closed]
  29. Database independence through JDBC in java
  30. java.sql.SQLException: No database selected – why?

Leave a Comment