Content-Type: multipart/alternative;
 boundary="------------1MZipkk8ba6MIjlJ0O0l98TI"
Message-ID: <7bae9dbf-b192-5ea5-838f-23f30d4f5f5e@pangburngroup.com>
Date: Fri, 10 Feb 2023 15:33:03 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.7.0
Subject: Re: org.postgresql.util.PSQLException: ERROR: syntax error at or near
 "(" when calling org.postgresql.jdbc.PgPreparedStatement.getParameterMetaData
Content-Language: en-US
To: pgsql-jdbc@lists.postgresql.org
References: 
 <CAPqV3pT7yQHB0YfDH0HSTrLsREhZnc=cDTFLsOvyqJsx--vwAw@mail.gmail.com>
Reply-To: dbadmin@pangburngroup.com
From: Prasanth <dbadmin@pangburngroup.com>
In-Reply-To: 
 <CAPqV3pT7yQHB0YfDH0HSTrLsREhZnc=cDTFLsOvyqJsx--vwAw@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/7bae9dbf-b192-5ea5-838f-23f30d4f5f5e%40pangburngroup.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------1MZipkk8ba6MIjlJ0O0l98TI
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Did you check the query being used? Most likely that is where the issue would be.

On 2/10/23 3:26 PM, Siddharth Jain wrote:
> Hello,
>
> 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
> at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)
> at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)
> at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:316)
> at org.postgresql.jdbc.PgPreparedStatement.getParameterMetaData(PgPreparedStatement.java:1705)
> at org.apache.commons.dbcp2.DelegatingPreparedStatement.getParameterMetaData(DelegatingPreparedStatement.java:162)
> at org.apache.commons.dbcp2.DelegatingPreparedStatement.getParameterMetaData(DelegatingPreparedStatement.java:162)
> at cdao.dpde.InsertHelper.setParameters(InsertHelper.java:53)
> where the code in the last line is:
> ParameterMetaData parameterMetaData = query.getParameterMetaData();
>
> How can we fix this?
>
> S.

--------------1MZipkk8ba6MIjlJ0O0l98TI
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font face="Verdana">Did you check the query being used? Most likely
      that is where the issue would be.</font><br>
    <br>
    <div class="moz-cite-prefix">On 2/10/23 3:26 PM, Siddharth Jain
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAPqV3pT7yQHB0YfDH0HSTrLsREhZnc=cDTFLsOvyqJsx--vwAw@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">Hello,
        <div><br>
        </div>
        <div>We are using Postgres 14.4 server and 42.5.2 of
          org.postgresql:postgresql to connect to it from Java.</div>
        <div>We get following exception:</div>
        <div>Caused by: org.postgresql.util.PSQLException: ERROR: syntax
          error at or near "("<br>
            Position: 13<br>
          at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2676)<br>
          at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2366)<br>
          at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:356)<br>
          at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:316)<br>
          at
org.postgresql.jdbc.PgPreparedStatement.getParameterMetaData(PgPreparedStatement.java:1705)<br>
          at
org.apache.commons.dbcp2.DelegatingPreparedStatement.getParameterMetaData(DelegatingPreparedStatement.java:162)<br>
          at
org.apache.commons.dbcp2.DelegatingPreparedStatement.getParameterMetaData(DelegatingPreparedStatement.java:162)<br>
          at cdao.dpde.InsertHelper.setParameters(InsertHelper.java:53)<br>
        </div>
        <div>where the code in the last line is:</div>
        <div>ParameterMetaData parameterMetaData =
          query.getParameterMetaData();<br>
        </div>
        <div><br>
        </div>
        <div>How can we fix this?</div>
        <div><br>
        </div>
        <div>S.</div>
      </div>
    </blockquote>
    <br>
  </body>
</html>

--------------1MZipkk8ba6MIjlJ0O0l98TI--