JDBC receiver: Values with quotes

[former_member296836]

Dear all,

I created an insert statement for JDBC receiver.

I used logSQLStatement in advanced adapter mode to see the SQL statement

He does it like

insert into xyz(col1,col2) values(abc,def)

but I need it like

insert into xyz(col1,col2) values('abc','def')

I tried the attribute hasQuot="YES" for the fields and also

the column line delimiter, but it doesn't seem to work.

What do I have to do to set the values in quotes?

Thanks

Chris

[Former Member · Accepted solution]

You can try with a Oracle StoredProcedure

[former_member296836 · Accepted solution]

What does this mean?

[Former Member · Accepted solution]

You can write an Oracle StoredProcedure with your custom "insert" statement, and call it from the JDBC receiver channel passing field value.

Take a look here for other informations:

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

http://download.oracle.com/javase/tutorial/jdbc/basics/sql.html

[former_member296836 · Accepted solution]

Dear all:

The solution was simple: The logStatement function does write the SQL statement wrong.

In database it was reached well formed.

Regards

Chris