Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [connection-pooling]

In client applications, a connection pool is a cache of connections maintained so that the connections can be reused when future requests to the resource are required. Many DBMSes also support server-side connection-pooling allowing them to service more concurrent clients than they have server-side processes or threads servicing them.

15 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2 votes
0 answers
1k views

Keeping MySql connections alive

I'm running a Windows service, which connects to a MySql database via Entity Framework. Every 10 seconds it issues a query to the database to see if any new records have been added. If it finds any, ...
Bob Tway's user avatar
  • 243
2 votes
1 answer
55 views

Database connections and related issues?

If my tomcat is configured to accept 100 incoming requests concurrently, how many connections should be present in DB connection pool ? In other words, if there a known optimal ratio of number of ...
JavaDeveloper's user avatar
2 votes
0 answers
286 views

Connection Pools and TempDB Internal Objects

I am thinking I know the basics of the problem here, but I want to make sure I know the details before trying to explain it to others. We recently upgraded our third party application software to a ...
Dave.Gugg's user avatar
  • 304
1 vote
0 answers
459 views

how to maximize usage of number of databases on a postgres server while limited by connections

We're building a system where ideally we'd give a database per client in a multi-tenant setup. However, although a single Postgres install supports 4,294,950,911 databases on a server, the suggested ...
pyramation's user avatar
1 vote
0 answers
139 views

concurrent configuration PostgreSQL and tomcat

Postgresql has a default of 100 regarding max_connections. Tomcat pooling has a default of 100 regarding maxActive and maxIdle. How about configuring data sources in context.xml for Apps in Tomcat? ...
Gunnar's user avatar
  • 121
1 vote
0 answers
10k views

org.postgresql.util.PSQLException: This connection has been closed. error for long running transactions

We are getting "org.postgresql.util.PSQLException: This connection has been closed." on one of our deployments for only long running transactions (more than a few minutes): Caused by: org.hibernate....
nilgun's user avatar
  • 111
1 vote
0 answers
2k views

Check Postgres Listener is up/down?

I am using PostgreSQL LISTEN/NOTIFY functionality in Java. So I have made a ListenerBean which is run at Application startup. LISTENER class in java: @Singleton @Startup ...
Siddharth Trikha's user avatar
0 votes
0 answers
19 views

Does Analysis Services provide connection pooling

We know that when creating a SQL connection, for example: using (SqlConnection sqlConn = new SqlConnection(conString)); we are actually not always creating a new connection to the server, but rather ...
PajLe's user avatar
  • 133
0 votes
1 answer
22 views

PostgreSQL: Database Layer Pooling v/s Application Layer pooling

I would like to have some recommendations about connection pooling in PostgreSQL. We already have connection pooling using Pgbouncer behind an Azure LB. The pgbouncer itself is working pretty much ...
mediocre's user avatar
  • 107
0 votes
1 answer
171 views

pooler error: query_wait_timeout in pgbouncer logs

I am getting pooler error: query_wait_timeout for different databases in the pgbouncer log 6 to 7 times a day . When the error occurs for masterdata database , it gives me a timeout in the ...
kumar ashish's user avatar
0 votes
1 answer
138 views

Estimating a max poolsize in azure postgres

In this article , I found the formula to get an estimate of the max poolsize value: connections < max(num_cores, parallel_io_limit) / (session_busy_ratio * avg_parallelism) now, ...
troubleddev's user avatar
0 votes
0 answers
1k views

The client was unable to reuse a session with SPID 720, which had been reset for connection pooling. The failure ID is 1

I have researched a lot and there is very little information especially when you see it with Failure ID = 1, which is default code. It suddenly started appearing on our PROD servers. Microsoft SQL ...
NewUser546's user avatar
0 votes
0 answers
54 views

SQL connections to java applications

I have an MSSQLServer2000 database that seems to have been working just fine until today. The DB connects to a java application on a remote server that passes the database data (login credentials, ...
mcv110's user avatar
  • 75
0 votes
0 answers
533 views

MySQL pooled connections and crontab jobs (not reusing connections)

I have several cron jobs running and the task that cron has to do is execute a file that in turn checks and compares crawled data with data in the database, if it exists then the script ends and if it ...
MartinJJ's user avatar
  • 101
0 votes
0 answers
32 views

Prevent Reconnections During Application Cluster Restart

I have a large cluster of application processes (>5000) spread out over multiple EC2 servers. When I attempt to restart them or deploy new code (with a restart), they all attempt to reconnect to the ...
silvamerica's user avatar