JDBC connection pool size

, ,
1

Hi,

What is the way to find out maximum number of pool size that can be specified for a JDBC connection?

Regards,
Shriraksha A N

2
  • Calculate how many concurrent connections you need.
  • Check if the number is reasonable for parallel processing (e.g. to many concurrent accesses may slow down or even lock, depending of the taken action and the isolation level).
  • Ask your DBA’s how many you get resp. what they think is reasonable.
3

Hi Shriraksha,

We can generally get the statistics of a JDBC adapters using the service
WMART\pub.art.connection:getConnectionStatistics and provide the input value as adapter service which do you want to monitor it. you can implement the logic for getting notification before reaches to maximum pool. if I am wrong can you suggest me

Regards,
Jeevan_mjk

4

Hi,

Thanks for the response…

Actually, I want to know what is the maximum value that can be specified for the property “Maximum Pool Size” in a JDBC connection or how to determine the upper limit value that can be given to this property.

For eg :- If we need 20 instances of a particular connection, then we will specify “Maximum Pool Size” as 20. If we want 50 instances, then we will specify it as 50. But what is the maximum value that can be specified. On what factors it can be determined?

Regards,
Shriraksha A N

5

Hi ,

If we need 20 instances of a particular connection , you have to specify the Maximum Pool size as “20”

Regards,
Jeevan_mjk

6

Hi Jeevan,

You have misunderstood my question. If I need 20 instances of a particular connection, then I will specify Maximum pool size as 20. That is not my question. My question is what is the upper limit that I can specify for this property in a JDBC connection? [For eg:- If I need 150 instances of a particular connection or some higher value, then I need to calculate what is the maximum limit that is allowed for this property before specifying as 150. So, I need to know what is the maximum value that is allowed for the property “Maximum Pool Size” for a JDBC connection. Is it depends on type of database that I am using and number of connection and schemas or any other factors?].

Regards,
Shriraksha A N

7

Please refer Integration Server AdminGuide document. In this PDF, look under the topic: “Configuring Server Resources.”

There are no benchmark values for setting these parameters.

Hope this information helps.

8

Hi Sriraksha,

Based on your requirement and the number of connections that the DB will allow. based on both the inputs you can specify the max pool size.

Dont stick to onething that its max is lets say “100” So I will set it to 100.

Based on your server load ( transaction volume) you can fine tune it.

Initially you can set it to 10 or 20, then if you keep on getting any error in logs like " unable to get a connection for JDBC… from connetion pool" then you can increase it.

But make sure that you cannot increase this value above the connections allowed by DB.

Hope this answers your query.

9

Hi Sreenath,

Thanks for your response… I just wanted to know whether there is any restriction from webMethods side on number of connections that we can specify? I got the answer for my question from your response. So, finally we can specify as many number of connections that the DB supports right?

Thanks and Regards,
Shriraksha A N

10

Yes. thats right.