Re: org.postgresql.util.PSQLException: ERROR: syntax error at or near "(" when calling org.postgresql.jdbc.PgPreparedStatement.getParameterMetaData

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: org.postgresql.util.PSQLException: ERROR: syntax error at or near "(" when calling org.postgresql.jdbc.PgPreparedStatement.getParameterMetaData
Дата
Msg-id CAKFQuwZrxMW6mnyLtc8ZPdzS94p7+jO8gAbRU7F=oAsBGsoDvA@mail.gmail.com
обсуждение исходный текст
Ответ на org.postgresql.util.PSQLException: ERROR: syntax error at or near "(" when calling org.postgresql.jdbc.PgPreparedStatement.getParameterMetaData  (Siddharth Jain <siddhsql@gmail.com>)
Список pgsql-jdbc
Дерево обсуждения
On Fri, Feb 10, 2023 at 2:26 PM Siddharth Jain <siddhsql@gmail.com> wrote:

We are using Postgres 14.4 server and 42.5.2 of org.postgresql:postgresql to connect to it from Java.
We get following exception:
Caused by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "("
  Position: 13
 
where the code in the last line is:
ParameterMetaData parameterMetaData = query.getParameterMetaData();

How can we fix this?


If the broken query is one generated by the driver you probably cannot, you would need to file a bug report.  I strongly doubt your lack of current-ness on the PostgreSQL is going to be an influence here but maybe...

In any case you are going to need something much more descriptive, and ideally executable than this, if you actually want to debug and then file a bug report (or fix your code if that is where the problem originates).

David J.

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