Subodh (Airbyte)
JdbcStreamingQueryConfiguration
. I see that all the implementations of the interface are doing this
@Override
public void accept(Connection connection, PreparedStatement preparedStatement) throws SQLException {
connection.setAutoCommit(false);
preparedStatement.setFetchSize(1000);
}
My question is why do we need to set the AutoCommit
as false if we are just using a SELECT query to fetch the data?user
05/10/2021, 6:07 PMuser
05/10/2021, 6:07 PMuser
05/10/2021, 6:08 PMuser
05/10/2021, 6:08 PMuser
05/10/2021, 6:08 PMPostgresStressTest
with the line removed and see what happens.