on 08-31-2007 5:45 PM
Dear Friends,
I've an issue with calling the Database synchronously. I used it before, but now its throwing some exceptions. It will be great helpful if someone help me out to solve this.
<b>
Request:</b>
<?xml version="1.0" encoding="utf-8" ?>
<ns2:MT_Test_SQL xmlns:ns2="urn:test">
<Statement>
<TABNAM Action="SQL_DML">
<Access><b>SELECT Query</b></Access>
</TABNAM>
</Statement>
</ns2:MT_Test_SQL>
<b>Response:</b>
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <!-- Call Adapter
-->
- <SAP:Error xmlns:SAP="http://sap.com/xi/XI/Message/30" xmlns:SOAP="http://schemas.xmlsoap.org/soap/envelope/" SOAP:mustUnderstand="1">
<SAP:Category>XIAdapterFramework</SAP:Category>
<SAP:Code area="MESSAGE">GENERAL</SAP:Code>
<SAP:P1 />
<SAP:P2 />
<SAP:P3 />
<SAP:P4 />
<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TABNAM' (structure 'Statement'): java.sql.SQLException: Cursor state not valid.</SAP:AdditionalText>
<SAP:ApplicationFaultMessage namespace="" />
<SAP:Stack />
<SAP:Retry>M</SAP:Retry>
</SAP:Error>
Thanks all for your valuable time!!
-raj.
Dear All,
Thanks. I solved it. The problem is in the Action attribute.
I've given as <TABNAM Action="SQL_DML">
But it has to be <TABNAM Action="SQL_QUERY"> , b'coz I'm seleccting the query.
-raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.