Perhaps I read too much into the description of "The tomcat JDBC
Connection Pool" page?
TheJDBC Connection Pool|org.apache.tomcat.jdbc.pool|is a replacement or
an alternative to theApache Commons DBCP
<https://commons.apache.org/dbcp/>connection pool.
I reacted to the "replacement" bit. Are both equally sound, supported,
surviving? I try to use what I think is the safest longer term bet (my
retirement is nigh, it shouldn't take the code with it :) )
On 11/24/20 8:28 AM, Phil Steitz wrote:
On 11/24/20 8:14 AM, Rob Sargent wrote:
Thanks. I get it. But...
- seems this solution raises the footprint of the pooler, with
number-of-users * minimum-connection-count etc
- would it be beyond the pale for the pooler to maintain
username-connectionList maps?
Per response elsethread, see PerUserPoolDataSource [1] provided by
Commons DBCP. It does that.
Phil
[1] https://s.apache.org/dlghr <https://s.apache.org/dlghr>
Thankfully, I'll be wildly successful if I have two concurrent users
(a user may have hundreds of clients needing db connection)
(rant. The RDBMSs really should have a more lightweight way of
changing current user. (e.g. postgres set role doesn't cut it,
doesn't even invoke the users default search path))
Thanks again, I appreciate the feedback and knowledge sharing
On 11/24/20 6:28 AM, Christopher Schultz wrote:
Rob,
On 11/19/20 12:38, Rob Sargent wrote:
Since the connection URL names a specific postgres database is it
standard practice to have a pool per target database? (Switching
databases in postgres amounts to closing/opening a connection.)
I generally consider a database connection pool to be a connection
to a certain database/tablespace/schema, not a connection to an IP
address. That's the only thing that would make sense in terms of an
application, which would expect a connection to a specific data
store, right?
If you are closing connections (and reopening them), the pool isn't
dong its job.
I would recommend a separate pool per database/tablespace/schema.
-chris
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
