public inbox for [email protected]
help / color / mirror / Atom feedFrom: Dave Cramer <[email protected]>
To: Martin Handsteiner <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: David G. Johnston <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: stringtype=unspecified is null check problem
Date: Thu, 12 Jan 2023 09:36:44 -0500
Message-ID: <CADK3HHJbx5+DxndG--8FKDF3uAOLS3MtFGu++73TEvkFeABpqA@mail.gmail.com> (raw)
In-Reply-To: <VI1PR1001MB1423F7050B1979EAF610D2C8E8FD9@VI1PR1001MB1423.EURPRD10.PROD.OUTLOOK.COM>
References: <VI1PR1001MB1423CDC3E737B4763436B730E8FF9@VI1PR1001MB1423.EURPRD10.PROD.OUTLOOK.COM>
<CAKFQuwZA+9+FNovGXA6moj+sDzR6ShyzzP3H77m-05n3dXDv-w@mail.gmail.com>
<VI1PR1001MB1423C002817FECB26B1AFB3DE8FC9@VI1PR1001MB1423.EURPRD10.PROD.OUTLOOK.COM>
<CAKFQuwZrn0F9RyM=WL9Z=pioGX5pwH1+mbBe-jGNnjy_J2E+Jw@mail.gmail.com>
<[email protected]>
<CAKFQuwYtmLLkmjaKghYXPnBWwvUvsqhZR=9J8KDcLzavf8707w@mail.gmail.com>
<[email protected]>
<VI1PR1001MB1423F7050B1979EAF610D2C8E8FD9@VI1PR1001MB1423.EURPRD10.PROD.OUTLOOK.COM>
On Thu, 12 Jan 2023 at 03:32, Martin Handsteiner <
[email protected]> 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
view thread (14+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: stringtype=unspecified is null check problem
In-Reply-To: <CADK3HHJbx5+DxndG--8FKDF3uAOLS3MtFGu++73TEvkFeABpqA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox