java 如何从休眠（SQL SERVER）中的存储过程获取输出值

How to get OUTPUT value from stored procedure in hibernate (SQL SERVER)

提问by Constantine Gladky

I have stored procedure in MS SQL Server

我有存储过程 MS SQL Server

CREATE PROC dbo.insertData 
    @param1 nvarchar(11),
    @param2 nvarchar(30),
    @ID bigint OUTPUT
AS 
BEGIN   
    INSERT INTO dbo.Adaptor (Col1, Col2) VALUES (@param1, @param2)
    SET @ID = SCOPE_IDENTITY(); 
END

And I want to get this generated ID as output parameter in java.

我想把这个生成的 ID 作为 java 中的输出参数。

I have created a mapping file

我已经创建了一个映射文件

<sql-query name="insertData" callable="true">
    <return alias="adaptor" class="MyClass">
        <return-property name="id" column="ID" />
    </return>
    { ? = call InsertData(:param1, :param2) }
</sql-query>

and trying to execute it from java

并尝试从 java 执行它

  Query query = entityManager.createNamedQuery("insertData");

            query.setParameter("param1", object);
            query.setParameter("param2", getName());
            // TODO try to use getSingleResult in tests
            List result = query.getResultList();

But I have exception java.sql.SQLException: Parameter #3 has not been set

但我有异常 java.sql.SQLException: Parameter #3 has not been set

If I remove ? = I got

如果我删除 ? = 我得到了

java.sql.SQLException: Procedure or function 'insertData' expects parameter '@ID', which was not supplied.

java.sql.SQLException：过程或函数“insertData”需要未提供的参数“@ID”。

Has anyone any idea how code/mapping file should look like? Thanks in advance

有谁知道代码/映射文件应该是什么样子？提前致谢

回答by NimChimpsky

Query query = session.createSQLQuery(
    "CALL GetStocks(:stockCode)")
    .addEntity(Stock.class)
    .setParameter("stockCode", "7277");

List result = query.list();
for(int i=0; i<result.size(); i++){
    Stock stock = (Stock)result.get(i);
    System.out.println(stock.getStockCode());
}

from here

从这里