Solved

How to call DB2 procedure using Hibernate

Posted on 2009-06-30
1
1,389 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
Comment Utility

 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
commonTwo  challenge 63 98
bunnyEars challenge 6 62
Getting missing rows 16 31
thymeleaf natural templating vs JSP 2 23
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
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…
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.

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now