AW: stringtype=unspecified is null check problem
| От | Martin Handsteiner |
|---|---|
| Тема | AW: stringtype=unspecified is null check problem |
| Дата | |
| Msg-id | VI1PR1001MB1423F7050B1979EAF610D2C8E8FD9@VI1PR1001MB1423.EURPRD10.PROD.OUTLOOK.COM обсуждение исходный текст |
| Ответ на | Re: stringtype=unspecified is null check problem (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: stringtype=unspecified is null check problem
|
| Список | pgsql-jdbc |
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
functionand 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 (" ")
andnot 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.
В списке pgsql-jdbc по дате отправления: