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
71
votes
4 answers

Java JDBC connection pool library choice in 2011/2012?

Which JDBC connection pool library should I use for a new application project (not web application)? Apache DBCP has enough unresolved issues which are pushed until 2.0 I think. C3P0 development seems to be stopped. And both of them looks…
Vladislav Rastrusny
  • 29,378
  • 23
  • 95
  • 156
22
votes
6 answers

Java Database connection pool (BoneCP vs DBPool vs c3p0)

For a Java app outside of a J2EE container, which connection pool library is the best? I heard c3p0 is getting outdated. Jakarta's common pool library is no longer under development Therefore I'm left with BoneCP and DBPool. From what I can tell…
Stephane Grenier
  • 15,527
  • 38
  • 117
  • 192
15
votes
1 answer

Java Connection Pooling best practices?

After getting fed up with c3p0's constant locking I'm turning to BoneCP for an alternative connection pool for my database. I have a server app that processes around 7,000 items per minute and needs to log those items into our MySQL database. I…
James
  • 15,085
  • 25
  • 83
  • 120
15
votes
5 answers

Fast and reliable alternatives to bonecp connection pool

I was using BoneCP for my Java projects. But, unfortunately, I discovered that this pool is unable to recover after the database failure. I am not the only one with such problem (just look at the official forums if you want). As I (and many others)…
Deinlandel
  • 1,023
  • 8
  • 25
13
votes
5 answers

Is "Tomcat 7 JDBC Connection Pool" good enough for production? And how is it compare to BoneCP?

Our site get roughly 1M pv/day, and we use Tomcat for sure. I couldn't find much information about jdbc-pool, not sure if it's stable enough for production. Anyone got experience on it? and any configuration/tuning stuff for reference? As someone…
BigFatSea
  • 473
  • 1
  • 6
  • 13
13
votes
1 answer

A better explanation for partitionCount in BoneCP

From official BoneCP doc: http://jolbox.com/index.html?page=http://jolbox.com/configuration.html partitionCount In order to reduce lock contention and thus improve performance, each incoming connection request picks off a connection from a pool…
Felipe
  • 16,649
  • 11
  • 68
  • 92
12
votes
2 answers

BoneCP correct usage

I've just started using BoneCP and pulled the sample JDBC code from the authors site. I have a function called getConnection() that returns a connection here is a snippet: // setup the connection pool BoneCPConfig config = new BoneCPConfig(); //…
jim
  • 8,670
  • 15
  • 78
  • 149
9
votes
1 answer

Monitoring Bone cp Connection pool

We are trying to move to bonecp connection pool from c3p0. we use hibernate as the ORM tool. Now, is there any way to monitor the connections in boncecp like getting to know the maximum available and busy connection in the pool at a particular…
Npa
  • 617
  • 2
  • 15
  • 26
8
votes
1 answer

Play framework 2, postgres "This connection has been closed"

I'm running a Play 2.2.0 app, using Postgres 9.2-1002-jdbc4, and the Anorm 2.2.0 API. Every so often I have connection issues which look like: 2013-11-19 19:45:36,544 [ERROR][a.d.Dispatcher][play-akka.actor.default-dispatcher-17] This connection…
seand
  • 5,168
  • 1
  • 24
  • 37
7
votes
1 answer

Using BoneCP: Handling connections from the pool

I have just started using BoneCP and this is my first time using a connection pool. I'm somewhat confused as to how I am supposed to use it. Currently I am saving the BoneCP-object as a static variable, and thus I can use it between different…
pgsandstrom
  • 14,361
  • 13
  • 70
  • 104
7
votes
1 answer

Defining an alternate connection pool in Grails 2.3.6

I know that, at some point between Grails 1.X and Grails 2.X, the default connection pooling library changed from commons-dbcp to tomcat-dbcp. Now, I'm trying to configure either BoneCP or HikariCP as the connection pooling library for my Grails…
Jesús Zazueta
  • 1,160
  • 1
  • 17
  • 32
7
votes
1 answer

BoneCP throws "SQLException: Connection is closed!" when batch inserting into MySQL

I've been tasked with setting up a project using BoneCP with jOOQ and Spring, but I've run into some difficulties doing so. Doing individual inserts into my MySQL-database works perfectly fine, but doing so with 190 000 objects takes almost 20…
TheShahin
  • 153
  • 1
  • 12
6
votes
1 answer

Oracle JDBC driver statement cache vs BoneCP statement cache?

I'm using Oracle JDBC driver and evaluate BoneCP. Both implement a statement cache. I am asking myself whether I should use the one or the other for statement caching. What do you think? What are the advantages or disadvantages for each way?
MRalwasser
  • 15,605
  • 15
  • 101
  • 147
6
votes
4 answers

Heroku/Play/BoneCp connection issues

I have an app on heroku that uses play. It was working fine for the longest time, but somewhat recently I started getting this: Caused by: java.sql.SQLException: Timed out waiting for a free available connection. at…
radu--
  • 108
  • 1
  • 6
6
votes
1 answer

Is there a way to reload Tomcat's Connection Pool at runtime?

My case is as follow: I have to maintain a server, with Tomcat(6) as web server, that has a bunch of webapps on it. These webapps are maintained by others. Our server has a connection to another department's DB server, which has information that…
bkhnjkt
  • 91
  • 1
  • 3
1
2 3
…
10 11