RE: PutSQL in combination with ConvertJSONToSQL gives java.sql.SQLException: Invalid column type for Orcale DataType BINARY_DOUBLE

Hello Matt, Thanks for the information. Disabling the quotes did the trick. Thanks Sven -Original Message- From: Matt Burgess Sent: Thursday, January 20, 2022 5:28 PM To: users@nifi.apache.org Subject: Re: PutSQL in combination with ConvertJSONToSQL gives java.sql.SQLException:

Re: PutSQL in combination with ConvertJSONToSQL gives java.sql.SQLException: Invalid column type for Orcale DataType BINARY_DOUBLE

Sven, This is a recently discovered bug, I am still working on characterizing the issue before writing a Jira to describe it. NIFI-9169 [1] has the same cause but is a slightly different issue. So far the issue seems to be with using update key(s) with "Quote Identifiers" set to true. Setting it

RE: PutSQL in combination with ConvertJSONToSQL gives java.sql.SQLException: Invalid column type for Orcale DataType BINARY_DOUBLE

Hi Mark, Thanks for the hint with the PutDatabaseRecord processor. I tried it. For INSERTS it works fine, but the UPDATE is failing with: “Routing to failure.: ORA-00936: missing expression”. When I enable DEBUG and force the processor to write out the SQL query (by setting Maximum Batch

Re: PutSQL in combination with ConvertJSONToSQL gives java.sql.SQLException: Invalid column type for Orcale DataType BINARY_DOUBLE

Hi Sven, That is interesting. Looking at the JDBC Types class, there is no BINARY_DOUBLE type - and no constant with a value of 101. So it appears to be a non-standard type. So the script that you have in place is certainly one alternative. It is worth noting, though, that ConvertJsonToSql