Re: JDBC and the hstore ? operator - no longer working withbuild 1211
От | Dave Cramer |
---|---|
Тема | Re: JDBC and the hstore ? operator - no longer working withbuild 1211 |
Дата | |
Msg-id | CADK3HHJ50aqPHqGOdpeja1tHnpgju8HwKA9Yi8j_1wk0n58ifg@mail.gmail.com обсуждение исходный текст |
Ответ на | JDBC and the hstore ? operator - no longer working with build 1211 (Thomas Kellerer <spam_eater@gmx.net>) |
Ответы |
Re: JDBC and the hstore ? operator - no longer working withbuild 1211
|
Список | pgsql-jdbc |
Thomas,
This has been "broken" for a while now, you have to use ?? to get it to work.
On 31 October 2016 at 17:07, Thomas Kellerer <spam_eater@gmx.net> wrote:
The support for using the hstore ? operator without a PreparedStatement worked with build 1208, but is broken (again) with build 1211
The following works with build 1208
Connection conn = DriverManager.getConnection(...);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from some_table where hstore_column ? 'foo');
with build 1211 it throws an exception with the message:
org.postgresql.util.PSQLException: ERROR: syntax error at or near "$1"
Was this intended to work in build 1208 or was that just by accident?
Thomas
--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc
В списке pgsql-jdbc по дате отправления: