logstash-plugins / logstash-input-jdbc

Logstash Plugin for JDBC Inputs
Apache License 2.0
449 stars 187 forks source link

Fix jdbc_fetch_size usage with postgresql #368

Closed bmax closed 4 years ago

bmax commented 4 years ago

Credit to @phillycheeze

Rebase of https://github.com/logstash-plugins/logstash-input-jdbc/pull/200

According to documentation (https://jdbc.postgresql.org/documentation/head/query.html) we need autocommit disabled. Work around is to create transaction and rollback always.

Will fix tests and get back to y'all.