I am trying to configure DB2 connection with DB2JDBC Type4 drivers. But I am getting this error. Exception in thread "main" com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][2...

I've been searching around and potentially the closest I've found something is this Stack Overflow thread, but it still doesn't answer my question. Even with the latest copy of spring (as of writin...

I am working now with oracle and spring jdbc but I don't want to use the schema in my sql statements: Example: Select * from SCHEMA.table Is there any way to set default schema in application.pr...

I have successfully developed a prototype using Spring Boot 1.0.2.RELEASE (was 1.0.1.RELEASE until today). I have searched and searched and tried solutions like: Spring Boot jdbc datasource autoco...

I am trying to use hsqldb-2.3.4 to connect from Spring applicastion. I created data base using the following details Type : HSQL Database Engine Standalone Driver: org.hsqldb.jdbcDriver URL: jdbc...

ERROR: 2018-11-12 18:25:31.221 INFO 3028 --- [ Thread-3] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated... 2018-11-12 18:25:31.223 INFO 3028 --- [ Thread-3] com.zaxxer.hi...

Background I'm using Oralce as database and H2 Embedded in-memory database for integration tests. I've created some tables in H2 and was able to get some inserted data. However, I could not retri...

I am working on the project which used ORACLE 12c db as back-end. and My application is build in java 8. It was working fine since last few month. But suddenly client got an error SQL Error: 1741...

I'm currently working on a Vaadin spring application. According to the app specifications, authentication/authorization of the users must be completed by querying database via jdbcTemplate. How to ...

Iam calling a stored procedure from my Spring DAO class using JdbcTemplate. My problem is that, stored procedure returns multiple tables. Is there a way to access multiple tables using Spring JdbcT...

While jdbcTemplate.batchUpdate(...) is running I can see DB row count is increased gradually(by running count(*) in the table), initially 2k then 3k and goes till 10k. 2k and 3k are not exact numbe...

I am learning about the wonders of JdbcTemplate and NamedParameterJdbcTemplate. I like what I see, but is there any easy way to see the underlying SQL that it ends up executing? I'd like to see thi...

Event though the built-in H2 EmbeddedDatabaseConfigurer provides a JDBC connection with DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=false options set, the annoying exception is caused by AbstractEmbeddedDat...

I have a table with an auto incremented primary key and also a unique key: CREATE TABLE `product` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `canonical_url` varchar(750) CHARACTER SET latin1 NOT N...

I'm using Postgresql and spring boot 2.0.4. The below error is thrown when trying to execute the queries one after the other. I've executed the following query, and the count keeps on increasing. ...

I want to have some specific number of connections available to be used before my microservice starts. I am using Hikari Pool and Spring Boot. I am using the loop for specific number and calling &q...

What is the correct way to invoke stored procedures using modern day (circa 2012) Spring JDBC Template? Say, I have a stored procedure that declares both IN and OUT parameters, something like this...

I have two tables: Customer (parent) and Orders (child). Both are mapped by customerId (customer_id :unique key, in both parent & child). In code in some Impl class, I'm saving data after setti...

I am not able to figure out how to implement this. Any help and/or pointers will be greatly appreciated. Currently, my Java/Spring application backend is deployed on EC2 and accessing MySQL on RDS...

I have been using JdbcTemplate very happyly but then I got convinced to use NamedParameterJdbcTemplate. However not enjoying this so far sometimes or all the times. Lets say I have a Person class ...

How can I pass multiple parameters in jdbcTemplate queryForInt to get the count. I have tried this, Integer count = this.jdbcTemplate .queryForInt("select count(name) from table_name where parame...

My application is build with spring-webmvc and spring-jdbc without spring-boot. In my application.properties I have: spring.h2.console.enabled=true spring.h2.console.path=/h2-console datasource.db...

Currently I'm setting autocommit to false in spring through adding a property to a datasource bean id like below : <property name="defaultAutoCommit" value="false" /> But i need to add i...

I have a stored procedure that works fine in the MySql workbench but when it is run by Spring, using the ResourceDatabasePopulator, it fails with a syntax error. Reading around there are similar is...

Hi, we are trying to upgrade 2.0.202 from 1.4.200. We are getting an error related to running our tests. While persisting data we are getting below error. Any suggestions? Caused by: org.h2.jdbc....