https://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html#download-jdbc-driver
https://s3.amazonaws.com/redshift-downloads/drivers/jdbc/1.2.43.1067/RedshiftJDBC42-no-awssdk-1.2.43.1067.jar Thanks From: Juan Pablo Gardella <gardellajuanpa...@gmail.com> Reply-To: "users@nifi.apache.org" <users@nifi.apache.org> Date: Wednesday, June 3, 2020 at 3:29 PM To: "users@nifi.apache.org" <users@nifi.apache.org> Subject: Re: PutSQL and AutoCommit Mode Still Commits Which driver? On Wed, 3 Jun 2020 at 17:20, Shawn Weeks <swe...@weeksconsulting.us<mailto:swe...@weeksconsulting.us>> wrote: Per the JDBC Spec calling commit() on a connection in auto-commit should raise a SQLException so what we’re doing is out of spec. https://docs.oracle.com/javase/7/docs/api/java/sql/Connection.html#commit() We should probably check c.getProperty(AUTO_COMMIT).asBoolean() and only call commit if we weren’t in auto commit mode. I’ll file a jira Thanks Shawn From: Shawn Weeks <swe...@weeksconsulting.us<mailto:swe...@weeksconsulting.us>> Reply-To: "users@nifi.apache.org<mailto:users@nifi.apache.org>" <users@nifi.apache.org<mailto:users@nifi.apache.org>> Date: Wednesday, June 3, 2020 at 2:27 PM To: "users@nifi.apache.org<mailto:users@nifi.apache.org>" <users@nifi.apache.org<mailto:users@nifi.apache.org>> Subject: PutSQL and AutoCommit Mode Still Commits It appears that PutSQL calls a commit even when set to autoCommit true mode. This breaks things if a driver raises an error on commit in autoCommit mode. For example redshift does this. Thanks Shawn
