Hello.
This may be an issue that you are all aware of, sorry for not digging
through archives and such,
but I simply don't have the time.
Noting that support for CallableStatement is not yet implemented I
elected to use
the following format for calling user defined SQL Functions and
dynamically bind
parameters to them.
PreparedStatement procedure = conn.prepareStatement("select
someFunction(?,?,?)");
and then binding params with
procedure.setObject(index, aStringOrIntegerOrSomeSuch);
which mostly works fine. However, I discovered that in some cases, when
the bound
parameter is totatlly screwed, ie. Float when the function expects
Integer, the
PostgreSQL jdbc driver will throw an exception:
java.sql.SQLException: ERROR: pg_atoi: error in "140.0": can't parse ".0"
which is fine and all, except that any subsequent statements made to the
connection instance in question will fail with:
java.sql.SQLException: The query returned no rows
which is not too great. For my application I made a workaround that
runs a query I know should work before every query to determine if
the connection instance is jammed and has to be re-instantiated...
This introduced surprisingly little overhead with a pre prepared statement,
but it is a kludgy annoyance nonetheless.
Any ideas or comments?
Summery greetings from Finland!
Peter Bäck
--
-=[ Peter Bäck +358-400-564050 ]=-
-=[ Oy IT Mill Ltd Ruukinkatu 2 - 4 ]=-
-=[ http://www.itmill.com 20540 Turku , Finland ]=-