Обсуждение: PL/pgSQL and JDBC, Relation 'Number' does not exist

Поиск
Список
Период
Сортировка

PL/pgSQL and JDBC, Relation 'Number' does not exist

От
Daniel.Stoinski@nagler-company.com
Дата:
Hi,
I wrote a pl/pgSQL routine, which I call from an SQL query through JDBC. If I
start this SQL query from psql, it works fine. From the Servlet I get from time
to time an SQLException with, for example, 'Relation 543167 does not exist'.
I don't use any relations with this name (or number). At this time I have only
catched and ignored the exception, because the pl/pgSQL program and the whole
query seem to work.
I won't torture You with the whole code, but I will send it to You, if it could
help to answer the question.
Best regards from Munich
Daniel