I get Error Too many connections when there to much items in a loop with INSERT IGNORE INTO. function insertCases(cases) { for(var i in cases) { var thequery = 'INSERT IGNORE INTO `cases` SET ke...

Here is exception I am getting This is the configuration I am using in my c3p0 <property name="acquireIncrement">5</property> <property name="preferredTestQuery">SELECT 1<...

I see the following error message: HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@f162126 (This connection has been closed.). Possibly consider using a shorter maxLi...

As I understand in Golang: the DB handle is meant to be long-lived and shared between many goroutines. But when I using Golang with AWS lambda, it's a very different story since lambdas are stopp...

I am using Poetry version 1.1.7. Running poetry install yields this error. Can this be resolved through bash or is this explicitly to do with my network? Note: Internet connectivity it perfectly fi...

I use HikariConfig as DataSource of postgres database on spring server. Should I set up maxPoolSize? (default value is -1) How much pool size can i use? Are there any dependencies with hardware?

At one site I can connect to the Oracle Database with SQL Developer, leave it idle for a long time (e.g., > 60 minutes), and return, and it's fine. At a second site, if it stays idle for more than ...

I'm using the node-mongodb-native driver with MongoDB to write a website. I have some questions about how to manage connections: Is it enough using only one MongoDB connection for all requests? ...

I am trying to use async await with mysql2 and pooling but I think I doing things wrong. Below is my code (as I said, I am not really sure if I am doing things right here). const pool = mysql.crea...

I have a Spring boot app that use HikariCP for Postgres connection pooling. Recently I've set up tracing to collect some data how time is spent when handling a request to a specific endpoint. My as...

Just wondering if RestTemplate out of the box uses connection pooling or does it simply establish a new connection each time ?

We know lambdas are charged by the execution time. So now I want to connect to SQL Server DB from lambda. If I create a connection in each lambda, it would be heavy for lambda. Is there any best w...

What I'm trying to do is to update my database after a period of time. So I'm using java scheduler and connection pooling. I don't know why but my code only working once. It will print: init succe...

I can't seem to figure out how the get the result outside of a NodeJS MySQL Pool query. Here is some sample code to better explain what I mean. var result = 'Hello world!'; var mysql = require('m...

I have implemented a very simple ConnectionPool in Java. It has no fancy features, just get/release connection methods. How can I test it is working? I know there are plenty of connection Pools r...

What's the correct way of reusing Python Requests connections in Django across multiple HTTP requests. That's what I'm doing currently: import requests def do_request(data): return requests.get(...

I have developed some custom DAO-like classes to meet some very specialized requirements for my project that is a server-side process that does not run inside any kind of framework. The solution ...

I am planning to use MYSQL. Is there a connection pooling extension available? Or what is the normal practice for connection? Is this the one used in every where... mysqli_connect("localhos...

I'm not sure if this is possible, but I'm looking for a way to reconnect to mysql database when the connection is lost. All the connections are held in a gevent queue but that shouldn't matter I th...

I'm using tomcat connection pool org.apache.tomcat.jdbc.pool.DataSource. The connections appear in my database pg_stat_activity with empty application_name. How could I set that application name i...

Is it possible to cache database connections when using PHP like you would in a J2EE container? If so, how?

I'm trying to use HikariCP in postgresql and I can't find anywhere the configuration for postgresql. Please point me to any example for postgresql with HikariCP or any configurations tutorial for...

I'm struggling to register DI NpgsqlConnection() with multiple connection strings in ASP.NET Core 3.1, Dapper v2.0.78 & Postgres v11. I will provide the current state & fix the code below: ...

Given a PostgreSQL database that is reasonably configured for its intended load what factors would contribute to selecting an external/middleware connection pool (i.e. pgBouncer, pgPool) vs a clien...

We are new to Google Cloud SQL and have been trying to integrate pgbouncer with Google Cloud SQl Postgres and authenticate database users with SECURITY DEFINER function (which queries pg_shadow) Ou...