我正在从 Oracle 数据库调用函数并面临以下异常:
org.hibernate.engine.query.ParameterRecognitionException:混合参数策略 - 仅使用命名、位置或 JPA 序数策略之一
这是我的用户.java entity.
@Entity
@Table(name = "users", schema = "myschema")
@javax.persistence.NamedNativeQuery(name = "getPass", query = "{? call = his.get_abc(:mrno)}", resultClass = User.class, hints = {
@javax.persistence.QueryHint(name = "org.hibernate.callable", value = "true") })
public class User {
@Id
@Column(name = "USERID", nullable = false)
private String userid;
@Column(name = "MRNO")
private String mrno;
private String username;
private String password;
private String fullName;
// Getters and Setters are written.
}
这就是我从我的服务类中调用此函数的方式。
public boolean validateUser(String mrno, String password) {
String completeMrno = utils.getMedicalRecordNumber(mrno);
EntityManagerFactory factory = Persistence.createEntityManagerFactory("his-dev");
EntityManager entityManager = factory.createEntityManager();
Query query = entityManager.createNamedQuery("getPass"); // <- this line is raising exception.
query.setParameter("mrno",completeMrno);
List<?> results = query.getResultList();
}
那么,为了调用返回字符串的 Oracle 函数,需要进行哪些更改。
谢谢。如果需要更多信息,请告诉我。
下面是如何使用 JPA 调用该函数的示例:
Object result = entityManager.createNativeQuery("SELECT his.get_abc(:mrno) FROM DUAL")
.setParameter("mrno", completeMrno)
.getSingleResult();
String value = new String(result);
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)