Questions tagged [connection-pool]

108 questions
0
votes
0 answers

Need a clarification in com.squareup.okhttp3 connectionPool

I tried to switch my HTTPUrlConnection to OkHttp3 in my application, but ran into a few problems. I initiated the connectionPool(maxIdleConnections, evictionTime) once, which would start the server with 100 max idle connections and 20 second…
0
votes
1 answer

asyncpg Connection pool with aiohttp raise asyncpg.exceptions._base.InterfaceError: cannot perform operation: another operation is in progress

When I try to reproduce example with aiohttp from documentation I get the error: asyncpg.exceptions._base.InterfaceError: cannot perform operation: another operation is in progress Exception raises when app get GET request on any of added…
Andrey Topoleov
  • 1,591
  • 15
  • 20
0
votes
0 answers

Java Jee getting a Connection pool configured in context.xml

I'm making a webapp using JSP and MYSQL. I have set up a connection pool and used it in a Servlet, but I cannot access it. I had to create manually the "lib" folder inside WEB-INF to put the database connector and the META-INF folder to put the…
gabit
  • 23
  • 5
0
votes
0 answers

Wait for all connections to become idle in a connection pool (r2dbc pool)

I am currently working on integrating IAM DB authentication with my database. Details are as follows: Database: AWS RDS Postgres Database Mapping: Jooq Interface: R2DBC SPI We maintain a connection pool of 20 connections in our java application.…
0
votes
1 answer

What is the difference between pooling at Entity Framework vs SQL Server level?

I have a .NET 6 Web API that is hosted on server A. SQL Server is on server B. Both servers are in the same network. Each endpoint of the Web API makes use of the Entity Framework to query data from the database. I wanted to enable pooling at the…
0
votes
1 answer

How to test Connection Pooling in nodeJS using mogoDB Database?

How to test Connection Pooling in NodeJS using MongoDB Database?
0
votes
1 answer

Testing Connection pool in Tomcat

I have a JDBC connection pool setup in tomcat server. Code 1 takes more time than Code 2. My question is that if connection pool is working. Then it should parallelly open other connections and it should not be taking much time (as I have…
Vinayak
  • 43
  • 5
0
votes
0 answers

Active connections on Oracle from app hosted on Glassfish 3.1.2

We have 3 app servers behind load balancer and each app server is connected to Oracle database. We have setup connection pool of minimum 8 size and max 32 size. Everytime I query database to see active connections. I do not see more than 2 active…
0
votes
0 answers

Is it feasible to use database-per-tenant with 1000 tenants?

I would like to build a multi tenant Spring Boot application. I prefer persisting the data for every tenant in a separate database. This approach implies the usage of a data source (and a connection pool) for each tenant/database. In my scenario I…
Oliver
  • 353
  • 1
  • 4
  • 16
0
votes
0 answers

Spring boot, Tomcat connection pool when multiple spring boot applications are in same external tomcat container

Let's consider I have two Spring boot applications. And say each configures 50 max-active connections. Say that both are deployed to external Tomcat container and embedded Tomcat container is disabled in both. What will be the connection pool…
0
votes
0 answers

Why mysql_init(nullptr) leads to segmentation fault in the following code?

My code is as follow: main.cc int main(void){ int port, sqlPort, ConnectionNum, threadNum; string sqlUser, sqlPwd, DBName; try{ Config Settings("./config.ini"); Settings.Read("port",port); …
Phoenix Chao
  • 390
  • 3
  • 19
0
votes
0 answers

I have connectionpool class which is a singleton. when i try to call it in my DBDAO classes something go wrong and it create 2 instances

im writing a coupon system project and I have a problem with my connectionpool. I made it singleton and it should create 10 connections and print "Creating connection #num" 10 times when i call its instance for the first time. My DBDAO classes are…
Tal Levin
  • 1
  • 2
0
votes
1 answer

nodejs mysql - How to implement pooledConnection in a realworld project?

I am working on nodejs with mysql(8.x). I have intalled mysql library from npm. I wrote some code like below. File A - connection.js const pooledConInfo = { host: 'localhost', user: 'user', password: 'pw', database: 'db', …
Juneyoung Oh
  • 7,318
  • 16
  • 73
  • 121
0
votes
0 answers

Node postgres - (node:43028) UnhandledPromiseRejectionWarning: error: sorry, too many clients already

I am trying to add data to my databases. There are multiple entries in an array dataArryay.forEach((element) => { queryData(elementData) } The function is called multiple times async function queryData(data) { const queryString =…
TommyD
  • 913
  • 3
  • 17
  • 32
0
votes
2 answers

TYPO3 queryBuilder: How to work with BINARY in where() clause?

I just have a short question. There's no description in the following API overview of TYPO3 how to use a "BINARY" in where() clause: https://docs.typo3.org/m/typo3/reference-coreapi/master/en-us/ApiOverview/Database/QueryBuilder/Index.html#expr What…
user3332010
  • 147
  • 1
  • 11