public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: Siddharth Jain <[email protected]>
Cc: [email protected]
Subject: Re: org.postgresql.util.PSQLException: ERROR: syntax error at or near "(" when calling org.postgresql.jdbc.PgPreparedStatement.getParameterMetaData
Date: Fri, 10 Feb 2023 14:34:52 -0700
Message-ID: <CAKFQuwZrxMW6mnyLtc8ZPdzS94p7+jO8gAbRU7F=oAsBGsoDvA@mail.gmail.com> (raw)
In-Reply-To: <CAPqV3pT7yQHB0YfDH0HSTrLsREhZnc=cDTFLsOvyqJsx--vwAw@mail.gmail.com>
References: <CAPqV3pT7yQHB0YfDH0HSTrLsREhZnc=cDTFLsOvyqJsx--vwAw@mail.gmail.com>

On Fri, Feb 10, 2023 at 2:26 PM Siddharth Jain <[email protected]> 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.

view thread (8+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: org.postgresql.util.PSQLException: ERROR: syntax error at or near "(" when calling org.postgresql.jdbc.PgPreparedStatement.getParameterMetaData
  In-Reply-To: <CAKFQuwZrxMW6mnyLtc8ZPdzS94p7+jO8gAbRU7F=oAsBGsoDvA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox