cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC Adapter - Connection Pooling

Former Member
0 Kudos

Does anybody know if we can specify a Connection Pool to the JDBC Adapter? I mean the number of connections that the Adapter can have open to say Oracle Data.

Regards

Mike

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Michael,

Please take a look at this..

http://help.sap.com/saphelp_erp2005/helpdata/en/b0/6e62f30cbe9e44977c78dbdc7a6b27/frameset.htm

cheers,

Prashanth

P.S Please reward helpful answers

Former Member
0 Kudos

But do you know if the JDBC Adapter uses this service? I will look into it.

But this is a helpful answer though.

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Michael,

Some of the specifications that are given while configuring the JDBC adapter, especially regarding the number of connections that you acn have...is given clearly in this documentation for JDBC adapter:-

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

Specifically check for the following parameters :-

<i>db.transactionIsolation=0|1|2|4|8

db.autoCommit=NO|YES

db.pollInterval=

db.retryInterval=

db.logPollInterval=NO|YES</i>

Regards,

Sushumna

moorthy
Active Contributor
0 Kudos

HI,

As of now this is not supported by JDBC adapter.

But it was communicated that, it will be there . But not sure when

Regards,

Moorthy

Former Member
0 Kudos

I think the connection is always open. and there is one open connection per each Communication Channel you define.

Did you test this feature?

former_member8655
Active Participant
0 Kudos

Hi Michael

As per my knowledge there is no such option with JDBC adapter .And at one times your server can have only one connection

Regards

Mitesh