File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
REST with Spring (video course)
this week in the
JDBC and Relational Databases
Callable Statement with OUT parameter issue
Joined: Mar 30, 2005
Sep 22, 2010 12:50:47
i have stored proc in DB2 which has 1 IN and 1 OUT parameter , also returns result set .
how can i access the same ( result set wont be returned ,incase validation fails ,in case of validation it returns the code in OUT param )
Thanks, Ganesh Gowtham
Prabhakar Reddy Bokka
Joined: Jul 26, 2005
Sep 24, 2010 04:02:05
The out parameter would be a ResultSet.
Check if the Resultset updated with records after executing the CallableStatement.
If ResultSet is null throw an exception with validation error.
SCJP 5, SCWCD 5
I agree. Here's the link:
subject: Callable Statement with OUT parameter issue
Stored proc insert/update/del in hibernate?
how to insert data in stored procedure from hibernate?
Accessing Return Code Closes RecordSet?
Remove Indentation during Transformation
Connection is closed - error in web service calling DB2 stored procedure
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015