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