Обсуждение: setFetchSize() and preferQueryMode incompatible?

Hello all,

I've been playing around a little with using preferQueryMode set to 
extendedForPrepared to avoid the multiple round trips to the server.   
The default setting is a significant performance impact if there is any 
meaningful network latency.     We were also attempting to setFetchSize 
and found these two settings will not work together in any of the 
42.2.1, 42.1.4 or 9.4.1202 jdbc client builds running against a 9.6.x 
version server.

Is this a bug or a "feature"?

Below is the sample code.  The fetch size will not be respected with the 
preferQueryMode property present.

Thank you for having a look.

-- Alan



public class Work {

     public static void main(String ... args) throws SQLException {

         // make obvious changes here....
         String url = "jdbc:postgresql://host:5432/db";
         String user = "user";
         String passwd = "pass";

         Properties props = new Properties();
         props.put("user", user);
         props.put("password", passwd);
         props.put("preferQueryMode", "extendedForPrepared");

         Connection conn = DriverManager.getConnection(url, props);
         conn.setAutoCommit(false);
         Statement st = conn.createStatement();
         st.setFetchSize(1024);
         ResultSet rs = st.executeQuery("select * from reallyBigTable");
         while (rs.next()) {
             rs.getObject(1);
         }
     }
}