Empty resultset returned by JDBC Connection
Posted by: Subhankar De
Date: April 25, 2020 10:34AM


We are running MySQL 5.7.27-enterprise-commercial-advanced-log on Linux.

JDBC Driver -mysql-connector-java-8.0.11.jar
Driver Class - com.mysql.cj.jdbc.Driver
JDBC URL - jdbc:mysql://myDB:3306/data?useSSL=false&serverTimezone=UTC
Pool Management- HikariCP 2.6.0
DAO implementation - Spring JDBCTemplate on Spring Boot 1.5.8.RELEASE
OS: Linux

It works as expected but sometimes it will start returning empty resultset. But using MySQL Workbench the query works as expected.

We have update the connector from 5 to 8 and updated the driver also but no luck. It has been a nightmare. Can someone help on this?

Options: ReplyQuote

Written By
Empty resultset returned by JDBC Connection
April 25, 2020 10:34AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.