Problem in inbound JDBC Adapter

[Former Member]

My scenario is like sending data from SAP to database through JDBC adapter.

but when i tried to excute my program it is giving follwing message:

Error processing request in sax parser: Error when executing statement for table/stored proc. java.sql.SQLException: ORA-00001: unique constraint (STSC.UDT_PRICELOCZONE_CPK) violated

i am sure there is no duplicate records.

can anyone tell me what the problem?

[Former Member · Accepted solution]

Check whether your XML has the values in key fields ? May be your map did not pass the values.

regards

Shravan

[Former Member · Accepted solution]

Thanks Shravan.

We are apssing duplicate records. system checking unique primary key and throughing hte error.

[udo_martens]

Hi Suresh,

that message is defintly from your database. Try to execute your stored procedure in debug mode with just the same parameters as in your XML message.

Regards,

Udo