[GitHub] [shardingsphere] TeslaCN opened a new issue #10898: PostgreSQL Proxy doesn't support Portal

[GitBox <gi...@apache.org>]

TeslaCN opened a new issue #10898:
URL: https://github.com/apache/shardingsphere/issues/10898


   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   5.0.0-beta
   
   ### Expected behavior
   When using PostgreSQL JDBC driver, we can `setFetchSize(1)` and `setAutoCommit(false)`. The returned ResultSet will use cursor and we can fetch rows as we need.
   
   ### Actual behavior
   Even the client specify a named portal and fetch size, the Proxy will return all rows. 
   
   ### Example codes for reproduce this issue (such as a github link).
   ```java
   connection.setAutoCommit(false);
   // A select statement whose results are more than a row.
   try (PreparedStatement preparedStatement = connection.prepareStatement("SELECT ......")) { 
       preparedStatement.setFetchSize(1);
       // Set parameters
       try (ResultSet resultSet = preparedStatement.executeQuery()) {
           while (resultSet.next()) {
               System.out.println(resultSet.getInt("no_o_id"));
           }
       }
   }
   connection.rollback();
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] tristaZero closed issue #10898: PostgreSQL Proxy doesn't support Portal

[GitBox <gi...@apache.org>]

tristaZero closed issue #10898:
URL: https://github.com/apache/shardingsphere/issues/10898


   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org