I have a spring-boot application on the same host as the Maria DB and both are running fine for some time. But between 12 hours and 2 days it seems that the spring boot application looses the conne...

I have been trying to get Quartz to work while using R2DBC in spring boot. So far, I have not figured out how to do this. This is because when a JDBC DataSource is created, it tries to initialize m...

To implement data access code in our application we need some framework to wrap around jdbc (ORM is not our choice, because of scalability). The coolest framework I used to work with is Spring-Jdb...

I need to build a spring boot application which exposes a REST endpoint to export a huge database table as CSV file with different filter parameters. I am trying to find an efficient solution to th...

I am using below code while inserting a row into database(oracle 10g xe,jar: ojdbc14.jar) String sql = "INSERT INTO SPONSOR_TB(ID,NAME,INDUSTRY_TYPE,IS_REPORTING_SPONSOR,IS_NOT_SOLICITE) VALUES(SE...

The question is about the best practice usage for RowMapper in master/detail scenarios where we want to eagerly fetch details using spring jdbc. Assume that we have both Invoice and InvoiceLine cl...

Setup I have an app using Spring 4.3, JdbcTemplate, Hibernate 5 and MySQL 8. I have implemented multitenancy in hibernate per schema where i switch schemas using using hibernates multitenancy mech...

I want to know what actually happens when you annotate a method with @Transactional? Of course, I know that Spring will wrap that method in a Transaction. But, I have the following doubts: I hea...

I am passing parameters to Query using NamedParameterJdbcTemplate . But am getting trace details as a warning and parameter binding is not showing.Main problem for is it is showing the executing sq...

I have my application.properties set up like this : spring.datasource.username = root spring.datasource.password = root spring.datasource.url = jdbc:mysql://localhost:3306/dbname?useUnicode=yes&am...

I'm trying to connect to MySql (=MariaDB) on the localhost (lets call it A) from a tomcat webapp using Hibernate, but keep getting Communication link failure (the full exception trace attached belo...

Hi I'm trying to use HikariCP with Spring for connection pool. I'm using jdbcTempLate and JdbcdaoSupport. This is my spring configuration file for datasource: <bean id="dataSource" class="com....

I'm executing the following query using NamedParameterJdbcTemplate with a single parameter. DDL For Table create table TEST_TRANS ( DESCRIPTION_2 float, AMOUNT_STR varchar(255), DESCRIPTION va...

I made this simple application to connect to the MySQL database and I'm getting this error: org.springframework.jdbc.core.JdbcTemplate In my configuration (com.kubamadry.dao.MySqlStudentDao):...

We are developing microservices using java (Spring and Spring Boot), and the access to our Oracle DB is done via the JDBC Oracle Driver. The problem is that our DBAs can only see on the Oracle sid...

I am configuring an OAuth2 authorization server in a Spring project. Here is configuration. @Override public void configure(ClientDetailsServiceConfigurer clients) throws Exception { clients....

I am looking for a way to intercept the connection that JDBCTemplate creates internally i.e. the connection that is created when the function getConnection() is called by JDBCTemplate. ex: if I u...

To make best use of the java8 stream and Spring4, I use the Stream API as follows on a JDBC resultSet that comes from Springs jsdbRestTemplate (code shortened and simplified): public <T&g...

How can I connect to multiple databases which are non-identical on the fly (loading the type and connection info of the DB from my DB) using Spring? what I am trying to build? I am building a Spri...

I have the following method that I use with Spring JDBC public String getState() { String stateLink = template.queryForObject( "select state_url from state_scrape_queue where in_use = false ORDE...

I am trying to use two datasources with my SpringBoot application and can't get the second datasource to autowire. I have tried many things but this is the closest I have come: My Yaml file: spri...

I am trying log SQL queries with params for Spring Boot JDBC but it is not printing the details in log.I am using Spring Boot 1.5.8 version.Please help me to solve this. application.properties: s...

I have a Spring data repository: @Repository interface SomeRepository extends CrudRepository<Entity, Long> { Stream<Entity> streamBySmth(String userId); } I am calling that method i...

In Spring, what is the difference between using DriverManagerDataSource and SimpleDriverDataSource for creating a new datasource given its driverClassName, url, username and password? For example ...

Can someone point out any mistake in my following code of Spring Jdbc Template? When I click delete, the record is not getting deleted and there are no errors showing. public void delete(String id)...