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

mysql-connector-java-8.0.12 : getting error for 'Malay Peninsula Standard Time' server time zone

We recently upgraded MySQL from 5.6 to 8. So, as per upgrade instructions,using mysql-java-connector(8.0.12) and new driver class name i.e com.mysql.cj.jdbc.Driver in database url. But Getting below error only for this time zone 'Malay Peninsula…
Ram
  • 423
  • 4
  • 26
0
votes
1 answer

Grails 3.3.3 war deployed on tomcat 8.5 issue with closed jdbc connection

When I run the war file in the container, it appears as the connection dropped on the server side (default idle timeout there is 8h) leads to exceptions (root cause: connection already closed / the last successful package to the server was sent…
0
votes
1 answer

PostgreSQL JDBC ResultSet has 4x the expected rows on single table scan

I am running Tomcat 9.0 with a PostgreSQL 10.2 Database, using the Tomcat JDBC Pool configured with the org.postgresql.Driver. I have the following simple query, which scans a small reference table for values: SELECT DISTINCT quality_rank,…
dtgman
  • 1
  • 2
0
votes
1 answer

Multiple connection pools on the same database

In my application, I need to configure 2 databases during start up. They are created as Tomcat JDBC pools - org.apache.tomcat.jdbc.pool with seperate pool properties. If I configure such that both the database URLs, user name and password are same…
Saran
  • 213
  • 2
  • 5
  • 13
0
votes
1 answer

Tomcat JDBC Pool - timeBetweenEvictionRunsMillis is -1

What happens when timeBetweenEvictionRunsMillis of Tomcat 8 JDBC connection pool is set to -1? The tomcat wiki says it should not be less than 1 second: timeBetweenEvictionRunsMillis - (int) The number of milliseconds to sleep between runs of the…
Saran
  • 213
  • 2
  • 5
  • 13
0
votes
1 answer

Tomcat Jdbc Connection Pool active connection

We have a spring-boot application which uses embedded tomcat for deployment and default tomcat-jdbc connection pooling with MySQL back-end with no customization for MySQL or Tomcat side. The app has a few schedulers that runs mostly during specific…
Divs
  • 1,578
  • 2
  • 24
  • 51
0
votes
2 answers

Spring boot JPA application NOT working with HikariCP configuration

We have configured our spring boot(v1.5.1)-jpa application to point to HikariCP but still due to some weird reason the application is still pointing to tomcat-jdbc pool, the default used by spring-boot instead of Hikari-CP. I have mentioned the…
Gururaj Nayak
  • 636
  • 1
  • 9
  • 18
0
votes
1 answer

unable to remove tomcat jdbc dependency

I am building a spring-boot application using an alternative to tomcat related stuff (jetty instead of tomcat and hikariCP instead of tomcat-jdbc) and want to exclude them from my dependencies written in pom.xml I did that for 2 of the packages as…
comiventor
  • 3,922
  • 5
  • 50
  • 77
0
votes
0 answers

tomcat datasource and jdbctemplate

I have been earlier injecting datasource (and using jdbctemplate for db operations) using spring DI individually for my two web application but then i consider its better to use datasource and connection pool on the Tomcat Level. So, now i am…
Ankit
  • 2,126
  • 4
  • 33
  • 53
0
votes
1 answer

Aspect fails with ClassCastException trying to pointcut Tomcat DataSource getConnection

I need to execute several initialization statements on each borrowed connection from a Tomcat JDBC Pool. I cannot use JDBCInterceptors because pool is shared with other applications that won't need said initilization. I'm using Spring Boot 1.4.4,…
0
votes
0 answers

org.apache.tomcat.jdbc.pool DB password decryption

We are using tomcat jdbc pool in our project. The connection pool configuration is
0
votes
0 answers

Tomcat 8: determine connection pool

In my context.xml for Tomcat 8 (Debian) I define the following resource: ...
broeni
  • 97
  • 1
  • 8
0
votes
1 answer

unexpected Spring Boot metrics for org.apache.tomcat.jdbc.pool.DataSource

I'm using Spring Boot with a pooled datasorce datasource: type: org.apache.tomcat.jdbc.pool.DataSource driverClassName: com.mysql.jdbc.Driver url: ... username: ... password: ... tomcat: max-active: 50 max-idle: 50 …
Dominik
  • 1,332
  • 1
  • 15
  • 28
0
votes
1 answer

How to load tomcat jndi resource/context on a specific web app deploy event

I have a web application which gets database connection via a jndi resource tag in either tag in server.xml or tag in context.xml. But even either of the cases, the resource gets invoked for every web app in the…
ViS
  • 1,357
  • 1
  • 17
  • 36
0
votes
1 answer

Use Tomcat JDBC Pool as Hibernate Connection pool

In stand alone application which is build on top of hibernate I like to use Tomcat JDBC Connection Pool. My guess is that i need to add some configs in hibernate.cfg.xml. Can someone guide me how to configure hibernate to use "Tomcat JDBC Connection…
Aram Arabyan
  • 2,339
  • 1
  • 17
  • 30