From: | Pedro Salazar <pedro-b-salazar(at)ptinovacao(dot)pt> |
---|---|
To: | "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | callable statement return boolean --> ERROR |
Date: | 2003-04-20 01:14:09 |
Message-ID: | D397A7FACCC45A44A0A207FD892961EA020F6E61@mail.intra.cet.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Greetings,
I created a function in pgsql that returns a boolean. In JDBC I register the
return variable to java.sql.Types.BOOLEAN. However, when I execute my
function I got the following error:
A CallableStatement Function was executed and the return was of type
(java.sql.Types=-7) however type=java.sql.Types=16 was registered.
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.j
ava:332)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.j
ava:48)
Is boolean type values supported by JDBC Postgresql driver?
P.S.- a workaround is use 0/1, but I'm wondering if boolean is supported in
JDBC... (7.3.2)
thanks,
Pedro Salazar.
From | Date | Subject | |
---|---|---|---|
Next Message | charlie.murdoch | 2003-04-20 23:11:38 | Server side program |
Previous Message | Nic Ferrier | 2003-04-19 21:13:18 | build patch |