Empty resultset returned by JDBC Connection
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?
Subject
Written By
Posted
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.