From: | "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #1201: void functions called through jdbc driver return error |
Date: | 2004-07-27 06:19:37 |
Message-ID: | 20040727061937.5E93DCF4B26@www.postgresql.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1201
Logged by: Jonathan Scott
Email address: jwscott(at)vanten(dot)com
PostgreSQL version: 7.4
Operating system: Linux
Description: void functions called through jdbc driver return error
Details:
Hello all,
At work here, we are considering upgrading from 7.3 to 7.4, but we've hit a
bit of a snag. We have functions in our schema that have return void. When
called through the 7.4's JDBC driver, we get the following error:
ERROR: function "fulfill_cctrans_item" in FROM has unsupported return type
Our DB unit tests seem to indicate the function is defined and works
correctly; we just get the error when accessing it through the JDBC driver.
Inside our Java code, we use executeQuery() on a CallableStatement object,
as below:
stmt = con.prepareCall("{ call " + statement + "}");
stmt.executeQuery();
Any more info needed, please feel free to contact me.
Thanks,
Jonathan
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2004-07-27 06:49:38 | Re: BUG #1201: void functions called through jdbc driver |
Previous Message | Kris Jurka | 2004-07-27 06:16:47 | casting strings to multidimensional arrays yields strange results |