Re: ResultSet with more than 5 rows causes error

----- Original Message -----
From: "Giuseppe Sacco" <giuseppe(at)eppesuigoccas(dot)homedns(dot)org>
To: "Ludovico Bianchini" <metlud(at)yahoo(dot)it>
Cc: <pgsql-jdbc(at)postgresql(dot)org>
Sent: Thursday, September 27, 2007 6:27 PM
Subject: Re: [JDBC] ResultSet with more than 5 rows causes error

> Il giorno gio, 27/09/2007 alle 12.20 +0200, Ludovico Bianchini ha
> scritto:
> [...]
>> while(source.next()) {
>> insertCall.registerOutParameter(1, Types.INTEGER);
>> for (int i = 1; i <= colCount; i++) {
>> data = source.getObject(i);
>> insertCall.setObject(i+1, data);
>> }
>> insertCall.execute();
> [...]
>
> I never used CallableStatement, but I do think you should use
> insertCall.setObject(i,data)
> instead of
> insertCall.setObject(i+1,data)
>
>

The stored procedure returns an integer parameter, which must be registered
with

insertCall.registerOutParameter(1, Types.INTEGER);

In a first attempt I wrote

insertCall.setObject(i,data);

but an error happened: the last parameter was not set. So: if there is a
return value, the arguments index starts from 2.
Really it's work fine for first 5 rows.

With this modification (create a new CallableStatement for every row)

[..]
insertCall.execute();
insertCall.close();
insertCall = remoteConnection.prepareCall(Costanti.FUNCTION_INSERT);
[..]

the code works, but I think the problem has to be solve deeply.

Chiacchiera con i tuoi amici in tempo reale!
http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com