Re: stringtype=unspecified is null check problem

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: stringtype=unspecified is null check problem
Дата
Msg-id CADK3HHJbx5+DxndG--8FKDF3uAOLS3MtFGu++73TEvkFeABpqA@mail.gmail.com
обсуждение исходный текст
Ответ на AW: stringtype=unspecified is null check problem  (Martin Handsteiner <martin.handsteiner@sibvisions.com>)
Ответы AW: stringtype=unspecified is null check problem  (Martin Handsteiner <martin.handsteiner@sibvisions.com>)
Список pgsql-jdbc


On Thu, 12 Jan 2023 at 03:32, Martin Handsteiner <martin.handsteiner@sibvisions.com> wrote:
Thanks a lot, I think, this will help a lot of (java) users, and makes the usage of PostgreSQL DB a way better!

I had yesterday an idea for a solution on java side. As we have already a preprocessing with a jdbc wrapper, for function and procedure calls (in/out parameters are not working with postgres jdbc), I'll added preprocessing for the parameters.

I'll search the statement for all question marks (?) that are not inside a comment (-- \n, /* */), not in quotes (" ") and not in strings (' '), check the parameter, if it is null, and replace the ? by null, and reduce the parameter list.

I can link the code if you want, as it is Apache License 2.0.
Please do
 

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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: [pgjdbc/pgjdbc]
Следующее
От: sz-liva
Дата:
Сообщение: [pgjdbc/pgjdbc] b840bf: fix: improve thread safety of PgResultSet#getTimes...