error while executing stored procedure from java code
Posted by: Magesh Balasekaran
Date: December 29, 2020 05:44AM

I am getting the below error message when the stored procedure is getting called from my java code.

mysql server version: 5.6
jdbc connector: mysql-connector-java-5.1.16-bin.jar


Error retreiving database metadata; nested exception is org.springframework.jdbc.support.MetaDataAccessException: Could not get Connection for extracting meta data; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot create PoolableConnectionFactory (The connection property 'autoReconnect' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'true,noAccessToProcedureBodies=true' is not in this set.

i have given the permission to execute the procedure. Not sure why i am getting this error. Please help me to resolve this issue.

Options: ReplyQuote


Subject
Written By
Posted
error while executing stored procedure from java code
December 29, 2020 05:44AM


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.