Skip to Content
author's profile photo Former Member
Former Member

JDBC Connection

Hi Friends,

When we are trying to post multiple messages many times, <b>Is the XI creates a new Connection object(to connect to database) everytime</b> we posted or it wll <b>reuse the same Connection object</b>?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 06:38 AM

    Naresh,

    Connection once established, is not created again and again.

    U can crreate the connection for once and forget. (if it is succesful)

    regards,

    Vishal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 06:58 AM

    Hi

    Connection is established once.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 21, 2007 at 08:15 AM

    But how the Connection object was retained by the XI?

    Add a comment
    10|10000 characters needed characters exceeded

    • This object handling is part of the connection pool on Java engine

      See SAP Note 831162

      section J2EE JDBC Connector and Connection Pooling

      Use option in the adatpter "Disconnect from Database After Processing Each Message"

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

      Regards,

      Prateek

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.