Stack Overflow
Stack Overflow

Questions tagged [bonecp]

BoneCP is a fast, free, open-source, Java database connection pool (JDBC Pool) library. It should now be considered deprecated in favour of HikariCP.

BoneCP is a fast, free, open-source, Java database connection pool (JDBC Pool) library. BoneCP's implementation is tuned for high performance by minimizing lock contention to achieve a greater throughput.

Resources:

161 questions
5
votes
1 answer

How to log connection pool data using BoneCP

Does anyone know hot to log connection pool data (i.e. number of open and idle db connections) using BoneCP? It's easy to achieve using C3P0 which I'm migrating from (in fact this information is logged by default there) but it seems to be harder to…
mnowotka
  • 16,430
  • 18
  • 88
  • 134
5
votes
1 answer

BoneCP and Hibernate

I'm currently in a process to integrate BoneCP into an existing project that has Hibernate, and as I was reading BoneCP's manual, I found this: If you are using this library directly in Hibernate (i.e. without a DataSource, not recommended) and I…
Gonçalo Cardoso
  • 2,253
  • 4
  • 34
  • 63
5
votes
1 answer

BoneCp pool having closed connections

I am using Bonecp datasource with slick. And found that pool contains closed connection so I always encounter this exception java.sql.SQLException: Connection is closed! at…
pankajmi
  • 195
  • 1
  • 10
5
votes
1 answer

How to use Spring BoneCPDataSource bean as data source for Log4j 2 JDBC appender?

I would like to log log4j2 messages into relational database. Documentation for JDBC appender is here. I can use as database connection provider these sources: ConnectionFactory DataSource DriverManager but is there some way how to use datasource…
user2148736
  • 1,283
  • 4
  • 24
  • 39
5
votes
1 answer

MysqlConnectionPoolDataSource or c3p0 like library?

What's the difference between MysqlConnectionPoolDataSource and C3p0, BoneCP or dbcp library for connection pooling? I don't understand why use a library if mysql connector give connection pooling.
Nicolas
  • 53
  • 3
5
votes
3 answers

Cannot change transaction read-only property in the middle of a transaction

I am using BoneCP with Postgresql and Spring JdbcTemplate. When JdbcTemplate executes query and then tries to close the connection, it gets this exception: org.postgresql.util.PSQLException: Cannot change transaction read-only property in the…
mkayman
  • 100
  • 1
  • 2
  • 11
5
votes
3 answers

Play2.0 returns "SQLException: Timed out waiting for a free available connection."

I have been using Play 2.0.2 in order to create a Java application. For a few days I'm running into a problem. After ~100 request the server starts to throw this exception: [[SQLException: Timed out waiting for a free available connection.]] I…
burak emre
  • 1,501
  • 4
  • 22
  • 46
5
votes
1 answer

Java BoneCP MySQL connection timing out

I have an application set up to pool mysql connections with BoneCP. Right now, the application isn't getting a ton of use, so the connections aren't used as frequently. After a certain amount of time, queries that once worked, start to fail, and I…
Nick
  • 53
  • 1
  • 3
4
votes
1 answer

Using bonecp as Tomcat 5.5 datasource

I try to get Tomcat to use BoneCP as a connection pool because DBCP doesn't work correctly here. I tried to add it to the context.xml that defines my webapp like this:
Daniel
  • 27,718
  • 20
  • 89
  • 133
4
votes
2 answers

mssql-jdbc MS SQL Server JDBC driver prepared statement cache performance issue with Hikari CP

We have been converting our server from using Hibernate 4.2 to Hibernate 5.2. Hibernate 5.2 requires JDBC 4.2 (Java 8), which requires us to switch to Hikari CP connection pool which is a branch from the (now deprecated) Bone CP we were previously…
Roger D
  • 41
  • 2
4
votes
2 answers

Does BoneCP (or any other pool) close connection's statements when connection is returned to pool?

Does BoneCP (or any other pool) close connection's statements when connection is returned to pool? As I understand, it does not call actual connection's close method, so there is no automatic statement closing. So, does it close statements in any…
Fixpoint
  • 9,619
  • 17
  • 59
  • 78
4
votes
1 answer

javax.ejb.CreateException: Could not create stateless EJB with glassfish and boneCP on intellij-idea

I recently began to use Glassfish and boneCP on intellij idea with a simple web app, but there's a bug I can't understand. I believe I followed all the steps in the tutorial. My model goes like this @Entity public class Song implements…
Gers
  • 572
  • 1
  • 4
  • 15
4
votes
2 answers

Casting java.sql.Connection to oracle.jdbc.OracleConnection results in compilation error

I would like to cast java.sql.Connection to oracle.jdbc.OracleConnection in order to bind data on ARRAY to my query. When I try the following on scala 2.10, bonecp 0.8.0 and slick 2.0.0: import com.jolbox.bonecp.ConnectionHandle import…
uhef
  • 1,099
  • 1
  • 8
  • 9
4
votes
1 answer

Slick and bonecp: org.postgresql.util.PSQLException: FATAL: sorry, too many clients already error

Locally when I am developing my application I launch my play2 application using sbt run I love how I can make code changes, and then reload my browser to see my changes. After about roughly 10 code changes or so, I get a postgresql too many…
Blankman
  • 259,732
  • 324
  • 769
  • 1,199
4
votes
3 answers

What would be a good bonecp configuration for high concurrency

I have a web application that has to deal with high concurrency, like 100 users querying the same 5 tables (one of them, returns more than 500 rows) and some others users inserting in these tables at the same time. When there are too many users…
qxlab
  • 1,506
  • 4
  • 20
  • 48
1
2
3
…
10 11