Insert 3 or 4 DB Tables in JDBC without using Stored Procedure?

[Former Member]

Hi

Is there any procedure for Inserting 3 or 4 Data base tables in JDBC with out Using Stored Procedure?

Thanks in Advance

[former_member529475 · Accepted solution]

Hi Chiru,

Check the following thread which discussed the same...

Cheers...

Vasu

<b>** REward POints if found useful **</b>

[Former Member · Accepted solution]

Hi guys

Thanks for u r reply.

But i want that without using Stored Procedure.

Thanks

[Former Member · Accepted solution]

Chiru,

There are different structures to be specified with or without stored procedures.

In case of SP, you have different structures like statement etc., in case of normal JDBC use table structure where u specify the table name and action related fields.

Be specific regarding your query.

[prateek · Accepted solution]

Yes. Whatever i suggested does not require the call of stored procedure.

Under separate "Statement" tags, perform separate Insert action for each table required

Regards,

Prateek

[Former Member]

Have you checked Vasudev reply?

Else go through this again. This was raj reply n works fine.

Please refer the target structure in the below url,

http://www.flickr.com/photo_zoom.gne?id=549186611&size=o

There a statement was given only once. In your case if you want to update 5 tables then right click on the statement node and click duplicate subtree for 5 times.

Please consider the above URL only if you are going to create SQL Query string using UDF. So please ignore if you don't want to do like that. Instead create the below structure

<StatementName2>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName2>

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

Cheers,

<b>*RAJ*

*REWARD POINTS IF FOUND USEFULL*</b>

[prateek]

For JDBC receiver, modify its structure to include multiple statement tags as shown below

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

Regards,

Prateek

[Former Member]

Chiru,

If i am not wrong, your requirement is to update two or more tables into JDBC.

Yes you can do it, with the mapping itself you can define the structure and can sequentially update the DB.

If you are comfortable with BPM, you can also specify multi mapping./