I'm having problems using CallableStatement to execute a function that
has a smallint parameter. The problem I'm having is identical to this
bug report:
http://archives.postgresql.org/pgsql-bugs/2003-04/msg00060.php
From a basic examination of the code, it seems that setShort(int,
short) simply serializes the value to a string, making it
indistinguishable from an integer. The response to that bug mentions
that the literal needs to be cast to a smallint:
http://archives.postgresql.org/pgsql-bugs/2003-04/msg00061.php
Is this a known problem with the JDBC implementation, or is this a bug
that can be fixed?
best,
christian.