Quotes missing in generated SQL-Query (from XML SQL) in Receiver Channel

[ThomasZwerg]

Hello,

I have a problem regarding an JDBC receiver channel.

Basically it works as the INSERT statement is generated from my XML SQL message.

But the INSERT statement is missing the quotes.

the generated SQL is similar to the following:

INSERT INTO  myDB.tableName (Code, Number, InternalID,data, readDate) 
VALUES (12, 56,  677, some text, 2016-08-18T11:08:50.358+02:00)

and there are obviously no quotes for the values.

What I'd expect is the following:

INSERT INTO  myDB.tableName (Code, Number, InternalID,data, readDate) 
VALUES ('12', '56',  '677', 'some text', '2016-08-18T11:08:50.358+02:00')

according to SAP Documentation Defining an INSERT Statement - Configuring the JDBC Adapter in the Integration Directory/PCK - SAP L...

Do you have any Ideas how to get the quotes in my generated SQL statement?

Thanks in advance!

[manoj_khavatkopp · Accepted solution]

Thomas,

Have you tried adding the attribute hasQUOT = YES to your field-names.

Br,

Manoj

[ThomasZwerg · Accepted solution]

Hi,

Thank you Manoj.

No, not yet. Do I need it for every single column or can I specify it for all columns of this query?

BR,

Thomas