Getting GenericJDBCException while fetching records from Query
While accessing MySQL database through Java 8 using Spring 2.6.4, in the DELETE operation executed through native query using JPA as below
@Query(value = "DELETE FROM temp a WHERE a.id =: id", nativeQuery = true) Object deleteid(Integer slotid); //service Object object = oClass.deleteid(id.getId());
i am getting error as
org.springframework.orm.jpa.JpaSystemException: could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet
I had successfully executed the query on the PhpMyAdmin, it is running fine. Also, i had used the similar line of codes in my other programs also, not sure what is the mistake i am making here. Pls help.