3 messages in org.postgresql.pgsql-jdbcTrouble with CallableStatement
FromSent OnAttachments
Michael GuyverJul 22, 2006 5:55 pm 
Michael GuyverJul 23, 2006 4:27 am 
Michael GuyverJul 23, 2006 5:04 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Trouble with CallableStatementActions...
From:Michael Guyver (kene@googlemail.com)
Date:Jul 23, 2006 4:27:04 am
List:org.postgresql.pgsql-jdbc

Hi there,

Having followed Adam's advice and prevented the original error by upgrading the Jar to 8.1-407, I now get a different exception. For the same function:

CREATE OR REPLACE FUNCTION pro_register_cookie_for_user( prmUserId int8, prmSecureGuid varchar, OUT outUsernameHash varchar, OUT outMaxAge float4) AS $$ ... $$ LANGUAGE plpgsql;

I now get the following error:

org.postgresql.util.PSQLException: No results were returned by the query. at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:259)

This is caused by the AbstractJdbc2Statement.executeWithFlags(int) method returning false for any code path which satisfies the condition (isFunction && returnTypeSet).

This appears to be at best mis-reported as I can clearly see the results being read into the abstractJdbc2Statement.callResult instance variable.

Is this right?

Michael