I'm trying to process large amount of data using Python and maintaining processing status in MySQL. However, I'm surprised there is no standard connection pool for python-mysql (like HikariCP in Ja...

Does Hibernate use connection pool by default? If so what is the default value for *connection.pool_size*? Doesn't it conflicts with *hibernate.connection.release_mode*? Isn't the all idea of conne...

I'm using knex version 3.10.10, in my node app, connecting to MySQL DB. My configuration of knex in the app is using the pool option configuration. 1) Is there a need to EXPLICITLY return a connec...

We are implementing a Web App using JPA2.0 and Hibernate3.0. Connection pool configurations are set in persistence.xml located in META-INF folder. persistence.xml: <persistence xmlns="http:/...

I am working on a project in which I need to make a HTTP URL call to my server which is running Restful Service which returns back the response as a JSON String. Below is my main code which is usi...

Can anybody provide examples or links on how to establish a JDBC connection pool? From searching google I see many different ways of doing this and it is rather confusing. Ultimately I need the c...

I am configuring JDBC connection pool for Spring Boot app and Postgres DB to use HikariCP connection pool and trying to find best practices for configuration setup, unfortunately there is not much ...

Hi all I'm using Hibernate+Struts2+Tomcat6+Mysql as my J2EE framework. I've been using hibernate's built-in connection pooling mechanism but it turned out to be problematic where mysql closes it's ...

Context I'm building a SaaS where users can create their own websites (like Wix or SquareSpace). That's what happens behind scenes: My app has its main database which stores users When a user cr...

I'm trying to debug what seems to be an excessive number of database connections being opened and closed despite the fact that we are using the Tomcat 7 JDBC connection pool. How can I log when cal...

As i can understand every pool.query() will cost a connection and it is automatically release when it ends. based from this comment on github issue. But what about the nested queries performed usin...

How do I detect if a transaction remains open, still pending on a COMMIT or ROLLBACK on a JDBC Connection? I'm getting my Connection objects via a connection pool. So I want to check the state of ...

Are there any advantages to use something like HikariCP with embedded databases like SQLite, H2 or HSQLDB? (the last two can also run in server mode but I'm not interested in that) Apart from the ...

I'm very unfamiliar with Hibernate and have just started working on a web app that uses it with a MySQL database. I notice that the community documentation tutorial states: The built-in Hiberna...

I am developing a BLE application on Nexus 4 using Android BLE API. I have a few questions/doubts: 1) Is there a way to set/override the connection or notification interval of BLE central device. ...

For various reasons connections in a pool can become invalid: server connection timeout, network issues... My understanding is that a Tomcat JDBC Connection Pool does not provide any guaranty abou...

In OkHttp I cannot find a way to set a hard maximum connection pool size. From the documentation https://square.github.io/okhttp/3.x/okhttp/okhttp3/ConnectionPool.html it is clear that you can set ...

I want to configure HikariConfig pool for Oracle: Properties props = new Properties(); props.setProperty("dataSourceClassName", "oracle.jdbc.driver.OracleDriver"); props.setProperty("dataSource....

i am working on opensource java based application i.e xwiki. Inside hibernate.cfg.xml i can see value of parameters connection.pool_size and statement_cache.size as 2 (for each). My application wil...

What is the maximum and minimum size of connection pool ADO.Net Supports in the connection string.Min Pool Size=[max size ?]Max Pool Size=[min size]

I have been getting these exceptions for a number of weeks with no solution... com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server wa...

I am trying to hit a server using HTTP client using PoolingClientConnectionManager setting max connections for individual hosts //Code that initializes my connection manager and HTTP client HttpPa...

I been trying to develop a Minecraft server plugin where a player enters a command with some data, data is sent to database, or, a command that requests some data from database. It's working, unti...

I have a rails 4 app I am hosting on heroku. They give some specific advice about how to manage your DB connection pool when using a multi-threaded server (puma)https://devcenter.heroku.com/article...

Let's say I am storing data of Person(id, country_id, name). And let's say user just sent the id and country_id and we send back the name. Now I have one db and 2 webserver and each webserver keep...