Solved

How to call DB2 procedure using Hibernate

Posted on 2009-06-30
1
1,421 Views
Last Modified: 2013-11-24
Hi
  I am trying to call DB2 procedure from Hibernate.
  I could not get data. The resultset is returned as null.
  Could anyone help.

Thanks

Hibernate Code
===============
Session session = HibernateUtil.getSessionFactory().getCurrentSession();
Transaction tx = session.beginTransaction();
try {
CallableStatement stmt = session.connection().prepareCall("{? = call SAMPLE.PROCEDURE3()}");
boolean statusFlag = stmt.execute();
tx.commit();
ResultSet rs = stmt.getResultSet();
System.out.println("Test1.main() statusFlag is: "+statusFlag);
}
catch(Exception e)
{
if(tx != null) {
tx.rollback();
}
System.out.println(e.getMessage());
}
finally{
if(session!=null && session.isOpen())
session.close();
}
 
DB2 Procedure
==============
CREATE PROCEDURE SAMPLE.PROCEDURE3 (  )
P1: BEGIN
    DECLARE get_Bank CURSOR WITH RETURN  FOR
    	SELECT ID, BANK_NAME FROM SAMPLE.BANKING;
	OPEN get_Bank;
END P1
 
Data in DB2
=========
ID,BANK_NAME
------------------
1,HDFC
2,CITI
3,AXIS
4,UTO
5,SC
6,SBI
1,HDFC
2,CITI
3,AXIS
4,UTO
5,SC
6,SBI

Open in new window

0
Comment
Question by:ysganta
1 Comment
 

Accepted Solution

by:
ysganta earned 0 total points
ID: 24745158

 Resolved.
 The procedure needs to specify the number of resulsets.

example:
CREATE PROCEDURE SAMPLE.PROCEDURE3 (  )
RESULT SETS 1
P1: BEGIN
DECLARE get_Bank CURSOR WITH RETURN  FOR
SELECT ID, BANK_NAME FROM SAMPLE.BANKING;
OPEN get_Bank;
END P1
 
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
word0 challenge 3 91
table example 4 29
ejb on wildfly 5 20
jsp insert to database example 2 24
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
The viewer will learn how to implement Singleton Design Pattern in Java.
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question