Re: Prepared Statements

Поиск
Список
Период
Сортировка
От Fernando Nasser
Тема Re: Prepared Statements
Дата
Msg-id 3F1BDA47.4090709@redhat.com
обсуждение исходный текст
Ответ на Re: Prepared Statements  (Fernando Nasser <fnasser@redhat.com>)
Ответы Re: Prepared Statements  (Dmitry Tkach <dmitry@openratings.com>)
Re: Prepared Statements  (Peter Kovacs <peter.kovacs@siemens.com>)
Список pgsql-jdbc
Dima Tkach wrote:

> I was fairly happy with what it used to be - just call setObject () and
> be done with it

Unfortunately that is not an option as it is a security risk.

You cannot leave a driver out there which allows people to insert
potentially harmful SQL statements just to make it easier for someone to
  specify a set.

In any case, I wonder if all PreparedStatements won't be server side
only one day as the client side interface was created to fill in for the
lack of that in older backends.  Once that happens and the V3 protocol
is used (7.4+ backends) I doubt that SQL injection, and the hack to set
IN arguments, will work.

Regards to all,
Fernando

--
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9


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

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: Number of function parameter
Следующее
От: Dmitry Tkach
Дата:
Сообщение: Re: Prepared Statements