Skip to Content
0
Former Member
Nov 18, 2008 at 01:35 PM

JDBC Receiver Adapter - Stored Procedure - Error Illegal Parameter

39 Views

Hi experts,

I have a problem with the next scenario:

HTTP <-> XI -> JDBC

XI sends the following message to JDBC Adapter in mode Receiver to execute a Stored Procedure in a Informix database:

<ns0:mt_messageTestSP xmlns:ns0="urn:test">
  <statement>
    <hastus_exporta_dia action="execute">
      <fechaEnvio isInput="true" type="DATE">11/17/2008</fechaEnvio>
    </hastus_exporta_dia>
  </statement>
</ns0:mt_messageTestSP>

Note: The format that accepts the SP Informix in the field of type date is: MM/dd/yyyy

The SP is running on an Informix database, and the parameter (fechaEnvio) that receive the SP is of type DATE. At runtime the SP does not run, and in the Component Monitoring of the Runtime Workbench I see the following error:

Unable to execute statement for table or stored procedure. 'hastus_exporta_dia' (Structure 'statement') due to java.lang.IllegalArgumentException

Any idea?

Thanks,

Jose.