strongduanmu commented on issue #19304:
URL:
https://github.com/apache/shardingsphere/issues/19304#issuecomment-1186764256
I tested the following code and it load balances correctly.
```java
String sql1 = "INSERT INTO t_order(user_id, content, creation_date)
VALUES(11, 'test11', current_date);";
String sql2 = "update t_order SET content='test11' where user_id=11;";
String sql3 = "delete from t_order where user_id=11;";
Statement statement = getStatement();
setAutoCommit(false);
for (int i = 0; i < 50; i++) {
statement.executeUpdate(sql1);
statement.executeUpdate(sql2);
statement.executeUpdate(sql3);
}
commit();
sql1 ="INSERT INTO t_order(user_id, content, creation_date) VALUES(22,
'test22', current_date);";
sql2 = "update t_order SET content='test22' where user_id=22;";
sql3 = "delete from t_order where user_id=22;";
setAutoCommit(false);
for (int i = 0; i < 50; i++) {
statement.executeUpdate(sql1);
statement.executeUpdate(sql2);
statement.executeUpdate(sql3);
}
commit();
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
