Connections are not closed on JDBC sender side for DB2

[Former Member]

Hi,

I am sending data from Oracle database to SAP..But Connection are continuously opened while using JDBC Sender Adapter with

DB2. Even after message processign the connections are not closed.Kindly help me.

Thanks

Ravi

[Former Member · Accepted solution]

Hi,

Goto sender JDBC channel-> select advanced mode-> chk disconnect from database after processing each message..

This will make the channel to fetch data from DB and disable the connection and will connect again to fetch next data..

Regds,

Pinangshuk.

[MichalKrawczyk]

Hi,

did you select : Disconnect from Database After Processing Each Message

as per:

http://help.sap.com/saphelp_nw04/helpdata/EN/7e/5df96381ec72468a00815dd80f8b63/content.htm

Regards,

Michal Krawczyk

[Former Member]

Hi Michal,

I have select same parameter(Disconnect from Database After Processing Each Message)

in Jdbc Advanced mode.Still the DB2 connections are active.

Thanks

Ravi

[Shabarish_Nair]

use the option as mentioned in the help

If you want the database connection to be released and reestablished before each Poll Interval, select Disconnect from Database After Processing Each Message.

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