You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/09/30 01:49:59 UTC

[GitHub] [shardingsphere] TeslaCN commented on issue #21272: Wrong result return when I execute addBatch with Proxy adaptor and openGauss database

TeslaCN commented on issue #21272:
URL: https://github.com/apache/shardingsphere/issues/21272#issuecomment-1263011202

   I've test the openGauss JDBC Driver, it does return a result like the actual behavior in this issue.
   
   ```java
           Connection connection = DriverManager.getConnection("jdbc:opengauss://127.0.0.1:5433/postgres?loggerLevel=OFF", "omm", "Password@123");
           Statement statement = connection.createStatement();
           statement.executeUpdate("drop table if exists t_order");
           statement.executeUpdate(
                   "create table t_order (order_id bigint primary key, user_id bigint not null, order_time timestamp not null, order_value varchar not null)");
           PreparedStatement preparedStatement = connection.prepareStatement("insert into t_order (user_id, order_time, order_value, order_id) values (?, ?, ?, ?)");
           int rows = 10;
           for (int i = 0; i < rows; i++) {
               preparedStatement.setLong(1, i);
               preparedStatement.setTimestamp(2, new Timestamp(System.currentTimeMillis()));
               preparedStatement.setString(3, "");
               preparedStatement.setLong(4, ThreadLocalRandom.current().nextLong());
               preparedStatement.addBatch();
           }
           int[] result = preparedStatement.executeBatch();
           System.out.println(Arrays.toString(result));
           statement.executeUpdate("drop table t_order");
           preparedStatement.close();
           statement.close();
           connection.close();
   ```


-- 
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.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

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