Skip to Content
0
Former Member
Mar 02, 2007 at 06:43 AM

JDBC Adapter issues with ' Character

121 Views

HI Folks

I have 2 issues/questions

1. The database(Firebird) I am attempting to INSERT records to expects the format

INSERT INTO konp (KNUMH, KSCHL) values(0001094056, 'ZFPD')

but XI generates

INSERT INTO konp (KNUMH, KSCHL) values('0001094056', 'ZFPD')

THe difference is the inverted commas on the value of the first element

How can I remove these inverted commas?

2. I have added attribute logSQLStatement to the adapter, In the audit log I expect to see the entire SQL statement but only get INSERT INTO konp () VALUES ()

Is this normal? The payload looks fine, see below

<?xml version="1.0" encoding="UTF-8" ?>

- <ns0:FB_Konp xmlns:ns0="urn:distell:xi:roffice:enterpriseagent">

- <InsertStatement>

<konp action="INSERT" />

- <access>

<KNUMH>'0001094055'</KNUMH>

<KSCHL>ZFPD</KSCHL>

<STFKZ>A</STFKZ>

<KZBZG />

<KSTBM>0.000</KSTBM>

<KONMS />

<KSTBW>0.00</KSTBW>

<KONWS />

<KRECH>C</KRECH>

<KBETR>-1.00</KBETR>

<KONWA>ZAR</KONWA>

<KPEIN>1</KPEIN>

<KMEIN>CS</KMEIN>

<LOEVM_KO />

</access>

</InsertStatement>

</ns0:FB_Konp>

Thanks for any help received