Closed corgy-w closed 2 months ago
- I have tested SQLServe using JDBC and it supports batch processing.
- AS for your ORM framework,you can do a simple test.
UPDATE users SET
tenant_id = ?,
phone = ?,
phone_cipher = ?,
email = ?,
email_cipher = ?,
ssn = ?,
ssn_cipher = ?,
is_deleted = 'N',
creator = 'seatunnel',
modifier = 'seatunnel',
gmt_created = ?,
gmt_modified = ?
WHERE tenant_id = ? AND id = ?;
UPDATE users SET
tenant_id = ?,
phone = ?,
phone_cipher = ?,
email = ?,
email_cipher = ?,
ssn = ?,
ssn_cipher = ?,
is_deleted = 'N',
creator = 'seatunnel',
modifier = 'seatunnel',
gmt_created = ?,
gmt_modified = ?
WHERE tenant_id = ? AND id = ?
I have tested update batch and it not support . shariding version :5.2.1. Example statement above
Error as follows
- I have tested SQLServe using JDBC and it supports batch processing.
- AS for your ORM framework,you can do a simple test.
UPDATE users SET tenant_id = ?, phone = ?, phone_cipher = ?, email = ?, email_cipher = ?, ssn = ?, ssn_cipher = ?, is_deleted = 'N', creator = 'seatunnel', modifier = 'seatunnel', gmt_created = ?, gmt_modified = ? WHERE tenant_id = ? AND id = ?; UPDATE users SET tenant_id = ?, phone = ?, phone_cipher = ?, email = ?, email_cipher = ?, ssn = ?, ssn_cipher = ?, is_deleted = 'N', creator = 'seatunnel', modifier = 'seatunnel', gmt_created = ?, gmt_modified = ? WHERE tenant_id = ? AND id = ?
I have tested update batch and it not support . shariding version :5.2.1. Example statement above
Error as follows
Does sharding support updatebatch now
ex: