我正在尝试使用hibernate在oracle中执行存储过程。当我从hibernate调用过程时,该过程被调用,但之后它向我显示了异常
ERROR: Cannot perform fetch on a PLSQL statement: next
这是我在oracle中的存储过程:
create or replace PROCEDURE GETREGISTRATIONRECORDS
(
REGID IN NUMBER
)
AS
MY_CURSER SYS_REFCURSOR;
BEGIN
OPEN MY_CURSER FOR
SELECT * FROM REGISTRATION
WHERE ID = REGID;
END GETREGISTRATIONRECORDS;
在休眠状态下,我已按如下所示调用了此过程:
注册.java
@NamedNativeQueries({
@NamedNativeQuery(
name="callRegistrationProcedure",
query="call GETREGISTRATIONRECORDS(:regID)",
resultClass=Registration.class)
})
@Entity
public class Registration {
......
}
在RegistrationDao.java中,我具有以下功能
@SuppressWarnings("unchecked")
public List<Registration> getFirstName(int id)
{
Query query = SQLFactory.getSession().getNamedQuery("callRegistrationProcedure").setParameter("regID", id);
List<Registration> result = query.list();
for(int i=0; i<result.size(); i++){
Registration stock = (Registration)result.get(i);
System.out.println(stock.getFirstName());
System.out.println(stock.getLastName());
}
return result;
}
但是,当我执行我的应用程序时,出现以下错误:
Hibernate: call GETREGISTRATIONRECORDS(?)
Apr 09, 2015 10:45:24 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
WARN: SQL Error: 17166, SQLState: null
Apr 09, 2015 10:45:24 AM org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
ERROR: Cannot perform fetch on a PLSQL statement: next
Apr 09, 2015 10:45:24 AM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet [dispatcher] in context with path [/SpringHibernateWebApplication] threw exception [Request processing failed; nested exception is org.hibernate.exception.GenericJDBCException: Cannot perform fetch on a PLSQL statement: next] with root cause
java.sql.SQLException: Cannot perform fetch on a PLSQL statement: next
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:192)
我已经通过这些链接,但是没有找到解决方案
java.sql.SQLException:无法对PLSQL语句执行访存:下一步。在休眠状态
Hibernate 4.2.18使用ojdbc6(11.2.0.2)在oracle 11g上进行存储过程调用将导致无法对PLSQL语句执行提取:next
因此,请帮助我获得解决方案。
我得到了解决方案,以下是上面代码中所做的更改
oracle中的存储过程:
create or replace PROCEDURE GETREGISTRATIONRECORDS
(
MY_CURSER OUT SYS_REFCURSOR,
REGID IN NUMBER
) AS
BEGIN
OPEN MY_CURSER FOR
SELECT * FROM REGISTRATION
WHERE ID=REGID;
END GETREGISTRATIONRECORDS;
在Registration.java中
@NamedNativeQuery(
name="callRegistrationProcedure",
query="call GETREGISTRATIONRECORDS(?,:regID)",
callable=true,
resultClass=Registration.class)
@Entity
public class Registration {
......
}
无需进行任何更改即可RegistrationDao.java
得到所需的输出。从Oracle数据库成功获取记录。
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句