Skip to Content
avatar image
Former Member

Connections are not closed on JDBC sender side for DB2

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 11, 2010 at 12:39 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11, 2010 at 12:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 11, 2010 at 12:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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