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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Trouble with CallableStatement



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



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group