Re: calling java stored functions through jdbc gives errors.

Alex,

Also try preparing the call in psql

prepare foo_plan as select uw_ping();
execute foo_plan;

However I can tell you that jdbc doesn't do anything particularly
different than psql or pgadmin.


Dave
On 2-Nov-06, at 4:57 AM, Markus Schaber wrote:

> Hi, Alex,
>
> Alex Stienstra wrote:
>> The following simple query I send to the server using JDBC:
>>
>> "SELECT uw_ping()"
>>
>> When the stored function uw_ping() is written in 'plpgsql' everything
>> works fine. But when the uw_ping() is written in java and linked in
>> using PL/java it gives the following error message:
>>
>> org.postgresql.util.PSQLException: An I/O error occured while
>> sending to
>> the backend.
>>
>> Executing the same query using pgadmin III gives no problems.
>> Anyone any
>> idea what the problem is?
>
> It might be a V2/V3 protocol difference.
>
> Do you get the error message immediately, or after a short timeout?
>
> Can you look into the server logs to see what's noted there?
>
> Thanks,
> markus
>
>
> --
> Markus Schaber | Logical Tracking&Tracing International AG
> Dipl. Inf.     | Software Development GIS
>
> Fight against software patents in Europe! www.ffii.org
> www.nosoftwarepatents.org
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>