Re: [dbcp] Handling many different user accounts over time

2015-06-25 Thread Phil Steitz
On 6/18/15 8:17 AM, Oksana wrote: Cameron, Scott scott.cameron at sap.com writes: Interesting that this has not come up before. You are right that PerUserPoolDataSource does not bound the number of pools that can be created and SharedPoolDataSource does not bound the total combined size

Re: [dbcp] Handling many different user accounts over time

2015-06-18 Thread Oksana
Cameron, Scott scott.cameron at sap.com writes: Interesting that this has not come up before. You are right that PerUserPoolDataSource does not bound the number of pools that can be created and SharedPoolDataSource does not bound the total combined size of the keyed pool it maintains.

RE: [dbcp] Handling many different user accounts over time

2011-12-10 Thread Cameron, Scott
Interesting that this has not come up before. You are right that PerUserPoolDataSource does not bound the number of pools that can be created and SharedPoolDataSource does not bound the total combined size of the keyed pool it maintains. Please do open a JIRA requesting the capability.

Re: [dbcp] Handling many different user accounts over time

2011-12-09 Thread William Speirs
On Thu, Dec 8, 2011 at 7:41 PM, Cameron, Scott scott.came...@sap.com wrote: It seems like everything we want to customize to get the behavior we want is actually at the ObjectPool level.  So I was wondering why not expose deeper access to that?  It seems like it would provide a lot more

Re: [dbcp] Handling many different user accounts over time

2011-12-09 Thread Phil Steitz
On Wed, Dec 7, 2011 at 9:27 AM, Cameron, Scott scott.came...@sap.com wrote: Hi, I'm considering using either SharedPoolDataSource or PerUserPoolDataSource to do some connection pooling but I've noticed that there doesn't seem to be any way to configure an upper bound on the total number of

Re: [dbcp] Handling many different user accounts over time

2011-12-08 Thread William Speirs
On Wed, Dec 7, 2011 at 11:27 AM, Cameron, Scott scott.came...@sap.com wrote: Hi, I'm considering using either SharedPoolDataSource or PerUserPoolDataSource to do some connection pooling but I've noticed that there doesn't seem to be any way to configure an upper bound on the total number of

RE: [dbcp] Handling many different user accounts over time

2011-12-08 Thread Cameron, Scott
What do you mean, across all users? Do you have different connection strings (user/pass) for each person who connects to your database? It's a slightly mixed bag as the app is multi-tenanted. We have some connection strings used by nearly everybody for certain things. Some connection

RE: [dbcp] Handling many different user accounts over time

2011-12-08 Thread William Speirs
If you have specific ideas, open a JIRA ticket and we can look into it. Bill- On Dec 8, 2011 5:52 PM, Cameron, Scott scott.came...@sap.com wrote: What do you mean, across all users? Do you have different connection strings (user/pass) for each person who connects to your database? It's a

RE: [dbcp] Handling many different user accounts over time

2011-12-08 Thread Cameron, Scott
If you have specific ideas, open a JIRA ticket and we can look into it. It seems like everything we want to customize to get the behavior we want is actually at the ObjectPool level. So I was wondering why not expose deeper access to that? It seems like it would provide a lot more flexibility

[dbcp] Handling many different user accounts over time

2011-12-07 Thread Cameron, Scott
Hi, I'm considering using either SharedPoolDataSource or PerUserPoolDataSource to do some connection pooling but I've noticed that there doesn't seem to be any way to configure an upper bound on the total number of connections in the pool across all users. For example, say I have 5,000 named