parser: parse error at or near "-"

From: "zhan yi" <zy7111(at)mail(dot)china(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: parser: parse error at or near "-"
Date: 2003-08-12 02:11:16
Message-ID: 002501c36077$05346380$85130b0d@aaa
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

hi,

I am developing an accounting application using postgresql 7.2.2 and pg72jdbc2.jar. I met following exception when execute a query:

java.sql.SQLException: ????: parser: parse error at or near "-"

at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:94)
at org.postgresql.Connection.ExecSQL(Connection.java:398)
at org.postgresql.jdbc2.Statement.execute(Statement.java:130)
at org.postgresql.jdbc2.Statement.executeQuery(Statement.java:54)
at org.postgresql.jdbc2.PreparedStatement.executeQuery(PreparedStatement.java:99)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:179)
at db.TeleRateTable.selectAll(TeleRateTable.java:36)
at org.apache.jsp.admin_jsp._jspService(admin_jsp.java:737)
......

the sql string is:
select * from teleRateTable ORDER BY char_length(prefix), prefix LIMIT ? OFFSET ?

Any hint on solving this problem is appreciated.

regards
zhanyi

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Nick Fankhauser 2003-08-12 03:56:55 Re: parser: parse error at or near "-"
Previous Message Barry Lind 2003-08-11 23:42:58 Re: patch: clean up ant test infrastructure