Stack Overflow
Stack Overflow

Questions tagged [jdbc-pool]

JDBC pool is a pool of JDBC connections to a common data source. Pooling JDBC connection is a common practice to avoid expensive JDBC connection creation.

JDBC pool is a pool of JDBC connections to a common data source. Pooling JDBC connection is a common practice to avoid expensive JDBC connection creation.

External libraries implementing the JDBC pooling can be used to further boost the performance. Examples of such libraries are Apache Database Connection Pool., , Tomcat JDBC Pool, , .

Relevant Q/A:

73 questions
1
vote
1 answer

Does Tomcat DBCP support JDBC4 isValid() API?

Is there any Tomcat DBCP version that supports JDBC4 isValid() API? Or do I have to always supply a validationQuery even for JDBC4-compliant drivers?
rustyx
  • 80,671
  • 25
  • 200
  • 267
1
vote
2 answers

Tomcat Connection Pooling - java.lang.UnsupportedOperationException: Not supported by BasicDataSource

I have tried C3po library for connection pooling but I am gettting errors such as abstractMethodError() for my code I then decided to go with the tomcat pooling thing. Now I am getting an java.lang.UnsupportedOperationException: Not supported…
Abhijeet
  • 84
  • 1
  • 3
  • 9
1
vote
2 answers

MySQL Statement Cancellation Timer in waiting state in grails 2.2.4 with jdbc pool

I've used jdbcpool 7.0.47 on grails app with version 2.2.4. When i checked the threaddump it shows that lots of "MySQL Statement Cancellation Timer" are in waiting state. I've also tried moving the jdbc connector to tomcat/lib but it start to give…
Hakucha
  • 95
  • 1
  • 7
1
vote
1 answer

Getting error while connecting Vibur DBCP to Oracle DB

I am trying to setup Vibur DBCP to work against an Oracle 11g DB instance but I keep getting an Oracle exception. This is the URL = jdbc:oracle:thin:@//db.vonagenetworks.net/MY_SERVICE This URL works when I use it with our Tomcat Connection Pool. …
Jose Martinez
  • 11,452
  • 7
  • 53
  • 68
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

Bind grails datasource to jndi-name

Configuring a Grails v2.2.4 app with mysql database to use JDBC connection pool and JavaMelody monitor. Everything seems to run properly in GGTS v3.4.0 but unable to deploy a WAR file successfully. Config.groovy contains: grails.naming.entries =…
KnownUnknown
  • 11
  • 1
  • 3
1
vote
0 answers

Unknown threading issue causes asynchronous Spring controller method to leak db connections

I have a asynchronous Spring MVC controller method (which returns a DeferredResult) that calls a Spring service method that itself use the entityManager in order to retrieve data from a database. Somehow, the async controller method causes…
balteo
  • 23,602
  • 63
  • 219
  • 412
1
vote
0 answers

Detecting first use of a Connection in a JdbcInterceptor

While creating a JdbcInterceptor for Tomcat jdbc-pool, one can override the method reset(ConnectionPool parent, PooledConnection con), which will called every time the connection is borrowed from the pool. Is there a way to detect if this is the…
Darius X.
  • 2,886
  • 4
  • 24
  • 51
1
vote
0 answers

dbcp spawns hugh connection number to Oracle DB in high rate of open/close

My application used DBCP1.4, hibernate and spring, connects to oracle. under common load of few hundered req/sec i get too many TCP connections to the DB (resulting in excessive system usage upon DB side for authentication, 95% cpu for 16 cores…
arik yakir
  • 11
  • 2
1
vote
1 answer

Tomcat jdbc-pool acquireRetryDelay

C3p0 cache has acquireRetryDelay parameter to set time between acquire attempts. Has tomcat7 jdbc-pool the same functionality?
kolchanov
  • 2,018
  • 2
  • 14
  • 32
0
votes
0 answers

Connection pool locked using Spring Dbcp2 pool

I have and application that manages hundreds of databases and I use a connection pool for every database. Sometimes one of the databases becomes locked and all the operations that involves queries on that connection pool are locked. It is very…
Plebios plebios
  • 1
  • 1
0
votes
1 answer

An internal object pool swallowed an Exception org.apache.commons.dbcp2.LifetimeExceededException: The lifetime of the connection

I am getting an error as below. org.apache.commons.dbcp2.LifetimeExceededException: The lifetime of the connection [198,970] milliseconds exceeds the maximum permitted value of [60,000] milliseconds What exactly I am doing ? I am trying to do a…
Mahesh A R
  • 11
  • 4
0
votes
1 answer

Getting typecast error while creating dbcp2.PoolableConnection with dbcp 2.9 version and Ojdbc8

Background - I was using commons-dbcp 1.2 in my project and I am trying to upgrade to latest commons-dbcp2 2.9 version with ojdbc8 to achieve the resiliency that comes from newer dpcp2 version. Problem - Post updating to newer dbcp2 I am getting…
Anshu
  • 69
  • 2
  • 18
0
votes
0 answers

java dbcp2 connection pooling

So I am trying to understand how to build connection pools and to connect via java to an Oracle DB. i am trying to use dbcp2 to learn more about how all of this works. If I use the BasicDataSource I can connect and I see 5 connections via the…
cptkirkh
  • 107
  • 1
  • 9
0
votes
1 answer

Instant data type change to String JsonArray Vertx

I have service proxy db call, I am sending the jsonarray over event bus through service proxy and converting the jsonArray to tuple to make DB call. What Issue I am facing is jsonArray I received at my dbService the data-type of Instant got changed…
Ravat Tailor
  • 1,193
  • 3
  • 20
  • 44
1 2
3
4 5