Re: stringtype=unspecified is null check problem - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: stringtype=unspecified is null check problem
Date
Msg-id CADK3HHJbx5+DxndG--8FKDF3uAOLS3MtFGu++73TEvkFeABpqA@mail.gmail.com
Whole thread Raw
In response to AW: stringtype=unspecified is null check problem  (Martin Handsteiner <martin.handsteiner@sibvisions.com>)
Responses AW: stringtype=unspecified is null check problem  (Martin Handsteiner <martin.handsteiner@sibvisions.com>)
List 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 by date:

Previous
From: Dave Cramer
Date:
Subject: [pgjdbc/pgjdbc]
Next
From: sz-liva
Date:
Subject: [pgjdbc/pgjdbc] b840bf: fix: improve thread safety of PgResultSet#getTimes...