Re: Java exception error in JDBCR4.

What alternative is there to using output parameters to return a status or
result? I still have not found a way to get the return value in Java. I have
googled and looked but can find no example of getting the return status that
is returned when you issue RETURN in the stored procedure.

On Fri, Jul 10, 2009 at 12:04 PM, Scott Klement
<rpg400-l@xxxxxxxxxxxxxxxx>wrote:

hi Alan,

I don't use output parameters from my stored procedures... never liked
that approach, so what I say in this message comes not from experience,
but rather from interpreting the error message you posted.

It sounds like you have to read all of the result sets before the stored
procedure copies it's parameters from it's internal memory to the JDBC
driver's memory. Probably because the values aren't set until the
stored procedure ends.

So basically you need to read any/all of the result sets FIRST... then
call JDBC_GetInt().

Good luck

Alan Campin wrote:

I keep getting this error in the RPG program that is calling Scott's

JDBCR4

service program. It does not end the process but for every run I get
hundreds of them.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.