Member since
01-10-2019
3
Posts
1
Kudos Received
0
Solutions
01-10-2019
03:12 PM
Thanks Matt for pointing this out. Seems I had read the documentation too quickly : From executeSQL usage : sql.args.N.type Incoming FlowFiles are expected to be parametrized SQL statements. The type of each Parameter is specified as an integer that represents the JDBC Type of the parameter. sorry !
... View more
01-10-2019
02:19 PM
based on : Processor's code, line 714+ Am I'm right to suppose that the way this function works, will prevent any non numeric parameter to work ? This seems to be an error in the logic itself.
... View more
01-10-2019
02:19 PM
1 Kudo
Hi, I've created a parameterized SQL query in the ExecuteSQL processor, this processor is predecessed by an UpdateAttribute with those parameters: here is the part of the where clause that uses this parameter : AND (( ?sql.args.4.value IS NULL AND mm.docno IS NULL ) OR ( mm.docno = ?sql.args.4.value)) The issue is that I keep having this error message : "java.sql.SQLDataException: Value of the sql.args.4.type attribute is 'CHAR', which is not a valid JDBC numeral type" Any clues ?
... View more
Labels:
- Labels:
-
Apache NiFi