Re: calling java stored functions through jdbc gives errors.

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