I have the following problem on Informix SE 7.25.UC1:
A view is created, and than this view is queried via JDBC connection (a simpe select statement is run on columns of the view).
When the query runs at first time, it works fine.
But when the same query is run at the second time, it fails with syntax error:
java.sql.SQLException: A syntax error has occurred.
at com.informix.util.IfxErrMsg.getSQLException(IfxErr Msg.java:348)
at com.informix.jdbc.IfxSqli.addException(IfxSqli.jav a:3025)
at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.jav a:3335)
at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java :2288)
at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.j ava:2208)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1338)
at com.informix.jdbc.IfxSqli.executeStatementQuery(If xSqli.java:1311)
at com.informix.jdbc.IfxResultSet.executeQuery(IfxRes ultSet.java:230)
at com.informix.jdbc.IfxStatement.executeQueryImpl(If xStatement.java:809)
at com.informix.jdbc.IfxStatement.executeQuery(IfxSta tement.java:151)
The java application is a servlet running on Apache. The only way of making the query work again, is to restart Apache.
Any idea? Any similar experience? Thank you in advance.

I see your post is very old. Did you ever find the solution. I"m desperate!!!