Parse problem in AbstractJdbc2ResultSet.parseQuery - Mailing list pgsql-jdbc

From Xavier Poinsard
Subject Parse problem in AbstractJdbc2ResultSet.parseQuery
Date
Msg-id bkf7fu$cem$1@sea.gmane.org
Whole thread Raw
List 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.


pgsql-jdbc by date:

Previous
From: "Gerald Dalley"
Date:
Subject: Password authentication working with psql, but fails with jdbc for me
Next
From: "sc0698"
Date:
Subject: Re: Stored Procedure returns a ResultSet