I am working on developing micro services for a monolithic application using spring boot + spring cloud + spring JDBC. Currently, the application is connecting to a single database through tomcat ...

Good morning in my timezone I already have follow this two Stack Overflow questions : Spring Boot Using Embedded Tomcat with JNDI and Howto use JNDI database connection with Spring Boot and Spring ...

Can someone point me to some resources about the performance comparison among the different Query DSL libraries available for using with Java, like: Querydsl, jOOQ, JEQUEL, activejdbc, iciql and et...

I am new to Spring 3.0 . For DAO access i have choosen SpringJDBC. SpringJDBC provides JDBC Template and SimpleJDBCTemplate . Which one is best. I read in some of the forum SimpleJDBCTemplate going...

I am using Spring's NamedParameterJdbcTemplate to perform an insert into a table. The table uses a NEXTVAL on a sequence to obtain the primary key. I then want this generated ID to be passed back t...

I am struggling trying to find a solution to this and I'm hoping that someone out there can help. We have a Spring/Hibernate/Wicket/Tomcat webapp. We use Spring Batch for executing jobs in the bac...

I am connecting to MySQL over SSL from my Java application. I have configured MYSQL to support SSL and generated client certificates. I have imported server CA certificate and client certificate in...

Since switching from Tomcat CP (spring boot 1 default) to Hikari (spring boot 2 default) we've started seeing many instances of: EXCEPTION STACK TRACE: ** BEGIN NESTED EXCEPTION ** javax.net...

I'm new to postgres but am attempting to call a procedure in Postgres 11 (new "procedure" not a "function"), calling from java as a spring SimpleJDBCCall (using Postgresql-42.2.5 jdbc driver). Howe...

I was wondering if there is a specific way to override database connection timeout in the properties file in my Java web project? I am using Hibernate, Spring, and MySQL DB. I have tried several di...

I am building a Spring Boot application that is multithreaded utilizing the Spring @EnableAsync and @Async annotations. When I run the application with a single thread (CorePoolSize 1, MaxPoolSize ...

What is the main difference between Spring JDBC VS JDBC?

I wanted to do commit and rollback using jdbcTemplate. My question is based on this thread How do I commit or rollback, should I do it on jdbcTemplate like jdbcTemplate.commit(); jdbcTemplate.ro...

I'm using a Spring JdbcTemplate without a "transactionManager" since I have mostly select to do. When I try to call select queries from JUnit, it works, but when I try to call an "update", it free...

I am developing springboot-springsession-jdbc-demo. When I simply run the code I get the following error. It looks to me some property must need to set in application.properties in order create the...

I was going through data access technologies supported by Spring, and I noticed that it mentions multiple options and I am not sure about the difference among them: Spring-DAO (http://docs.spring...

I'm curious what is the difference between the spring-jdbc (what I missing in the newest spring release) and spring-data-jdbc. Is there a difference or just a renaming (in the repositories I don't ...

I know this is probably a duplicate and, ironically, before I started reading here and there about it, I thought I knew what it was for (needless to say but I'll still say it, please correct ...

I was looking at the reference here. We can do this - String orderSql = "select * from order where id = ?"; jdbcTemplate.query(orderSql, new BeanPropertyRowMapper<>(Order.class), orderId); ...

I would like to know how to properly use jdbc in my case. The saveLinkHistory column is a bit(1) type in mysql. public boolean getIsSavedLinkHistory(String name) { String sql = "select saveLinkH...

I need to establish DB connectionfailover in SpringBoot application(embedded tomcat) for ibatis with jdbctemplate which uses c3p0 for connection pooling.Below is the applicaiton.properties of my ap...

After switching from spring-boot 1.5.x to spring-boot-2.x, when db connection is down, my spring application tries to reconnect to database constantly. I cannot even call a health check endpoint. ...

I have a SpringBoot app, where I use jdbcTemplate to insert a row to a mssql int numOfRowsAffected = remoteJdbcTemplate.update("insert into dbo.[ELCOR Resource Time Registr_] " + "( [Entry No_], ...

I have just upgraded Spring/SpringBoot dependencies and noticed that class JdbcTemplate does not have property "nativeJdbcExtractor" any more. I was able to find the details and background: https...

Here is my oracle procedure specifications CREATE OR REPLACE PACKAGE PKG_RE_FI AS PROCEDURE PRC_RE_FI_DETAILS(P_FAN_NO IN VARCHAR2, P_REF_ID IN TY_APP_REF_ID, P_COMMENTS IN VARCHAR2, P_BILLIN...