How to send multiple records to jdbc

[Former Member]

Hello,

This is RamNarender. I have done file to jdbc scenario.where we used Microsoft Access as backend. I am able to send only one record in a file.

I want to send mutiple records in file and get updated in MS Access.

I would be thankful i any body would provide the solution.

Regards,

S.Ram

[Former Member]

Here i am using MS Access not Oracle. I need to proceed in the way as u mentioned. This is the sample code.Can rewrite it for multiple records.

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

- <ns0:data_sender_mt xmlns:ns0="http://isg.com/xi/training/file2jdbc25">

<EMPNO>1218</EMPNO>

<EMPNAME>NARENDER</EMPNAME>

<EMPAGE>25</EMPAGE>

<FLAG>YES</FLAG>

</ns0:data_sender_mt>

Regards,

S.Ram

[bhavesh_kantilal]

Hi,

Sorry but this does not have the Statement / Access tag's .

Is your scenario working for a Single Insert? If yes, what is the datatype you created for the Receiver JDBC adapter?

Regards

Bhavesh

[Former Member]

Hi Ram ,

Please create structure in following format and set the occurance of access as 0.99

<StatementName2>

<dbTableName action="INSERT">

<table>realDbTableName</table>

<access>

<EMPNO>val1</EMPNO>

<EMPNAME>val2</EMPNAME>

<EMPAGE>val2</EMPAGE>

<FLAG>val2</FLAG>

</access>

</dbTableName>

</StatementName2>

Thanks ,

Suvarna

Pls award pts if you find the answer useful .

[bhavesh_kantilal]

Hi

Qutie simple.

For every Row that you want to be inserted into the Database, Create the ACCESS level tag or the STATEMENT level tag and the corresponding elements under either of these and the multiple insertions will happen.

Regards

Bhavesh

[Shabarish_Nair]

change the occurance of the target structure for JDBC receiver - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

Also ref: