Skip site navigation (1) Skip section navigation (2)

Re: calling java stored functions through jdbc gives errors.

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Markus Schaber <schabi(at)logix-tt(dot)com>
Cc: Alex Stienstra <alex(dot)stienstra(at)zonnet(dot)nl>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: calling java stored functions through jdbc gives errors.
Date: 2006-11-02 10:44:12
Message-ID: F1D38C88-93E4-420A-BA66-F428F054C7FE@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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
>


In response to

Responses

pgsql-jdbc by date

Next:From: Markus SchaberDate: 2006-11-02 12:06:06
Subject: Re: calling java stored functions through jdbc gives errors.
Previous:From: Markus SchaberDate: 2006-11-02 09:57:28
Subject: Re: calling java stored functions through jdbc gives errors.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group