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 по дате отправления: