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
1
vote
1 answer

spring async not releasing database connection

Tech Stack I am using spring boot 1.3.5 for a rest service which internally fetch the data from database..ORM used is JOOQ and the connection pool management is done by BoneCP... Requirement I have a requirement where i need to fire multiple sql to…
AutoMEta
  • 1,339
  • 6
  • 22
  • 35
1
vote
0 answers

Reconnecting JDBC failover hosts on Spring with BoneCP pooling

I configured my Spring Boot application to use BoneCP with PostgreSQL's failover mechanism (jdbc:postgresql://host1:port,host2:port,host3:port/my_db?currentschema=public) by providing several hosts that contain the same replicated database. When…
fernandopcg
  • 514
  • 6
  • 20
1
vote
0 answers

Dose BoneCP (JDBC pool Library) support auto reconnect in case of DB server restart? If so how to configure it in spring

I’m using BoneCP JDBC connection pool in my spring based application. I wondering whether it automatically reconnect to the DB server in case of DB server restart. I didn’t found any documentation on such support in BoneCP official web site. I…
1
vote
0 answers

Java BoneCP Sybase - "JZ0C0: Connection is already closed."

I used BoneCP for a long time and now I must use it with a Sybase database. The problem appears when I stop the Sybase service. While Sybase is stopped all connections in BoneCP give me the error "JZ0C0: Connection is already closed" and all…
Victorqedu
  • 484
  • 4
  • 20
1
vote
1 answer

ERROR [BoneCP-connection-watch-thread] - Connection obtained from thread [http-bio-8080-exec-14] was never closed.

I am getting above error after calling store procedure. I am using BoneCP driver to connect Hibernate with JPA. I am getting following exception, this exception is occurring after transaction is completed. I have turned on the connection monitoring…
Ammar Ali
  • 133
  • 3
  • 13
1
vote
2 answers

Where to define Connection,Statement,ResultSet in a servlet

I am using BoneCp connection pool. I have a question that where to specify JDBC connection objects such that It should not give errors like ResultSet is closed or Connection is closed. I am doing as shown below:(code snippet) public Class…
Manohar Gunturu
  • 676
  • 1
  • 10
  • 23
1
vote
1 answer

Bonecp creates more bonecp-pool-watch-thread and bonecp-keep-alive-scheduler threads

We are creating DB connection using JNDI with BoneCP connection pooling . After some time bonecp creates more com.google.common.base.internal.Finalizer , bonecp-pool-watch-thread and bonecp-keep-alive-scheduler active threads. So it takes more…
SANN3
  • 9,459
  • 6
  • 61
  • 97
1
vote
0 answers

BoneCP datasource opens many threads to manage the connections in application

BoneCP datasource opens many threads to manage the connections. Is there a way where it opens only single thread for all the datasources opened? Daemon Thread [com.google.common.base.internal.Finalizer] (Running) Daemon Thread…
1
vote
0 answers

bonecp keeps so many sessions and processes inactive

I have used bone-cp 0.8.0 release.jar, even though there is no connections is running on DB, still processes, sessions are showing drastically. Below is the…
1
vote
1 answer

hibernate4.1 + spring3.2 + boneCP

app context looks like
abroy
  • 83
  • 5
1
vote
1 answer

BoneCP, other connection pools and the ability to switch Schemas

I am laying the ground work for a multi-tennant application. Our strategy on the database side is to have some schemas shared (properties, persmissions and other non-tenant data) and have each tenant have their own schema. (This is not a question on…
cmdematos
  • 883
  • 4
  • 12
  • 24
1
vote
1 answer

JDBC connection pool manager

We're in the process of rewriting a web application in Java, coming from PHP. I think, but I'm not really sure, that we might run into problems in regard to connection pooling. The application in itself is multitenant, and is a combination of…
c0dem4gnetic
  • 932
  • 1
  • 7
  • 24
1
vote
0 answers

BoneCP - Add ShutdownHook to shutdown the connection pool

I'm using the BoneCP connection pool library and basically everything works fine. But there is one thing that I am not 100 percent sure about: I have a connection pool that is open during the whole runtime. Do I have to add a shutdown hook that…
MinecraftShamrock
  • 3,504
  • 2
  • 25
  • 44
1
vote
0 answers

BoneCP creating too many connections. Stats gives negetive numbers

[BoneCP Version : 0.8.0.RELEASE] [Guava Version : 11.0.2] I am using guice-mybatis with bonecp as datasource-provider. I have wrapped the MySQL driver with getConnection() over-ridden in order to rotate across mysql master and slave. I see boneCP is…
1
vote
0 answers

BoneCP connection closed unexpectedly

I'm integrating DataNucleus with BoneCP-0.8.0-rc2 and I'm getting this exception, randomly: javax.jdo.JDODataStoreException: No operations allowed after connection closed. at…