bug 1201
От | federico |
---|---|
Тема | bug 1201 |
Дата | |
Msg-id | 41758DFC.5020505@hyphen.it обсуждение исходный текст |
Ответы |
Re: bug 1201
Re: bug 1201 |
Список | pgsql-bugs |
i saw in bug 1201 that some got my problem i detail it i have a function that returns a void CREATE OR REPLACE FUNCTION myFunction(int2, int2) RETURNS void AS $BODY$ UPDATE table SET field1 = $1 WHERE field2 = $2; $BODY$ LANGUAGE 'sql' VOLATILE; when i execute it with a callablestatement CallableStatement cstm = conn.prepareCall({ call myFunction(CAST(? AS INT2), CAST(? AS INT2)) }); cstm.setInt(1, aValue.getValue()); cstm.setInt(2, anotherValue.getValue()); i got the following error org.postgresql.util.PSQLException: ERROR: function "jcpo_setallusersbyissuemessagestatus" in FROM has unsupported returntype at org.postgresql.util.PSQLException.parseServerError(PSQLException.java:139) at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:152) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50) any news about it? i'm using PostgreSQL Database Server 8.0-beta2-dev3 on Windows and pgdev.307.jdbc3.jar drivers thank you federico
В списке pgsql-bugs по дате отправления: