MIME-Version: 1.0
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>
 <784915.1673487222@sss.pgh.pa.us>
 <CAKFQuwYtmLLkmjaKghYXPnBWwvUvsqhZR=9J8KDcLzavf8707w@mail.gmail.com>
 <865715.1673493193@sss.pgh.pa.us>
 <VI1PR1001MB1423F7050B1979EAF610D2C8E8FD9@VI1PR1001MB1423.EURPRD10.PROD.OUTLOOK.COM>
In-Reply-To: 
 <VI1PR1001MB1423F7050B1979EAF610D2C8E8FD9@VI1PR1001MB1423.EURPRD10.PROD.OUTLOOK.COM>
From: Dave Cramer <davecramer@postgres.rocks>
Date: Thu, 12 Jan 2023 09:36:44 -0500
Message-ID: 
 <CADK3HHJbx5+DxndG--8FKDF3uAOLS3MtFGu++73TEvkFeABpqA@mail.gmail.com>
Subject: Re: stringtype=unspecified is null check problem
To: Martin Handsteiner <martin.handsteiner@sibvisions.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
 "David G. Johnston" <david.g.johnston@gmail.com>,
	"pgsql-jdbc@lists.postgresql.org" <pgsql-jdbc@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000c2545505f2120cd1"
Archived-At: 
 <https://www.postgresql.org/message-id/CADK3HHJbx5%2BDxndG--8FKDF3uAOLS3MtFGu%2B%2B73TEvkFeABpqA%40mail.gmail.com>
Precedence: bulk

--000000000000c2545505f2120cd1
Content-Type: text/plain; charset="UTF-8"

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

--000000000000c2545505f2120cd1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Thu, 12 Jan 2023 at 03:32, Martin =
Handsteiner &lt;<a href=3D"mailto:martin.handsteiner@sibvisions.com">martin=
.handsteiner@sibvisions.com</a>&gt; wrote:<br></div><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,=
204,204);padding-left:1ex">Thanks a lot, I think, this will help a lot of (=
java) users, and makes the usage of PostgreSQL DB a way better!<br>
<br>
I had yesterday an idea for a solution on java side. As we have already a p=
reprocessing with a jdbc wrapper, for function and procedure calls (in/out =
parameters are not working with postgres jdbc), I&#39;ll added preprocessin=
g for the parameters.<br>
<br>
I&#39;ll search the statement for all question marks (?) that are not insid=
e a comment (-- \n, /* */), not in quotes (&quot; &quot;) and not in string=
s (&#39; &#39;), check the parameter, if it is null, and replace the ? by n=
ull, and reduce the parameter list.<br>
<br>
I can link the code if you want, as it is Apache License 2.0.<br></blockquo=
te><div>Please do</div><div>=C2=A0</div></div></div>

--000000000000c2545505f2120cd1--