Skip to Content
0
Former Member
Jan 15, 2007 at 02:25 PM

JDBC connect for writing - missing comma

51 Views

Hello,

I try to write to a table on an Oracle DB.

This is my request:

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

- http://www.zeiss.org/excel">

- <STATEMENT>

- <TABLENAME ACTION="INSERT">

<TABLE>IRIS.T_GARANTIE_FALL</TABLE>

- <ACCESS>

<FALL_NR>1</FALL_NR>

<MASCHINEN_NR>12</MASCHINEN_NR>

<CALL_ID>123</CALL_ID>

<IDENT_NR>e</IDENT_NR>

<DAT_ESKALATION>12.01.07</DAT_ESKALATION>

<DAT_SAT>12.01.07</DAT_SAT>

<DAT_END_GARANTIE>12.01.07</DAT_END_GARANTIE>

<PULS_NR>126</PULS_NR>

<AUSFALLGRUND>m</AUSFALLGRUND>

<ST_MDRV_MDRV_ID>4</ST_MDRV_MDRV_ID>

<DAT_SWAP_ENTSCHEIDUNG>12.01.07</DAT_SWAP_ENTSCHEIDUNG>

<BEMERKUNG>s</BEMERKUNG>

</ACCESS>

</TABLENAME>

</STATEMENT>

</ns0:MT_JDBC_WRITE_GARANTIEFALL>

Simple and nice! But in comm.channel monitoring I have this error message:

Eroor when parsing or executing XML-SQL-Document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'IRIS.T_GARANTIE_FALL' (structure 'STATEMENT'): java.sql.SQLException: ORA-00917: missing comma

Whats going on with this comma?

Regards

Dirk