JDBC response generic message format

[sabyasachi_mohapatra3]

Hello experts

I have a proxy to JDBC scenario,In the Receiver end , i have to call 3 SQL statements.The Format is as follows

<Statement1>

Delete Query

</<Statement1>

<Statement2>

Insert Query

</Statement2>

<Statement3>

Stored Procedure

</Statement3>

I want a response in the stored procedure.So i have to make the inbound message type synchronous.Will i be getting the response for all the statements .What would be the exact generic format of the response message.Unless i know the response message type i will not be able to design the exact receiver message type.plz throw some light on this

[Former Member · Accepted solution]

<root>

<StatementName1>

<dbTableName action=u201DUPDATEu201D | u201CUPDATE_INSERTu201D>

</StatementName1>

<StatementName2>

<dbTableName action=u201DINSERTu201D>

</StatementName2>

<StatementName3>

<dbTableName action=u201DDELETEu201D>

</StatementName3>

<StatementName4>

<dbTableName action=u201DSELECTu201D>

</StatementName4>

<StatementName5>

<storedProcedureName action=u201D EXECUTEu201D>

</StatementName5>

</root>

________________________________________________________________________________________________

The response is put in a separate element <StatementName_response> for each statement element.

________________________________________________________________________________________________

like here in this root i am getting response for <StatementName5>

So response Structure would be like ....

<root_response>

<StatementName4_response>

<row>

row structure from select query

</row>

</StatementName4_response>

<StatementName5_response>

<row>

out element of stored procedure.

</row>

</StatementName5_response>

</root_response>

Hope this Helps.

Regards

Dragon.

[former_member200962]

What would be the exact generic format of the response message

There is no generic format for JDBC-response message.....the only thing that you have to take care is name of JDBC-response message type should be <JDBC-requestMTname>_response and each statement should be named like StatementName_response

If you have a SELECT statement then have the required number of rows (of the DB) as elements in your DT. Since you have Insert/ Delete statements, you will have element like insert_count , delete_count

Regards,

Abhishek.

[Former Member]

a

Edited by: KOMODO DRAGON on Jun 28, 2010 12:56 PM

[Former Member]

<root>

<StatementName1>

<dbTableName action=u201DUPDATEu201D | u201CUPDATE_INSERTu201D>

</StatementName1>

<StatementName2>

<dbTableName action=u201DINSERTu201D>

</StatementName2>

<StatementName3>

<dbTableName action=u201DDELETEu201D>

</StatementName3>

<StatementName4>

<dbTableName action=u201DSELECTu201D>

</StatementName4>

<StatementName5>

<storedProcedureName action=u201D EXECUTEu201D>

</StatementName5>

</root>

________________________________________________________________________________________________

The response is put in a separate element <StatementName_response> for each statement element.

________________________________________________________________________________________________

like here in this root i am getting response for <StatementName5>

So response Structure would be like ....

<root_response>

<StatementName4_response>

<row>

row structure from select query

</row>

</StatementName4_response>

<StatementName5_response>

<row>

out element of stored procedure.

</row>

</StatementName5_response>

</root_response>

Hope this Helps.

Regards

Dragon.

Edited by: KOMODO DRAGON on Jun 28, 2010 12:47 PM

[madhusudana_reddy2]

Hi Mahapatra,

By making your 3 statements in below structure as 0..1 occurance you can achieve this. But the Statement1_respose, Statement2_respose, Statement3_respose should be in proper format.

Delete Query

</<Statement1>

<Statement2>

Insert Query

</Statement2>

<Statement3>

Stored Procedure

</Statement3>

thanks,

madhu

[Former Member]

You can take some help from this web blog

/people/luis.melgar/blog/2008/05/13/synchronous-soap-to-jdbc--end-to-end-walkthrough

the structure should be in similar to what is explained in here

http://help.sap.com/saphelp_nw70/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Regards,

Srinivas