putSql exception

badman — Wed, 04 Dec 2019 12:02:34 GMT

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 ?

Re: putSql exception

DigitalPlumber — Wed, 04 Dec 2019 15:02:37 GMT

I'm on mobile but could it be that you are not wrapping it around the single quotes?

badman — Wed, 04 Dec 2019 15:20:49 GMT

thanks, i forgot simple quote .. i'm stupid