I am very new in Spring world. I was using application.properties to set different port values. How can I comment some code in application.properties file?

I've got a MySQL table with Foos. Each Foo has a numeric non-unique code and a name. Now I need to find if any Foo with one of certain codes happens to have a name that starts with a given string. ...

I have a class that looks like this: public class MyClass { private final SimpleJdbcCall simpleJdbcCall; public MyClass(final DataSource dataSource) { this(new JdbcTemplate(dataSource)); } ...

I wonder if any one could help me with this. I encountered an issue when I tried writing code with Spring JDBC. When I ran the server, I got the message like I mentioned in the title. I have google...

Firstly, I can't use the declarative @Transactional approach as the application has multiple JDBC data-sources, I don't want to bore with the details, but suffice it to say the DAO method is passed...

I am working on spring boot on both command line runner and web application. Both applications require to be implemented with oracle wallet, so I implemented the oracle wallet. The command line run...

I'm using Spring with Java. I need to return a Stream of objects from the database query (I use ObjectMapper to map them to JSON). The query results can be quite large (over 500k objects) so I don'...

On Using Spring JDBC which works very well and has some improvements over JPA when using Batch processing. I would love to learn why to use Spring Data JDBC when you already have Spring JDBC. I wou...

JdbcTemplate.update() returns number of rows affected - so you not only know that delete/update was sucessfull, you also know how many rows were deleted/updated. What will be the return value if I...

I have to be able to rename the default Spring Session table and found the following configuration options in the spring session documentation. spring.session.jdbc.schema=classpath:org/springfr...

I cannot figure out why I am getting "Invalid column name" here. We have tried a variant of the sql directly in Oracle, and it works fine, but when I try it using jdbcTemplate then something is wr...

I am having issues saving my entity that has a Instant value using the NamedJdbcTemplate. I receive the exception listed below and I am trying to determine the best way to resolve this. Please advi...

I try to use handle query for updating table in the SQL database. Code: @Autowired private ProducerRepository producerRepository; public void update(Producer producer){ String name = produc...

I have two related stored procedures that involve user-defined types. The first accepts an object ID and returns the corresponding instance of a user-defined type. The second accepts an instance of...

In our Server we are using scheduler to perform a particular tasks. There are already many scheduler running on the server which are working smoothly and Perfrorming DB Operations without any hurdl...

I have a Spring Boot application (v2.1.5) that uses JPA (Hibernate) to connect to a Postgres DB. Spring Boot uses HikariCP for connection pooling. In my production environment, I see the following ...

I am using the following Java code to run SQL script: @SpringBootApplication public class Application implements CommandLineRunner { @Autowired DataSource ds; @Value("classpath:test.sql") Res...

One simple optimization for SQL is the reuse of prepared statements. You incur the parsing cost once and can then reuse the PreparedStatement object within a loop, just changing the parameters as n...

I am simply trying to see the H2 database content for an embedded H2 database which spring-boot creates when I don't specify anything in my application.properties and start with mvn spring:run. I c...

I am trying to find an easy way to deal with Stored Procedures / SQL returning multiple result sets. I have been using the SimpleJdbcOperations#queryForList() method however this will only return t...

I am starting to develop with springboot and I have been stuck for 2 days. When i launch my app i get this line. 2020-07-08 11:54:46.377 WARN 33224 --- [ task-1] o.h.e.j.e.i.JdbcEnvironmentI...

I have a consumer that can say he doesn't want to process more data. I've looked upon the methods in Spring JdbcTemplate, but I see no way to inform Spring I don't want to process more rows when I...

I have a class that looks like this. I need to populate it from two database tables, which are also shown below. Is there any preferred way to do this? My thought is to have a service class to sel...

I am developing against a PostgreSQL v12 database. I am using SERIALIZABLE transactions. The general idea is that when PostgreSQL detects a serialization anomaly, one should retry the complete tran...

I'm using Jdbctemplate and I need the inserted id of a query. I read that I have to build a particular PreparedStatement and use GeneratedKeyHolder object. The problem is that in my application al...