Re: PutSQL - BatchUpdateException: invalid arguments in call

2022-08-17 Thread Matt Burgess
Sergio, Your email says the flowfiles each contain a record to insert, but PutSQL takes a full SQL statement such as INSERT INTO tableName VALUES ('hello', 'world', 1). If you have a record of data rather than a SQL statement, you can use PutDatabaseRecord for that instead. If you do have SQL stat

Re: PutSQL - BatchUpdateException: invalid arguments in call

2022-08-17 Thread Breno Cesar
Hi Sergio, I'm not a nifi dev , but for my experience with mysql , it seems that you have some problem writing multiple operations in single transaction in the database. Looking in the mysql documentation i didn't find any configuration that limit the number of operations by transactions, so we hav