[#13381] - After updating Percona Mysql 5.7 to 8.0 getting error like "Caused by: java.sql.SQLException: Prepared statement needs to be re-prepared"

Posted by vaghelabhavesh32 on January 21, 2021 - 4:34am
Category:
Bug report
 Priority:
High
 Status:
Closed
Project:
JasperReports® Server
 Severity:
Critical
 Resolution:
No Change Required
Component: Reproducibility:
Always
 Assigned to:
Subscribe
0

Hello ,

i am getting error "Caused by: java.sql.SQLException: Prepared statement needs to be re-prepared" while fetching report from MySQL version 8.0
same report was working fine while fetching from MySQL version 5.7

also while I run same query directly from database it is working fine but while fetching report from same query getting above error.

Regards,
Bhavesh Vaghela

AttachmentSize
Image icon jasper_server_error_log.png61.76 KB
v6.4
JasperServer
vaghelabhavesh32's picture
vaghelabhavesh32
3
Joined: Sep 24 2020 - 3:09am
Last seen: 2 months 3 weeks ago

1 Comment:

#1Posted by vaghelabhavesh32 on January 27, 2021 - 3:09am
  • Resolution:Open» No Change Required
  • Status:New» Closed

The issue is resolved after restarting the physical server

Feedback
randomness