nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Juan Pablo Gardella <gardellajuanpa...@gmail.com>
Subject Re: PutSQL and AutoCommit Mode Still Commits
Date Wed, 03 Jun 2020 20:29:32 GMT
Which driver?

On Wed, 3 Jun 2020 at 17:20, Shawn Weeks <sweeks@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 <sweeks@weeksconsulting.us>
> *Reply-To: *"users@nifi.apache.org" <users@nifi.apache.org>
> *Date: *Wednesday, June 3, 2020 at 2:27 PM
> *To: *"users@nifi.apache.org" <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
>
>
>
>
>

Mime
View raw message