Java Mailing List Archive

http://www.gg3721.com/

Home » user.groovy »

[groovy-user] Groovy JDBC issues

rajnarasimhan

2008-08-20

Replies: Find Java Web Hosting

Author LoginPost Reply

Hi,
I am new to groovy and rite now working in a groovy project. I have been
stuck up with calling a stored procedure from groovy code. I am able to run
the stored procedure but not able to retreive the output from th stored
procedure. i am working on this issue for more than two days. I would be
grateful if any could help me out.

My code is

def row = sql.execute("{call Web_User_Insert(?,?,?,?,?,?,?,?,?,?)}",
                       [webuser.firstName,webuser.lastName,
webuser.username,
                       
webuser.password,webuser.emailAddress,0,0,0,lastInsertId,failureCode])

I am able to run the code and changes are reflected. But my question is when
i run this procedure i need to get back two outputs lastInsertId and failure
code.

please help me out.

Thanks.
--
Sent from the groovy - user mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

  http://xircles.codehaus.org/manage_email


©2008 gg3721.com - Jax Systems, LLC, U.S.A.