JDBC parse error

From: John Metz <johnmetz(at)excite(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC parse error
Date: 2002-06-18 05:56:43
Message-ID: 000601c2168c$ecad0630$6501a8c0@EVEREST
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I'm having an intermittent problem with the PostGres JDBC Driver I recently
downloaded from http://jdbc.postgresql.org/download.html. I am running a
Java Servlet application under Tomcat 4.0 and Solaris 8. On some occasions
it seems that the String passed to a Statement object gets altered when
executed. I get a SQLException with the text "parse error at or near selec".
It always seems to happen on a select. On some occasions it works but it
seems to happen on some queries more than others. The text in the parse
error is different at times for the same query (another example was
selecaria). Here is an example stack trace:

java.sql.SQLException: ERROR: parser: parse error at or near "selec"

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
com.conquestnet.database.entity.EducationDegree.getAllEducationDegrees(Educa
tionDegree.java:211)
at org.apache.jsp.edit$jsp._jspService(edit$jsp.java:218)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown
Source)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
at org.apache.jasper.servlet.JspServlet.service(Unknown Source)

Any help that can be provided is much appriciated. I've searched the FAQ
but could not find anything that seemed like the same problem.

Thanks,

John Metz

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vernon Wu 2002-06-18 08:57:52 getString can't pick up the last new column
Previous Message Len Morgan 2002-06-17 18:40:10 Re: JBuilder 6 & JDBC