Does PG's JDBC support prepared statements at all?

Поиск
Список
Период
Сортировка
От Dr. Evil
Тема Does PG's JDBC support prepared statements at all?
Дата
Msg-id 20011020231422.7227.qmail@sidereal.kz
обсуждение исходный текст
Ответы Re: Does PG's JDBC support prepared statements at all?  ("Thomas O'Dowd" <tom@nooper.com>)
Re: Does PG's JDBC support prepared statements at all?  ("Dave Cramer" <Dave@micro-automation.net>)
Re: Does PG's JDBC support prepared statements at all?  (Rene Pijlman <rene@lab.applinet.nl>)
Список pgsql-jdbc
There is a bunch of documentation for prepared statements in PG's
JDBC, it seems that the only thing prepared statements do is throw
exceptions.

Here's some code I'm trying:

                String newvalue = "This is a new value";
                int accountnumber = 54;
                String qstring = "UPDATE foo SET message = '?' WHERE number = ?";
        PreparedStatement st = db.prepareStatement(qstring);
                st.setString(1, newvalue);
                st.setInt(2, accountnumber);
                st.execute();
                st.clearParameters();
                st.close();

and I always get a Parameter index out of range error, which seems
impossible.  Any idea what's going on?

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "Dr. Evil"
Дата:
Сообщение: PreparedStatement parameters question
Следующее
От: "Thomas O'Dowd"
Дата:
Сообщение: Re: Does PG's JDBC support prepared statements at all?