JDBC receiver doeing combined INSERT

[Former Member]

Hello everybody,

looking for answer for a while, and cannot find it anywhere.

Is it possible to make JDBC receiver adapter issue INSERTs like this? If DB server allows off course.

INSERT (col1, col2) VALUES(val1, val2), (val1, val2), ...

This syntax is possible on some DBs and enhances performance.

-Adam.

[baskar_gopalakrishnan2 · Accepted solution]

JDBC reciever only handles creating your target jdbc structure. The final query is going to run only on db server. You can construct jdbc structure as below and try it out.  You can place sql string in the access tag as shown below. The jdbc adapter job is to construct query based on the structure and delegate to the database server.

Example:

<StatementName>  

<anyName action=”SQL_DML”>

<access>

INSERT (col1, col2) VALUES($placeholder1, $placeholder2), ($placeholder1, $placeholder2), ...

</access>

<key>

  <placeholder1>value1</placeholder1>

  <placeholder2>value2<placeholder2>

</key>

</anyName > 

</StatementName>

See whether that helps.

[iaki_vila]

Hi Adam,

In addition to Baskar answer, you have the doumentation here: http://help.sap.com/saphelp_nwpi71/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Regards.