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

Hello,

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


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


Sorry, only registered users may post in this forum.

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.