cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC-Response error

justin_santhanam
Active Contributor
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

justin_santhanam
Active Contributor
0 Kudos

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.