Обсуждение: Fw: JDBC Bug Report

Hi guys, this has been sent direct to me. Peter

-----------

Hi,
I have a table with those column name "position" and "local" and I  use the
JDBC for PostgreSQL as you provided.  But when I run the my Java Application.
I t prompts up SQLException: parser: parse error at or
near "position"("local")
at org.postgresql.Connection.ExecSQL(Connection.java:393)
   at org.postgresql.jdbc2.Statement.execute(Statement.java:273)
   at org.postgresql.jdbc2.Statement.executeUpdate(Statement.java:73)
   at org.postgresql.jdbc2.PreparedStatement.executeUpdate
(PreparedStatement.java:126)

I think this is a bug since as I just change the field name in the table and
recompile my application and can run with no error.

Best regards,
Leo
email: leochan@email.com

On Fri, 14 Sep 2001 04:55:06 -0400 (EDT), you wrote:
>I have a table with those column name "position" and "local"
[parse error near local]
>I think this is a bug since as I just change the field name in
>the table and recompile my application and can run with no error.

"local" is a reserved word in SQL92/99 and in PostgreSQL. See
http://www.postgresql.org/idocs/index.php?sql-keywords-appendix.html.

This is not a bug, therefore. You should choose another column
name.

Regards,
René Pijlman <rene@lab.applinet.nl>