DB2 Stored Procedure Report

danatten · **Joined:** Wed Apr 13, 2005 7:32 pm **Posts:** 11

Gidday,

I've been looking at Hibernate3 for use with Stored Procedures and managed to get it working nicely with SQL Server, however, I'm also interested in using Hibernate3 with DB2 but have found that the DB2Dialect does not support resultsets via stored procedures - org.hibernate.dialect.Dialect#registerResultSetOutParameter.

I'm just wondering if there is any plan for this and when it might be implemented?

Cheers,
Dan.

danatten · **Joined:** Wed Apr 13, 2005 7:32 pm **Posts:** 11

Well I've found two solutions to my problem:

1) Don't include the callable="true" attribute on the <sql-query /> declaration.

2) Use the SQLServerDialect because DB2 UDB can return resultsets in a similar fashion to SQL Server.

Hope this helps people.

Cheers,
Dan.

max · **Posted:** Thu Apr 28, 2005 1:47 am

do they work without setting callable=true ? *weird*

could you add this to the jira since just using sqlserverdialect will break alot of other stuff on db2 so we need to adapt the db2 dialect - thank you.

danatten · **Joined:** Wed Apr 13, 2005 7:32 pm **Posts:** 11

Yeah, a bit wierd.

I have added this to JIRA http://opensource.atlassian.com/projects/hibernate/browse/HHH-411

I may have another bug to do with calling an update procedure. Will post shortly and add to JIRA if needed.

Cheers.