• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to call Stored Procedure in hibernate which doesn't return results from any specific tables  RSS feed

Niranjan Welankiwar
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,

I have a stored Procedure which doesn't return result set from any specific tables. Below is the SP :

PROCEDURE [dbo].[spCMTGetClientSummaryRegion]
SELECT 'North East' AS 'Region', '1' AS 'ActiveClients', '3.03%' AS 'Percentage', '1' AS 'Prospects', '3.03%' AS 'TotalPercentage'

Output :

Region ActiveClients Percentage Prospects TotalPercentage
North East 1 3.03% 1 3.03%

Now, I want to call this SP from Hibernate and store the result in a java bean object. Below is the hibernate call:

<sql-query name="callCMTGetClientSummaryRegion" callable="true">
<return alias="Client" class="ClientSummaryRegionVO"/>
{call spCMTGetClientSummaryRegion() }

Where my bean object is ClientSummaryRegionVO. Please help.

Thanks in advance.

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!