JDBC: MS SQL: Error: No ResultSet set was produced

[Former Member]

Hello everybody,

when sending a message from XI to <b>JDBC MS SQL</b>, we get the following error:

<SAP:AdditionalText>com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'db_crm_transfer' (structure 'Statement1'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]<b>No ResultSet set was produced.</</b>SAP:AdditionalText>

But, the inserts are OK?

Has anybody an idea what is wrong?

Thanks a lot, regards Mario

[bhavesh_kantilal]

Mario,

Are you using a Sender JDBC adapter? or a reciver JDBc adapter ? is it a synchrnous call? can yhou give more details?

Regards,

Bhavesh

[Former Member]

Hi Bhavesh,

JDBC receiving sync.

Regards Mario

[bhavesh_kantilal]

Mario,

Can you post the Request message you have created and the respons message. Maybe looking at that can help.

Regards,

Bhavesh

[Former Member]

Hi Bavesh,

<u>REQUEST</u>:

<?xml version="1.0" encoding="utf-8" ?>

- <ns3:MT_Aufruf_Insert_State_Tabelle xmlns:ns3="http://xyz.com/XI/_CRM_Ausgangsmail">

- <Statement1>

- <db_crm_transfer action="SQL_QUERY">

<access>insert into tb_eai_events_state values ($event_id$, $object_key$, $object_name$, $object_verb$, $state_time$, $state_value$, $state_class$, $state_number$, $state_comment$)</access>

- <key>

<object_key>'79187'</object_key>

<event_id>100066</event_id>

<object_name>'_CRM_AUSGANGSMAIL'</object_name>

<object_verb>'Create'</object_verb>

<state_time>'13/09/2006 11:59:55'</state_time>

<state_value>'S'</state_value>

<state_class>'ZC_NM'</state_class>

<state_number>'500'</state_number>

<state_comment>'Erfolgreich in CRM eingebucht'</state_comment>

</key>

</db_crm_transfer>

</Statement1>

</ns3:MT_Aufruf_Insert_State_Tabelle>

<u>RESPONSE: (not a real response! this is this ERROR</u>

- <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. 'db_crm_transfer' (structure 'Statement1'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.</SAP:AdditionalText>

<SAP:ApplicationFaultMessage namespace="" />

<SAP:Stack />

<SAP:Retry>M</SAP:Retry>

</SAP:Error>

Regards Mario

[bhavesh_kantilal]

Mario,

Havent tried this and am not sure, but I think when you use SQL_QUERY you cannot use JDBC adapter in a Synch fashion to get a response.

Let us know if you face succcess in this. Ir maybe a blog too.

If you do not face success, using Stored Procs or INSERT or SELECT might help.

Regards,

Bhavesh

[bhavesh_kantilal]

Mario,

Just noticed one thing.

ACTION = SQL_QUERY

<b>But you are doing a DML operation here . and so ACTION should be SQL_DML in your request message.</b>

Regards,

Bhavesh

[Former Member]

Mario,

Can you tell me what 'db_crm_transfer' means??

Thanks & Regards,

Jai Shankar.

[Former Member]

Hi Bhavesh,

we changed the insert:

- <Statement1>

- <dbTableName action="insert">

<table>tb_eai_events_state</table>

- <access>

<OBJECT_KEY>79187</OBJECT_KEY>

<EVENT_ID>100066</EVENT_ID>

<OBJECT_NAME>NOVOMIND_CRM_AUSGANGSMAIL</OBJECT_NAME>

<OBJECT_VERB>Create</OBJECT_VERB>

<STATE_VALUE />

<STATE_CLASS />

<STATE_NUMBER>0</STATE_NUMBER>

<STATE_COMMENT>Mapping-Fehler</STATE_COMMENT>

</access>

</dbTableName>

</Statement1>

Now it works!

Thanks for your help!

Regards Mario