Solved

How to call DB2 procedure using Hibernate

Posted on 2009-06-30
1
1,402 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
dividesSelf challange 15 114
strDist challenge 35 97
eclipse formatting 6 74
tomcat administrtor 12 34
I had a project requirement for a displaying a user workbench .This workbench would consist multiple data grids .In each grid the user will be able to see a large number of data. These data grids should allow the user to 1. Sort 2. Export the …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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.

863 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

22 Experts available now in Live!

Get 1:1 Help Now