Getting GenericJDBCException while fetching records from Query

1 Answers
255 Views
0 Likes

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.