hql调用mysql存储过程_如何使用jpa调用存储过程

使用JPA技术是SPRING的新手.

我试图调用mysql 5中编写的存储过程.当我试图使用存储过程获取数据时调用它喷出异常.

org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.QueryException: query must begin with SELECT or FROM: call [call st_proc_getusers()]; nested exception is java.lang.IllegalArgumentException: org.hibernate.QueryException: query must begin with SELECT or FROM: call [call st_proc_getusers()]

我的persistence.xml是

META-INF/persistence-query.xml

com.spt3.pojo.Users

我试过代码是

package com.spt3.dao;

import com.spt3.pojo.Users;

import java.util.ArrayList;

import java.util.List;

import javax.persistence.EntityManager;

import javax.persistence.PersistenceException;

import org.springframework.orm.jpa.JpaCallback;

import org.springframework.orm.jpa.support.JpaDaoSupport;

import org.springframework.transaction.annotation.Transactional;

@Transactional

public class JpaUsersDao extends JpaDaoSupport {

public void getResultsByStoredProcedure() {

List list=(ArrayList)getJpaTemplate().execute(new JpaCallback() {

public List doInJpa(EntityManager em) throws PersistenceException {

javax.persistence.Query query=em.createQuery("call st_proc_getusers()"); // Here the procedure call

return query.getResultList(); // returning result list

}

});

}

}

实际上我不知道如何使用jpa模板调用存储过程.

如何从spring JPA调用存储过程？

请给出解决方案以摆脱这个问题.

解决方法:

public List doInJpa(EntityManager em) throws PersistenceException {

javax.persistence.Query query=em.createNativeQuery("call st_proc_getusers()");

return query.getResultList();

}

标签：stored-procedures,spring,jpa

来源： https://codeday.me/bug/20190610/1209384.html