In my application, I need to configure 2 databases during start up. They are created as Tomcat JDBC pools - org.apache.tomcat.jdbc.pool with seperate pool properties. If I configure such that both the database URLs, user name and password are same i.e., both point to the same database server, then how will be the connection pool created? Will it create 2 pools with different properties or only one? If its only one, which pool properties will be set to the pool - the one which is first created or the next? Also please suggest if there is any tool which can be used to see the connections to a database and the pools created on it?
Multiple connection pools on the same database
1k Views Asked by Saran At
1
There are 1 best solutions below
Related Questions in DATABASE-CONNECTION
- How can I fix Multer Gridfs Storage error "Error creating storage engine. At least one of url or db option must be provided"?
- How to connect MySql Database using SSH to Looker Studio?
- Often aborted connections to db (MariaDB)
- Code change works in local machine but not in staging server
- confusion in unix socket to use for query in postgresql through php
- Very slow connection to mariadb server
- Connecting to local database from Android studio emulator
- connection tab does not appear
- Simultaneous connections in an access database
- Connection leak causing java.sql.SQLNonTransientConnectionException
- Can't connect Windows 10 client to AWS Aurora MySQL database after major version upgrade 2 - 3
- java.sql.SQLException: Error opening connection OS=Linux AARCH64
- Invalid query: Syntax error: Expected keyword JOIN but got keyword DATE
- Node.Js: pg.pool server connection timeout
- Openshift - Impala Connection issue
Related Questions in CONNECTION-POOLING
- How to configure connection pool c3p0 hibernate most efficiently for remote connection mySql
- Failed to connect to docker container running Postgres via pgbouncer
- How to establish connection pooling for HTTP Requests Lambda function attached to AWS API gateway?
- morphia client always makes more than 1 connection
- context deadline exceeded (Client.Timeout exceeded while awaiting headers)
- How to know DriverManagerDataSource has a connection pool
- How to view connection pool activity within Snowflake re: Looker?
- Why does connection pooling not work with pyodbc in my Linux image?
- SQLAlchemy QueuePool Overflow Issue in FastAPI Application with Uvicorn
- r2dbc-pool: Using the r2dbc connection pool slows down the execution of parallel transactions
- Jboss default idletimeout minutes if not mentioned
- How to efficiently define connection pool for multiple data sources with single database per tenant, in spring boot
- How to notify to reset tcp connection from target
- How to export Connection pool metrics of Tomcat like NumActive, NumIdle, MaxTotal via JMX exporte?
- AWS RDS Proxy avoid pinned connection with mysql and prepared statements
Related Questions in JDBC-POOL
- Tomcat jdbc pool shows ClassNotFoundException but works
- Connection pool locked using Spring Dbcp2 pool
- An internal object pool swallowed an Exception org.apache.commons.dbcp2.LifetimeExceededException: The lifetime of the connection
- Getting typecast error while creating dbcp2.PoolableConnection with dbcp 2.9 version and Ojdbc8
- Instant data type change to String JsonArray Vertx
- Tomcat JDBC Connection Pool removeAbandoned not working
- Why my Tomcat 9 does not keep the jdbc connections open as it is specified in minIdle?
- Postgres connection pooling using java
- How are Datomic's long lived database Connections implemented for sql Connections?
- Tomcat Connection pool : tomcat-jdbc vs tomcat-dbcp, which is better?
- Apache felix cannot load dbcp2 as bundle
- JDBC connection pooling library which can handle connections that go idle often nicely?
- Database connections count greater than that set by DBCP maxTotal
- tomcat - ratio between HTTP Connector maxThreads / acceptCount and JDBC pool maxActive
- Connection leak with Tomcat 8 using dbcp2 & ojdbc6 Oracle driver
Related Questions in TOMCAT-JDBC
- Getting error, org.apache.tomcat.jdbc.pool.PooledConnection is not an interface when tried with Tomcat 9.0. and jdbc
- Chaos Monkey delay test causes tomcat-jdbc connection pool to have huge delay in getting connection
- Postgres connection stuck at idle even after serving 200 requests per second through a JDBC connection
- Confusion on Which Tomcat JDBC (tomcat-jdbc) Driver to Use
- Tomcat Jdbc v 8.5 failing with InterruptedException when testOnBorrow is true during Chaos Testing
- How to decide maxIdle properties in DB connection pooling configuration?
- Open or close the connection instantly after DB operation or use same connection throughout method
- How costly is opening and closing of a DB connection in Connection Pool?
- How to recover from abandoned connections?
- Dynamic resizing connection pool size - Apache Tomcat JDBC Connection Pool
- Why there are two options for database connection pooling with tomcat (tomcat-dbcp and tomcat-jdbc)?
- Spring Boot - Tomcat jdbc connection pool does not recover after database server is restarted
- JDBC Connection get lost after some idle time
- Tomcat database connection pool slow in high throughput
- Limit jdbc connection pool fixed amount
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
My guess is that they would create two separate pools. You can check the SQL server for the "active connections" which the pool should keep a few alive.
My suggestion though, is to use HikariCP as your connection pool. I've found it to be the most robust (survives even if the SQL server goes down) and the fastest (lightest, and smallest lib).