From: | "Nick Fankhauser" <nickf(at)ontko(dot)com> |
---|---|
To: | "zhan yi" <zy7111(at)mail(dot)china(dot)com>, <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: parser: parse error at or near "-" |
Date: | 2003-08-12 03:56:55 |
Message-ID: | NEBBLAAHGLEEPCGOBHDGKEJJHPAA.nickf@ontko.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Is there any chance that a "-" is getting substituted into the ? values for
offset or limit, thus causing the parse error because an integer is
expected? Since there is no "-" in the prepared statement, I'd look to the
substitution variables for the problem.
-Nick
-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]On Behalf Of zhan yi
Sent: Monday, August 11, 2003 9:11 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] parser: parse error at or near "-"
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:9
9)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingP
reparedStatement.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
From | Date | Subject | |
---|---|---|---|
Next Message | zy7111 | 2003-08-12 03:59:46 | Re: parser: parse error at or near "-" |
Previous Message | zhan yi | 2003-08-12 02:11:16 | parser: parse error at or near "-" |