- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
putSql exception
- Labels:
-
Apache NiFi
Created on
12-04-2019
03:17 AM
- last edited on
12-04-2019
04:02 AM
by
VidyaSargur
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I tried to insert some data in postgresql db using PUTSQL processor.
Below example of sql statement in putSql properties:
INSERT INTO myTable(date_response, success, code, payload_response) values ('${now()}', '${status:toNumber()}', '${code:toNumber()}', ${payload});
The problem is when this insert is executed, i have this error:
org.postgresql.util.PSQLException: ERROR: column "zxlbavuzvmlvm2x6vedsemrdstzjrnnnzxlbavuzvmlvm2x6swpvz2v5qwlhv1f" does not exist.
What happen ? .... the payload_response column name is replace by the value of my flow file attribute ${payload}. Why ? any hints ?
Created 12-04-2019 07:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm on mobile but could it be that you are not wrapping it around the single quotes?
Created 12-04-2019 07:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm on mobile but could it be that you are not wrapping it around the single quotes?
Created 12-04-2019 07:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks, i forgot simple quote .. i'm stupid
