Skip to main content
badman
Gold ⭐️
December 4, 2019
Solved

putSql exception

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 ?

DigitalPlumber
Gold ⭐️
December 4, 2019

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

2 replies

DigitalPlumber
Gold ⭐️
Gold ⭐️
December 4, 2019

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

Translate
badman
badmanAuthor
Gold ⭐️
December 4, 2019

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

Translate