JDBC receiver adapter: using the same database-connection

[Former Member]

Hi all,

is there a possibility to use one database-connection for multiple sql-statements/calls of one JDBC receiver communication-channel?

There is a communication-channel option 'Disconnect from Database After Processing Each Message'. But it seems for me that it is only working for the JDBC sender-adapter and not for the JDBC receiver-adapter!

best regards,

Hannes

[Former Member]

Hi Hannes,

We can use same receiver communication channel for execution of multiple sql statements. I was not in need to disconnect from database after processing of each message. I have not faced any problem for execution of multiple statements.

Regards,

Kavita Laddha

[Former Member]

Hannes

<i>There is a communication-channel option 'Disconnect from Database After Processing Each Message'. But it seems for me that it is only working for the JDBC sender-adapter and not for the JDBC receiver-adapter!</i>

Disconnect from Database After Processing Each Message option is available for both the sender and the reciver JDBC adapter. We have to set this indicator only if the database connection is to be released and reestablished before every poll interval.

For further info. please see:

http://help.sap.com/saphelp_nw2004s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

---Satish

[bhavesh_kantilal]

Hi,

If you need to inssert multiple rows into a table using a JDBC adapter in one shot, then this is defintely possible.

In the Dataformat of your receiver JDBC adapter, just make the occurance of your STATEMENT to 0 to undbounded.

For every row to be inserted, you will have to create a STATEMENT tag and map the rest of the fields also. This way, you can use the RECEIEVER JDBC adapter for mutliple insertions using a single connection.

Likewise, multiple SQL statements can be executed by creating the corresponsing datatype.

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

<i>Disconnect from Database After Processing Each Message

Set this indicator if the database connection is to be released and reestablished before every poll interval.</i>

As it clearly tells , this option is used when the Database connects and reconnects for every polling interval. As you must know, RECEIVER JDBC adapter does not contain any polling interval, and so this option does not make any sense.

Regards,

Bhavesh