Simple queries with JDBC escaped scalar functions result in exceptions

Поиск
Список
Период
Сортировка
От Adam Rauch
Тема Simple queries with JDBC escaped scalar functions result in exceptions
Дата
Msg-id 02c61eb2-e2da-4e9c-281b-18bf60ea48b1@labkey.com
обсуждение исходный текст
Ответы Re: Simple queries with JDBC escaped scalar functions result in exceptions
Re: Simple queries with JDBC escaped scalar functions resultin exceptions
Список pgsql-jdbc
I upgraded to postgresql-9.4.1209.jar and fixed all the places in our code that used JDBC escaped scalar functions (e.g., {fn now()}) inside function definitions. However, we continued to see the telltale exception (org.postgresql.util.PSQLException: ERROR: syntax error at or near "{") when executing straightforward SELECT queries that included scalar functions. I tracked this down to comments; a simple repro is to execute the following query via JDBC:
SELECT /* $ */ {fn curdate()}
The original comments included many characters, but the dollar sign seems to be the culprit. I think this indicates a problem with the parser that's attempting to detect string literals.

Thanks,
Adam

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: SocketTimeout and ConnectionTimeout
Следующее
От: Adam Rauch
Дата:
Сообщение: Simple queries with JDBC escaped scalar functions result inexceptions