JDBC oracle update problem

[Former Member]

Hi Experts I need your help, I have to do an update of a field in an Oracle database.

I select a row according to the criterion sent, I show them a picture:

ABAP update looks like:

UPDATE db

SET con01est = '3'

WHERE cons01fab  = '1005'

              cons01fec   = '3-sep-2015'

              cons03cpro = '300D003115'. 

My mapping is a follow:

and my CC:

thank for your time.

[Former Member]

thank Souvik, but i have a new problema, i think the problema is about date format.

MP: exception caught with cause com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'CONSU01' (structure 'Statement'): java.sql.SQLDataException: ORA-01861: literal does not match format string

[Former Member]

From this above log it is a bit difficult to predict the specific field. However, I can give you a brief overview. From the log it is well understood that there must be a field on the target side in PI which is defined as of type string, however in the SQL server on the target side, the same field is of different type.

In order to get a better view can you run XPI inspector for receiver channel and check the log for a better view (in case it is difficult to understand exactly which field it is).

Regards,

Souvik

[former_member182412]

Hi Samuel,

Check below blog.

Regards,

Praveen.

[Former Member]

thank Praveen.

regards,

Samuel.

[former_member183816]

We are waiting for remaining story. What happens after this configuration? Did it work? Did you get any error?

[Former Member]

sorry, the error is:

JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'CONSU01' (structure 'Statement'): java.sql.SQLException: FATAL ERROR document format in structure 'CONSU01': unexpected tag 'acces' found, 'access' expected

this is my first jdbc interface type.

[Former Member]

Hello Samuel,

The below marked structure in red should be "access" and not "acces".

Regards,

Souvik