Parse problem in AbstractJdbc2ResultSet.parseQuery

From: Xavier Poinsard <xpoinsard(at)openpricer(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Parse problem in AbstractJdbc2ResultSet.parseQuery
Date: 2003-09-19 15:31:10
Message-ID: bkf7fu$cem$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

I would like to report the following problem:
using an updatable resultset, the query is parsed to find the name of
the table to update in the parseQuery method.
Unfortunately the parsing is too much simple, it fails with the folling
query :

select col_A, col_B, extract(Month from col_with_date_type) from
table_to_update where ....

It found that tableName is "col_with_date_type)" since it only pays
attention to the from keyword and forgot the parenthesis.
The parsing should be fixed.

Xavier.

Browse pgsql-jdbc by date

  From Date Subject
Next Message szilva 2003-09-19 16:57:29 How to get rid of NOTICE:
Previous Message Tom Lane 2003-09-19 15:07:17 Re: Password authentication working with psql, but fails with jdbc for me