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
we weren’t in auto commit mode. I’ll file a jira
Thanks
Shawn
From: Shawn Weeks
Reply-To: "users@nifi.apache.org"
Date: Wednesday, June 3, 2020 at 2:27 PM
To: "users@nifi.apache.org"
Subject: PutSQL and AutoCommit Mode Still Commits
It appears that PutSQL calls a com
> *Date: *Wednesday, June 3, 2020 at 2:27 PM
> *To: *"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
>
>
>
>
>
Wednesday, June 3, 2020 at 3:29 PM
To: "users@nifi.apache.org"
Subject: Re: PutSQL and AutoCommit Mode Still Commits
Which driver?
On Wed, 3 Jun 2020 at 17:20, Shawn Weeks
mailto:swe...@weeksconsulting.us>> wrote:
Per the JDBC Spec calling commit() on a connection in a
ache.org<mailto: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>"
mailto:users@nifi.apache.org>>
Subject: PutSQL and AutoCommit Mode Still Commits
It appears th