unterminated quoted string
| От | Alexey Yudichev |
|---|---|
| Тема | unterminated quoted string |
| Дата | |
| Msg-id | 8BCBF9DB739F034B87FE7C7D30EAE55C157C4E@hqex2k.francoudi.com обсуждение исходный текст |
| Ответы |
Re: unterminated quoted string
|
| Список | pgsql-jdbc |
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.
В списке pgsql-jdbc по дате отправления: