SteNicholas commented on issue #10353:
URL:
https://github.com/apache/shardingsphere/issues/10353#issuecomment-842015178
> > @heysJava , the default behavior value of above three parameters are
`ResultSet.TYPE_FORWARD_ONLY`, `ResultSet.CONCUR_READ_ONLY`,
`ResultSet.HOLD_CURSORS_OVER_COMMIT`. Users could specific the value of the
parameters.
>
> @SteNicholas ,How do users specify these parameter values? When using the
qurey method of jdbcTemplate, connection.createStatement() will be used. This
method calls the createStatement() method in the ShardingSphereConnection
class, and it will be new ShardingSphereStatement(this); that is this way
> public ShardingSphereStatement(final ShardingSphereConnection connection) {
> this(connection, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY,
ResultSet.HOLD_CURSORS_OVER_COMMIT);
> }
> These parameter values are fixed. When users want to use this method,
they cannot pass custom parameter values. If you want to change this parameter
value, you need to change the source code of jdbcTemplate or the source code of
Shardingsphere. I feel that this method is very unfriendly. There is no other
way to avoid
--
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:
[email protected]
