MIME-Version: 1.0
References: 
 <CAPqV3pT7yQHB0YfDH0HSTrLsREhZnc=cDTFLsOvyqJsx--vwAw@mail.gmail.com>
 <7bae9dbf-b192-5ea5-838f-23f30d4f5f5e@pangburngroup.com>
In-Reply-To: <7bae9dbf-b192-5ea5-838f-23f30d4f5f5e@pangburngroup.com>
From: Siddharth Jain <siddhsql@gmail.com>
Date: Fri, 10 Feb 2023 13:56:49 -0800
Message-ID: 
 <CAPqV3pQwcW0iNTFsuf-vzoyaKDrxQNPvCmJRBLx-Zs5bKanR8Q@mail.gmail.com>
Subject: Re: org.postgresql.util.PSQLException: ERROR: syntax error at or near
 "(" when calling org.postgresql.jdbc.PgPreparedStatement.getParameterMetaData
To: dbadmin@pangburngroup.com
Cc: pgsql-jdbc@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000b6121e05f45f93c9"
Archived-At: 
 <https://www.postgresql.org/message-id/CAPqV3pQwcW0iNTFsuf-vzoyaKDrxQNPvCmJRBLx-Zs5bKanR8Q%40mail.gmail.com>
Precedence: bulk

--000000000000b6121e05f45f93c9
Content-Type: text/plain; charset="UTF-8"

Thanks. query was the problem indeed. My mistake.

On Fri, Feb 10, 2023 at 1:33 PM Prasanth <dbadmin@pangburngroup.com> wrote:

> 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.
>
>
>

--000000000000b6121e05f45f93c9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks. query was the problem indeed. My mistake.</div><br=
><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, F=
eb 10, 2023 at 1:33 PM Prasanth &lt;<a href=3D"mailto:dbadmin@pangburngroup=
.com">dbadmin@pangburngroup.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">
 =20
   =20
 =20
  <div>
    <font face=3D"Verdana">Did you check the query being used? Most likely
      that is where the issue would be.</font><br>
    <br>
    <div>On 2/10/23 3:26 PM, Siddharth Jain
      wrote:<br>
    </div>
    <blockquote type=3D"cite">
     =20
      <div dir=3D"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 &quot;(&quot;<br>
          =C2=A0 Position: 13<br>
          at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutor=
Impl.java:2676)<br>
          at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.j=
ava: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(PgPreparedStat=
ement.java:1705)<br>
          at
org.apache.commons.dbcp2.DelegatingPreparedStatement.getParameterMetaData(D=
elegatingPreparedStatement.java:162)<br>
          at
org.apache.commons.dbcp2.DelegatingPreparedStatement.getParameterMetaData(D=
elegatingPreparedStatement.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 =3D
          query.getParameterMetaData();<br>
        </div>
        <div><br>
        </div>
        <div>How can we fix this?</div>
        <div><br>
        </div>
        <div>S.</div>
      </div>
    </blockquote>
    <br>
  </div>

</blockquote></div>

--000000000000b6121e05f45f93c9--