Skip to Content
0
Jan 28, 2009 at 12:06 PM

Problems with JDBC receiver

35 Views

Hi.

After checking some threads i think my jdbc data type structure is well defined.

This is the structure i have defined to insert a record in a table called EMPLEADO.

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

http://dga.es/SIRHGA/ARP/EDU">

<STATEMENT>

<EMPLEADO action="INSERT">

<table>EMPLEADO</table>

<access>

<NSS_EMPL>888665555</NSS_EMPL>

<NOMBR>pepeillo</NOMBR>

<APELL_S>lopez lopez</APELL_S>

<FECH_NACIM>1927-11-10 00:00:00.0</FECH_NACIM>

<DIRECC>aqui</DIRECC>

<SEXO>M</SEXO>

<SALAR>1000</SALAR>

<NSS_JEFE>12345</NSS_JEFE>

<ID_DEPART>Centr</ID_DEPART>

<NIF>00000000T</NIF>

<FECH_ALTA>1927-11-10 00:00:00.0</FECH_ALTA>

</access>

</EMPLEADO>

</STATEMENT>

</ns1:MT_SIRHGA_ARP_EDU_EMPLEADO>

Problem is that in runtime workbench, JDBC sender comm channel i get this error :

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'EMPLEADO' (structure 'STATEMENT'): java.sql.SQLException: ORA-01861: literal does not match format string

Can anybody tell me if my structre is OK ?

Kind regards,

Inigo.