Alexey,
If you had statement logging turned on on the server you would see the
exact sql statement that the server was complaining about. That would
be very useful to know.
thanks,
--Barry
Alexey Yudichev wrote:
> Having the code
>
> String SQL = "SELECT COUNT(*) FROM Destination WHERE address=?";
> st = conn.prepareStatement(SQL);
> st.setString(1, address);
> rs = st.executeQuery();
>
> and if address is an empty string, sometimes (very rarely) i get
>
> java.sql.SQLException: ERROR: Unterminated quoted string
>
> 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)
>
> I use PostgreSQL 7.1 and PostgreSQL 7.2 driver with "compatible=7.1" option.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
