JDBC Receiver single insert statement and multiple rows

[Former Member]

Hi Folks,

In our szenario we have a single insert statement and multiple ACCESS tags then what happens is that the connection to the database is made only once. But the data is inserted row by row.

and so it is slow-moving.

Can anybody help me in this situation?

can we use a Run Operating System Command?

with best regards

Michael

[Former Member]

Thanks folks for your help!!!

best regards Michael

[Former Member]

Hi Michael !

Could you please clarify the scenario? can you use a stored procedure instead?

Regards,

Matias.

[Former Member]

Hi Matias,

at firdt thanks for your answer.

ur document look like this structure:

<StatementName2>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

<access>

<col1>val11</col1>

</access>

</dbTableName>

</StatementName2>

and the SQL Statement "Insert" is produce for each access node.

[Former Member]

Maybe you can insert them in a temporary table (less records and with less indexes/constraints) to speed up the process and then have a job that transfers those records to the final table.

Regards,

Matias.

[justin_santhanam]

Michael,

You can try something like this. Create a SQL string like

Insert into tablenname (field1,field2,...,fieldn) Values("1","1",...."1"),("2","2",...."2");

For the above logic u need to create structure like below

<Statement>

<anyName action=“SQL_DML”>

<access>SQL-String with optional placeholder(s)</access>

</anyName >

</Statement>

If you have any doubts do reply back.

raj.