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.