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
0
votes
1 answer

Upgrading from MySQL 5.5 to 5.6 and getting "SQLException: Connection is closed"

I am using the Play Framework with eBean. Upgrading to MySQL 5.6 has caused the following exception when running my database evolutions: java.sql.SQLException: Connection is closed! …
0
votes
1 answer

Limit on number of created server in Play Framework (EbeanServerFactory.createServer)?

I'm facing a strange issue while developing with play framework. My code creates dynamically a server with an associated data source config. If I repeat the "server create" operation 75 times then I encouter a "Too many connections issue". So, can…
user3611522
  • 81
  • 1
  • 11
0
votes
2 answers

Using prepared statements with BoneCP

I am using BoneCP with MySQL in Java. I have several threads, and overtime they will be requesting a connection from the pool to perform some query. The queries are repetitive so I'd like to use prepared statements. I've used prepared statements…
Saturn
  • 17,888
  • 49
  • 145
  • 271
0
votes
1 answer

Too many connections: Hibernate BoneCP

Background: I am using hibernate with my sql for my model layer with spring to expose REST services. I have a mobile client that uses the rest services on the backend. The code is currently deployed on an AWS micro instance. Problem: As soon as the…
0
votes
1 answer

Configuring connection pool size with guice, mybatis, and c3p0 or bonecp

I'm using Guice/Mybatis to manage and execute my queries to a MySQL database. My class that sets up the connection and extends MyBatisModule contains these relevant bits: Properties myBatisProperties = new…
Supagoat
  • 31
  • 4
0
votes
2 answers

Closing connection in BoneCP

We have BoneCP library managing our connection pools. I'd like to know if the following statement will return the connection back to the pool. statement = conn.createStatement(); .... lots of code. .... Connection conn =…
Zeus
  • 6,386
  • 6
  • 54
  • 89
0
votes
1 answer

boneCp maven depenedncy not downloaded

I am trying to configure boneCp and the maven dependency for bonecp is not getting downloaded. I have included the dependencies for guava and SLF4J too, com.jolbox
0
votes
1 answer

Transaction started but not ended on database test connection query

Recently a bug was noticed in our application which caused the time of the operation to differ from the actual time(we are using current_timestamp() PostgreSQL function instead of passing time from the code). We've looked into it and discovered that…
Serhiy
  • 4,073
  • 3
  • 36
  • 66
0
votes
1 answer

Mysql: disable autocommit with each insert in Spring

I'm using Spring 4.0.5, Mysql 5.6.19 and BoneCP 0.8.0 My issue is that, in one transaction defined in the application, MySql is commiting each insert or update, so it does not making a transaction. First of all, I have read some questions like mine,…
yaki_nuka
  • 724
  • 4
  • 26
  • 44
0
votes
0 answers

Monitoring BoneCP within a Play application

I'm trying to monitor BoneCP activities from a Play application. I have added the DB configurations in conf/application.conf db.default.disableJMX=false db.default.statisticsEnabled=true When starting the Play application I added the relevant flags…
Switch
  • 14,783
  • 21
  • 69
  • 110
0
votes
1 answer

How to configure Play Framework 2 to make a readonly database connection?

I am developing an application which would fetch data from an Oracle database. It is a reporting app, no insert, update, delete is required. I know that I can set privilege for the database user to only select. But can I configure the database…
Khalid Saifullah
  • 747
  • 2
  • 8
  • 21
0
votes
1 answer

Java Play 2.2.2 BoneCp 0.8.0.RELEASE MySql Timeout Connection

I understand there are other posts that discussed this problem. I tried their solutions but none of them actually works. I have been frustated and getting this error: Caused by: java.sql.SQLException: Timed out waiting for a free available…
0
votes
1 answer

Play Framework 2.2.2 on Tomcat 7 - Remove BoneCP

I have a Play Framework 2.2.2 application that I am deploying as a .war file and running under Tomcat 7. My application runs for days without problems on my local dev machine (through Play's built in server, not Tomcat), but once I deploy it under…
sean.boyer
  • 1,187
  • 16
  • 24
0
votes
1 answer

executeUpdate throws error when writing to openfire db

Trying to insert into a table present in openfire db: .. .. Connection con = new Connection(); Statment stmt = null; try{ stmt.executeUpdate("insert into utable values ('a','a');"); } catch(Exception e){ e.printStackTrace(); } ... .. I'm getting…
Mercenary
  • 2,106
  • 6
  • 34
  • 43
0
votes
1 answer

Does BoneCP support XA Transactions?

Any idea if BoneCP supports XA Transactions? The list of features on the website doesn't mention anything about XA Transactions.
lutfijd
  • 312
  • 1
  • 2
  • 11