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

Play/BoneCP message "releaseHelperThreads has been deprecated"

Does anyone know if the following message obtained when starting a Play 2.2 app is important or not? WARN - releaseHelperThreads has been deprecated -- it tends to slow down your application more. I cannot find this setting anywhere, and most…
wwkudu
  • 2,778
  • 3
  • 28
  • 41
4
votes
1 answer

BoneCP will not return or throw if connections are invalid

Using BoneCp 0.7.1 I setup my application and everything is working fine, but then the DB went offline. On the next application request getConnection() started throwing internal exceptions and the retry mechanism kicked in but getConnection() never…
user432024
  • 4,392
  • 8
  • 49
  • 85
4
votes
1 answer

BoneCP doesn't recover from broken connection

I have a problem with BoneCP (0.7.1 RELEASE). I though that BoneCP.getConnection() ensures it would return Connection object assuming that DB is alive. Here is how I configured my pool private void setupConnectionPool() throws SQLException { //…
expert
  • 29,290
  • 30
  • 110
  • 214
4
votes
1 answer

Play! 2.0 - BoneCP Returning Closed Connections

I have an interesting issue which I have not been able to resolve. I am using Play! 2.0.4 and using the integrated BoneCP connection pool to get the DB connections. However, for some reason, BoneCP keeps returning closed connections. Database…
cadams500
  • 73
  • 1
  • 6
4
votes
1 answer

BoneCP 0.7.1.RELEASE and hibernate 4.1.*

I try to add BoneCP to hibernate and have: java.lang.ClassNotFoundException: org.hibernate.connection.ConnectionProvider I couldn't find this interface in new hibernate packages and have 2 questions : 1) Could you share link or example how to…
pushistic
  • 3,406
  • 3
  • 21
  • 35
3
votes
1 answer

Failed to instantiate SLF4J LoggerFactory

So, I'm working from this example BONECP: package javasampleapps; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import com.jolbox.bonecp.BoneCP; import…
davidahines
  • 3,976
  • 16
  • 53
  • 87
3
votes
1 answer

How to disable caching in OpenJPA 2.0.1 (edit: Issues with BoneCP)

I'm unable to disable caching in OpenJPA 2.0.1. I have set the following properties in my persistence.xml:
Joel
  • 29,538
  • 35
  • 110
  • 138
3
votes
0 answers

Simple query takes too long via JDBC but very quick from MySQL console

I have a simple query and it takes only 0.2 seconds when I execute it on mysql console. But when I execute this query via jdbc from my runnable java jar, it takes about 15 seconds to get the data (20000 rows). This query is so simple and the field…
bAris
  • 111
  • 3
  • 9
3
votes
1 answer

Avoid opening unused database connections in Play

I have a Play application that defines three different connection configurations in conf/reference.conf. When I run unit tests that require the use of FakeApplication the BoneCP plugin automatically initializes these three connections even when the…
Alex
  • 439
  • 4
  • 8
3
votes
1 answer

BoneCP: Is there a way to configure the Statement Timeout for all statements?

I am using a play application (play-java 2.2.1, bonecp 0.8.0.RELEASE) that uses BoneCp to access a mysql database, and did not found a way to set the statement timeout for all statements (conf doc here). All I found is how to do ir…
emasoero
  • 65
  • 5
3
votes
0 answers

Multiple Play tests error: "obtain a connection from a pool that has already been shutdown"

I'm writing integration tests that start up a Play 2.2.2 application (e.g. Helpers.running(fakeApplication) {...}. The first test completes without error, but the next gives the following (abridged) stack trace: java.sql.SQLException: Attempting to…
user3364825
  • 1,541
  • 1
  • 15
  • 23
3
votes
2 answers

How to use JDBC to maximize performance of Netty?

I am developing a HTTP application server using Netty 4 and JDBC(+BoneCP for connection pooling). So far, I am doing all the work(works involving database connections, HttpAsyncClient and so on) on one handler. I close all I/O after each job is…
Jee Seok Yoon
  • 4,716
  • 9
  • 32
  • 47
3
votes
1 answer

Is there any inconvenient if I never call shutdown() method in the connection pool (BoneCP)?

I'm developing a WebApp and it can be accessed 24/7, so it doesn't really have a moment when I can say: "Finally I'm not using the connection pool anymore, I'm going to shut it down". I've read (here at SO: BoneCP correct usage) that I should use…
Clawdidr
  • 577
  • 1
  • 8
  • 25
3
votes
2 answers

How to make a custom compiler warning in Eclipse?

I am experimenting with BoneCP as a connection pooling alternative to DBCP. I added the bonecp-0.8.0rc-1.jar to my runtime classpath, and copy-n-pasted the code from their example page into my test driver: Connection connection = null; BoneCP…
IAmYourFaja
  • 55,468
  • 181
  • 466
  • 756
3
votes
1 answer

BoneCP shuts down automatically in the middle of the work

We have an Oracle 11g database, a web service that uses hibernate. We recently switched to BoneCP for connection pooling but there seems to be something wrong and the BoneCP shuts down in the middle of the software startup. Here is the hibernate.cfg…
bbkglb
  • 769
  • 1
  • 7
  • 16
1 2
3
10 11