Stack Overflow
Stack Overflow

Questions tagged [dbcp]

27 questions
46
votes
13 answers

HikariPool-1 - Connection is not available, request timed out after 30000ms for very tiny load server

I have a small Java application for testing purposes. I have moved to hikari recently. What I notice is that I keep getting this error. java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after…
user8012596
  • 693
  • 1
  • 8
  • 16
5
votes
2 answers

Concurrency logging to sql DB - threads not running parallel

I tested this with 2.14.0 and 2.13.3 I used the JDBC Appender in combination with the DynamicThresholdFilter and tried out a normal Logger and also the AsyncLogger. In the JDBC Appender i also tried out the PoolingDriver and the ConnectionFactory…
Stefan Höltker
  • 311
  • 5
  • 21
4
votes
0 answers

SQL Server returned an incomplete response. The connection has been closed.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException:

We are in the process of moving to Azure SQL Server from Oracle DB for our Spring Batch application that runs for few hours with 50 Threads. Below is my JDBC Configuration MSSQL_DRIVERCLASSNAME:…
One Developer
  • 99
  • 5
  • 43
  • 103
2
votes
1 answer

Getting error on shutdown of simple Micronaut CLI data application

I have just developed a small micronaut CLI app to explore Micronaut jdbc and sql features. Following are the dependencies, dependencies { annotationProcessor("info.picocli:picocli-codegen:4.2.0") …
jatanp
  • 3,982
  • 4
  • 40
  • 46
1
vote
1 answer

Cannot get a connection, pool error Timeout waiting for idle object while using DBPC2

the pom.xml is following: org.apache.commons commons-dbcp2 2.9.0 and the datasource configuration is: public Connection getConnection(){ …
woxiangbo
  • 113
  • 1
  • 1
  • 8
1
vote
0 answers

how to reload password in dbcp basic datasource

dbcp2 basic datasource is being used for one of our java applications and database password is set by calling this setter setPassword(final String password) passwords are stored in AWS secrete manager, and now there is a password rotation logic…
scoder
  • 2,451
  • 4
  • 30
  • 70
1
vote
1 answer

Java and MariaDB connection drivers errors

I can connect Java and Maria DB with JDBC and DriverManager. It works. I can write line in my database's tables ect.... But with "BASIC DATA SOURCE" i can't connect to MariaDB. I use openJDK 15 on FEDORA. I don't understand why i can't connect to…
Quentin Genet
  • 155
  • 2
  • 3
  • 15
1
vote
1 answer

java connection pool and autocommit status

Quick question that I can't find an answer to. If you have a connection pool where some connections may have been set to autocommit false. If those are returned and retrieved from the pool. Is autocommit set back to true (the default)? Or is it that…
sproketboy
  • 8,967
  • 18
  • 65
  • 95
1
vote
1 answer

Do we need to close DBCPConnectionPool object in Custom Processor Or Is it handled by Controller Service itself?

I have created a Custom processor which take care of saving some records in mysql database. For setting up mysql database i am using DBCPConnectionPool object in my custom processor which does work of saving data to database tables correctly, But i…
Varun Soni
  • 55
  • 6
1
vote
1 answer

cannot find symbol ds.setMaxActive(MAX_ACTIVE);

I am trying to Configure Oracle DataSource Using Commons DBCP but its throwing subject error I am working on CentOS private String driverClassName="oracle.jdbc.driver.OracleDriver" ; private String url="jdbc:oracle:thin:@164.173.28.18:1521:XE"; …
user987376746090
  • 45
  • 8
1
vote
0 answers

What are the steps to identify connection leak when using DBCP, JDBCTemplate and ScheduledExecutor?

We are creating a Spring boot web app. DB : JDBC Template and DBCP connection pool. Java code: A runnable is called in Executors.newSingleThreadScheduledExecutor(); Time interval: 2 min The code in runnable hits DB using…
Vijay Kumar Chauhan
  • 319
  • 4
  • 14
1
vote
2 answers

Tomcat ignores removeAbandonedTimeout and closes connections in pool

I am working on tomcat 7.0 with a JDBC connection to DB2 on an as400 using the commons dbcp. As soon as I put a load on the server, it immediately opens and closes connections to the database ignoring the 30 minute removeAbandonedTimeout setting I…
Andrew Lavespere
  • 13
  • 1
  • 1
  • 4
1
vote
2 answers

DBCP Connection pooling

Could I please ask whether the below code would be correctly using connection pooling (DBCP) ? My utility class providing the BasicDataSource is as below (almost identical to the apache example) public class DatabaseUtility { private static…
nullPointer
  • 4,419
  • 1
  • 15
  • 27
0
votes
0 answers

Unclosed JDBC Connection issue in Spring DBCP Environment

this service is spring 4.3.16.RELEASE and use DBCP. no error in jboss server.log. however, APM(Application Performance Management) system detects the Unclosed JDBC Connection when every execute query. on the other hand, I think about "Unclosed JDBC…
유재영
  • 1
  • 1
0
votes
0 answers

DBCP connection property name issue

I am making a simple program using MyBatis. At this time, I am having difficulty applying DBCP to the configuration file(mybatis-config.xml) containg DB connection information.
na_dev
  • 1
  • 1
1
2