Questions tagged [connection-pool]

108 questions
2
votes
1 answer

How to Execute multiple JPA queries in a single JDBC Connection

In a Spring-boot application, I am using JPA with Hibernate . I have a custom select query method with parameterised IN Clause defined in JPA Repository. Since the the data is huge, I am executing multiple times the same query with small batches of…
Vidya Shree
  • 81
  • 1
  • 7
2
votes
1 answer

Connection pool in java which allows to get connection by jdbc url?

I tried to find the connection pool which allows to get connection by jdbc url but failed. Hikari connection pool doesn't allow do it, the same situation in c3po. My use case is: ConnectionPool.getConnection(jdbcUrl); Does anybody know such…
2
votes
0 answers

Retrofit 2 cannot get response

I have an android app that home screen make few requests to server(5-10 requests by enqueue() depend on app logic) but when i come with adding one more request, i cannot get response from log. I config retrofit following code: HttpLoggingInterceptor…
Shaw
  • 105
  • 1
  • 1
  • 6
2
votes
1 answer

SQL Connections in Azure functions

Making a SQL connection is expensive and slow, so we use concepts like Connection Pools in 3-tier applications. When using an Azure function that accesses a SQL database, we have to connect to the database and then execute our logic. Doesn't this…
1
vote
1 answer

Is it okay to use both connection pools in AWS RDS proxy and mysql connection pool in lambda?

I am now moving my website from EC2 to lambda+RDS and I don't have much experience in RDS. As you know, AWS RDS supports a proxy to provide a connection pool and the lambda MySQL node.js module also supports a connection pool. Is it okay to use both…
1
vote
1 answer

connect oracle apex application to multiple databases

is there any simple way to connect an oracle apex application to another database other than apex admin database (like using WebLogic data source). I read this but there are a lot of problem with that. Run these commands `` java -jar ords.war…
1
vote
2 answers

Tomcat: Creating a connection pool for cloud API services

A Tomcat server worker thread replying to an incoming request must access at least one of several possible cloud API services (Google Cloud Storage in particular; non-modifying, that is, only performing Reads). Tomcat offers out-of-the-box pooling…
ChaimKut
  • 2,759
  • 3
  • 38
  • 64
1
vote
0 answers

Sharing a connection pool for all Rails uses of Redis

Summary: I'm using a single Redis instance for the Rails cache, actioncable and (non-cache) use in my rails code. Should all these uses share a single connection pool and if so how can I config this to make it happen since there seem to be totally…
1
vote
2 answers

Springboot JPA Repository not releasing Hikari DB Connection

I have a rest API in Springboot using Hikari for connection pooling. Hikari is used with default configurations (10 connections in the pool, 30 sec timeout waiting for a connection). The API itself is very simple It first makes a JPA repository…
user1280213
  • 269
  • 3
  • 10
1
vote
0 answers

python manage.py takes too much time to run in Django

I am working on Python rest framework and after setting up python 3.8.12 on my mac, when I tried to up the server with python manage.py runserver command for Django, it takes around 2 minutes and in-between it gives some connectionpool logs…
1
vote
1 answer

how to fix Keystore was tampered with, or password was incorrect on glassfish server

i'm trying to create a connection pool and JDBC Resource to deploy a java application on glassfish server, however, I couldn't deploy the project, and this is what it said: Error occurred during deployment: Exception while preparing the app…
1
vote
1 answer

Is IIS running out of connections?

Our IIS website has its Maximum Concurrent Connections set to 4294967295. Our Web API application is logging all the requests it serves to Application Insights and the two do not appear to match up. A call which appears to get served quickly in…
Matt W
  • 11,753
  • 25
  • 118
  • 215
1
vote
2 answers

How can I specify the current schema on quarkus datasource?

Hi I am trying to configure the quarkus to connect to a oracle database. With the current configuration I am able to connect to the database, but I cannot specify the current schema. I followed the documentation and try to use the new-connection-sql…
1
vote
2 answers

Multiple DB connections using a connection pool vs Single connection with multiple statements

I am developing a server working with MySQL, and I have been trying to understand advantage of working with a connection pool vs a single connection that is kept open, and being passed down to the different methods through out the application. The…
galyo
  • 31
  • 3
1
vote
1 answer

Database connection object is not callable exception thrown with Python Django SQL Alchemy database pooling. Why?

What I'm trying to achieve Create a database connection pool in Django. The connection pool is connected to a PostgreSQL database by using SQLAlchemy's connection pooling with django-postgrespool2. Thrown exception 'psycopg2.extensions.connection'…
EggBender
  • 888
  • 15
  • 36