Bug with binding query parameters hangs entire connection instance. (Possibly redundant notice)
| От | Peter Bäck |
|---|---|
| Тема | Bug with binding query parameters hangs entire connection instance. (Possibly redundant notice) |
| Дата | |
| Msg-id | 3D11A841.2030109@itmill.com обсуждение исходный текст |
| Список | pgsql-jdbc |
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 ]=-
В списке pgsql-jdbc по дате отправления: