Problem when trying the Stored Procedures in JDBC receiver side

[chitti_prakash]

Hi,

I am facing some problem when i am trying to configure a scenario in the receiver side of JDBC adpater.

We have never got stored procedures to work as messages go in 'Delivering' status always. It's as if control never gets back to the adapter engine after the stored procedure call is made by the JDBC adapter. Then I went to checkt in the IE where the message has successfuly sent. Then I went to check

in AE where the message is in "Delivering" state for long time.

So checked the Default trace File and Thread dumps.

In Thread dumps, i found a strange thing like one thread is hanging on condition wait at the below location :

at java/lang/StringCoding.getEncoder(StringCoding.java:331(Compiled Code))

at java/lang/StringCoding.encode(StringCoding.java:472(Compiled Code))

at java/lang/String.getBytes(String.java:651(Compiled Code))

at com/sap/aii/adapter/jdbc/SAXHandler.constructResponseStream(xml2sql.java:841(Compiled Code))

at com/sap/aii/adapter/jdbc/SAXHandler.SQLcallStmt(xml2sql.java:988)

Can you please help me in solving this issue as it is very critical to me ?

Thanks,

Prakash.

[dharamveer_gaur2]

Hi

Check your Stored Procedure is working fine using SQL Editor.

Your Data Type Sturcrue is in Proper format required for Stored Procedure.

[JaganMohan]

Dear Prakash,

There are number of reasons for SAX error. May be structure is not well defined, statement is not written correctly. These following links help you to solve your issue.

Regards,

JP.