icon-arrow icon-check icon-mail icon-phone icon-facebook icon-linkedin icon-youtube icon-twitter icon-cheveron icon-download icon-instagram play close icon-arrow-uturn icon-calendar icon-clock icon-search
Werken bij Whitehorses
Blog 18/09/2014

SOA DbAdapter lingo: java.sql.SQLException: setObject, Exception = 8

Tiny technicians fixing a small error

Consultant
Laurens van der Starre /
Integratiespecialist

In the many years that I work with the Oracle SOA Suite and its Database Adapter, I never really had the pleasure of encountering the setObject errors.

Normally when you screw up the IN parameters in your call to the Database Adapter you’d get those java struct  “cannot convert STRING to NUMERIC” errors. However, the following message:

BINDING.JCA-11808
Set object error.
Error binding the value of parameter P_SOMEINPUT.
An error occurred when binding the value of parameter P_SOMEINPUT in the ABC.SOMEPACKAGE.INS API. Cause: java.sql.SQLException: setObject, Exception = 8
Check to ensure that the parameter is a valid IN or IN/OUT parameter of the API.  This exception is considered retriable, likely due to a communication failure.  To classify it as non-retriable instead add property nonRetriableErrorCodes with value "0" to your deployment descriptor (i.e. weblogic-ra.xml).  To auto retry a retriable fault set these composite.xml properties for this invoke: jca.retry.interval, jca.retry.count, and jca.retry.backoff.  All properties are integers.

is just the same, only more vague (and not really on Google).

You have to check your IN parameters. Get them from the audit trail als validate it against the XSD generated by the adapter. (Use for example this one).

Most probably there is some nill date or decimal element in your input.

Overzicht blogs

Geen reacties

Geef jouw mening

Reactie plaatsen

Reactie toevoegen

Jouw e-mailadres wordt niet openbaar gemaakt.

Geen HTML

  • Geen HTML toegestaan.
  • Regels en alinea's worden automatisch gesplitst.
  • Web- en e-mailadressen worden automatisch naar links omgezet.
Consultant
Laurens van der Starre /
Integratiespecialist

Wil je deel uitmaken van een groep gedreven en ambitieuze integratiespecialisten? Stuur ons jouw CV!