Stack Overflow
Stack Overflow

Questions tagged [tomcat-jdbc]

This tag is about tomcat and jdbc working together.

is a Java-based data access technology (Java Standard Edition platform) from Oracle Corporation. This technology is an API for the Java programming language that defines how a client may access a database.

is an open source web server and servlet container developed by the Apache Software Foundation (ASF). Tomcat implements the Java Servlet and the JavaServer Pages (JSP) specifications from Sun Microsystems, and provides a pure Java HTTP web server environment for Java code to run in. In the simplest config Tomcat runs in a single operating system process.

This tag is about tomcat and jdbc working together.

63 questions
1
vote
0 answers

Connection not released back to the tomcat jdbc pool

I have a grails2 based application which is using tomcat jdbc pool, recently I have been getting into problem where all the connections in the pool get used up and I start getting:- org.springframework.transaction.CannotCreateTransactionException:…
thickGlass
  • 540
  • 1
  • 5
  • 19
1
vote
0 answers

How CrudRepository deals with DB Connection from ConnectionPool

I can't find any default implementation class for spring-data-commons crudrepository interface. We always implement CustomRepository extends CrudRepository and then @Autowire CustomRepository customRepository in the service class to call…
Divs
  • 1,578
  • 2
  • 24
  • 51
1
vote
1 answer

Jetty with tomcat-jdbc connection pool

Jetty manual provides connection pool examples with BoneCP, c3p0, DBCP but not tomcat-jdbc. Is it possible to configure Jetty with tomcat-jdbc connection pool?
cdeep
  • 47
  • 5
1
vote
1 answer

Tomcat DataSource - Max Active Connections

I set max active connections to 1 using the below code : ConnectionPool initializePool(DataSource dataSource) { if (!(org.apache.tomcat.jdbc.pool.DataSource.class.isInstance(dataSource))) { return null; } …
Punter Vicky
  • 15,954
  • 56
  • 188
  • 315
1
vote
1 answer

Can Tomcat support multiple JDBC connection pools?

I have a Spring Boot application which connects to different MySQL databases. I am planning to add connection pool support to this application. Does the Tomcat JDBC Connection Pool (default Spring boot pool) support more than one pool for each of my…
Bill Goldberg
  • 1,699
  • 5
  • 26
  • 50
1
vote
1 answer

Tomcat + TomcatJDBC ServletContextListener open threads

When undeploying an application from Tomcat there are threads left open. org.apache.catalina.loader.WebappClassLoader clearReferencesThreads SEVERE: The web application [/services] appears to have started a thread named [Abandoned connection cleanup…
BHarman
  • 572
  • 1
  • 6
  • 15
1
vote
1 answer

tomcat-jdbc pool datasource not reconnecting

I have a spring boot application with the following data source…
RVP
  • 2,330
  • 4
  • 23
  • 34
1
vote
1 answer

Error while using tomcat jdbc pool StatementCache interceptor

I am using tomcat jdbc pool with "apache-tomcat-7.0.47" as my app server. When I don't use the StatementCache interceptor, everything works fine. But I start getting an error as soon as I declare StatementCache interceptor in my context.xml. Below…
Bharath
  • 259
  • 1
  • 13
0
votes
0 answers

Postgres connection stuck at idle even after serving 200 requests per second through a JDBC connection

Just like the title says. I am monitoring the pg_stat_activity table in my Postgres DB and trying to capture the behavior of my Tomcat JDBC connection pooling implementation. The idle connections that are opened on startup being returned to the pool…
Iceweasel
  • 1
0
votes
0 answers

How to track source of multiple sleep queries?

Our application developed using java and mysql Db as a backend. for conenction pooling we have used tomcat-jdbc connection pooling where configured the maxActive connection size to 300. from last few days our application frequently reaching the…
Avyaan
  • 1,285
  • 6
  • 20
  • 47
0
votes
0 answers

How to decide maxIdle properties in DB connection pooling configuration?

I am using tomcat jdbc for DB connection pooling. recently i have increased my maxActive property after frequent connection pool exhaust issue (when application under heavy load) so decided to increased the maxActive property by 50% after performing…
Avyaan
  • 1,285
  • 6
  • 20
  • 47
0
votes
1 answer

Open or close the connection instantly after DB operation or use same connection throughout method

i am working on a java web application where Database connection pooling is managed by tomcat-jdbc. I need to know which one is best practice 1.use same connection for multiple DB interactions in same method. 2. Open and close the DB connection per…
Avyaan
  • 1,285
  • 6
  • 20
  • 47
0
votes
0 answers

Tomcat database connection pool slow in high throughput

I have soap webservice written in Spring 2.X and which connect to Teradata and return the result to client. To connect the data based I am using Tomcat JDBC Connection Pool as the DataSource. In peak hour (9AM to 6PM) application get about 60k…
user1591156
  • 1,945
  • 4
  • 18
  • 31
0
votes
2 answers

Tomcat 8.5 Connection Pool not reconnecting after DB failover

I have an application using Tomcat 8.5 connection pool, Java 8, and Multi-AZ AWS RDS MySQL database. In the last years, we had a couple of database issues that lead to failover. When the failover occurred, the pool was always able to detect the…
IsidroGH
  • 2,037
  • 19
  • 27
0
votes
1 answer

Tomcat Connection pool : tomcat-jdbc vs tomcat-dbcp, which is better?

Tomcat is using tomcat-dbcp as a default connection pool strategy, however they are also providing tomcat-jdbc as an alternative. Which connection pooling is better for concurrent load? tomcat-jdbc is having few extra parameter like…
chirag nathwani
  • 13
  • 1
1 2
3
4 5