如何使用会话工厂从 Java Hibernate 执行 sql 存储过程? [英] How to execute a sql stored procedure from Java Hibernate using Session Factory?

问题描述

我无法使用会话工厂从 java hibernate 调用我的存储过程

I am unable to call my stored procedure from java hibernate using session factory

我编写了一个 sql 程序，它接受 5 个参数并返回一个在 MS SQL Studio 中运行良好的结果集

I have written a sql procedure which takes 5 parameters and return a result set which works fine in MS SQL studio

EXEC SlaGrid @appID=245,@fromYear=2012,@toYear=2013,@fromMon=1,@toMon=12   --- sql

EXEC SlaGrid @applID=:applID,@fromYear=:fromYear,@toYear=:toYear,@fromMon=:fromMon,@toMon=:toMon  --hibernate

我正在为上述查询设置参数

i am setting the parameters for the above query

String queryString = "EXEC SlaGrid @applID=:applID,@fromYear=:fromYear,@toYear=:toYear,@fromMon=:fromMon,@toMon=:toMon"

Query query = sessionFactory.getCurrentSession().createSQLQuery(queryString);

//set query parameters here

query.list()    --- giving sql grammer exception

推荐答案

我简单地通过以下代码解决了它...只需在 CSV 中传递参数.谢谢大家的帮助..

I solved it simply by the following code...Just pass the parameters in CSV.Thanks for the help guys..

String queryString = "SlaGrid 245,2012,2013,1,12"

Query query = sessionFactory.getCurrentSession().createSQLQuery(queryString);

query.list();

完美的作品:)

这篇关于如何使用会话工厂从 Java Hibernate 执行 sql 存储过程?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！