Eclipse Community Forums: EclipseLink » Retrieve storedprocedure messages using JPA

Help

Home

Home » Eclipse Projects » EclipseLink » Retrieve storedprocedure messages using JPA

Show: Today's Messages :: Show Polls :: Message Navigator

Retrieve storedprocedure messages using JPA [message #782393]

Mon, 23 January 2012 16:35

Sridhar Baratam

Messages: 22
Registered: September 2011

Junior Member

Hello All:

I have a stored procedure which prints messages. I am using JPA named query to execute the same. However, I could not find a construct within JPA that will allow me to capture the messages from the stored procedure.

Here is my sample procedure:
********************************
create proc test
@text varchar(255)
AS
declare
@col int
SELECT @col=col
FROM table
WHERE text=@text

IF @@error != 0 BEGIN
print 'Invalid text'
return -100
END
return 1
go
********************************

How do I get the message 'Invalid text' using JPA?

I appreciate all your help.

Thanks
Sridhar

Report message to a moderator

Re: Retrieve storedprocedure messages using JPA [message #783859 is a reply to message #782393]

Thu, 26 January 2012 15:48

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

What database are you using? I don't thin print is in any way returned, it just prints something on the server. You need to either throw an error, or return an error message using an output parameter.

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	Retrieve storedprocedure messages using JPA
Next Topic:	ReadObjectQuery with setSelectionId=null has undeterministic behavior

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 23 05:45:23 GMT 2017

.:: Contact :: Home ::.