I need to set some specific Oracle JDBC connection properties in order to speed up batch INSERTs (defaultBatchValue) and mass SELECTs (defaultRowPrefetch). I got suggestions how to achieve this wit...

Currently we are using 4 cpu windows box with 8gb RAM with MySQL 5.x installed on same box. We are using Weblogic application server for our application. We are targeting for 200 concurrent users f...

The problem I'm trying to solve is latency between Microservice communication on the backend. Scenario. Client makes a request to service A, which then calls service B that calls service C before r...

I am working on developing micro services for a monolithic application using spring boot + spring cloud + spring JDBC. Currently, the application is connecting to a single database through tomcat ...

I'm using HikariDataSource to connect to a MariaDB database. The following class returns a Connection. public class DataSource { private HikariDataSource ds; // The constructor takes db name as ...

I am using Java driver to access mongodb. I assume the db connection pooling is internally handled by the driver.But my connection count getting increased every time I access db. This is my server...

What is the best connection pooling library available for Java/JDBC? I'm considering the 2 main candidates (free / open-source): Apache DBCP - http://commons.apache.org/dbcp/ C3P0 - http:...

I understand that if I instantiate a SqlConnection object, I am really grabbing a connection from a connection pool. When I call Open(), it will open the connection. If I call the Close() or Dispos...

We've been having this issue in prod for the past few weeks. Every few days, the number of connections to our compose.io Mongo db spikes to nearly 5000, which is the connection limit. There doesn'...

I moved my project to HikariCP. Everything is going fine so far, but with one setting I'm having trouble. It's the .setMaxLifetime(30*1000) setting in HikariConfig object. I get this warning WAR...

I am saving a user's database connection. On the first time they enter in their credentials, I do something like the following: self.conn = MySQLdb.connect ( host = 'aaa', user = 'bbb', passwd ...

I just wanted to know the concept of database connection pooling and how it is achieved.

I'm using JSch for file upload over SFTP. In its current state each thread opens and closes connection when needed. If it possible to use connection pooling with JSch in order to avoid overhead cau...

I'm trying to better understand what will happen if multiple threads try to execute different sql queries, using the same JDBC connection, concurrently. Will the outcome be functionally correct? ...

Our standard code section for using JDBC is... Connection conn = getConnection(...); Statement stmt = conn.conn.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); Res...

I am handling the connections in proper way. 1. I am using 'Hibernate' connection pooling in my application. Whenever I get a connection from pool, I am returning back to pool after finishing the t...

I'm using C3P0 as a connection pool in Tomcat, and I'm seeing very worrying errors: 2010-09-16 13:25:00,160 [Timer-0] WARN com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async....

[Disclaimer] : I think I have read every stackoverflow post about this already I have been breaking my head over this for quite some time now. I am getting the following exception in my asp.net web...

I have a basic Spring JDBC application with a pretty basic configuration: <bean id="myDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="dri...

I have a grails/groovy web-app with database connection pooling. The settings are set-up like this: dataSource: url: "jdbc:postgresql://192.168.100.53:5432/bhub_dev" properties: jmxEnabled: tr...

I don't know, how to approach a solution for the following scenario. We have a new requirement to remove DB Password from properties even though it's encrypted with Jasypt library or some other al...

I am using Apache HTTP Client for connection pooling during my REST API calls into certain web services. Strange thing is that in spite of me using HTTP Connection Pooling there are no gain in my ...

We have an app which targets .NET 4.5.1, and this has remained unchanged. However when we upgraded the .NET framework on the server from 4.5.1 -> 4.7.1, we started experiencing SQL timeouts severa...

I'm getting this exception for last few days. This problem occurs when I process 10++ form and connection keep on increasing every 30 seconds to 1 minute 30 seconds until reach max size. I've e...

I recently had a problem with Celery and Redis : I was using too many connections to my cloud Redis account. I seem to have fixed the problem for now with better settings and a bigger Redis plan. ...