JDBC Connection

[Former Member]

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>?

[Former Member]

But how the Connection object was retained by the XI?

[prateek]

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

[Former Member]

Hi

Connection is established once.

Thanks

[Former Member]

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