Re: Is PREPARE of ecpglib thread safe?

Oops.

At Fri, 15 Mar 2019 15:33:50 +0900 (Tokyo Standard Time), Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> wrote in <20190315(dot)153350(dot)226491548(dot)horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp>
> > // If ecpglib didn't reject the above, ecpglib cannot judge
> > // which connection the followings should be executed on.
> > exec sql prepare st1 from "select 1";
> > exec sql execute st1;
>
> I'm not sure about ECPG, but according to the documentation, the
> following statements should work correctly.
>
> SQL SET CONNECTION con1;

Of course this is missing prefixing "EXEC".

> EXEC SQL PREPARE st1 FROM "select 1";
> EXEC SQL EXECUTE st1;
>
> should succeed and executed on con1.
>
> > Kuroda-san, is it right?
> > If it's right, I will fix it with using pthread_lock.
>
> Mmm. Are you saying that prepared statements on ECPG should have
> names in global namespace and EXECUTE should implicitly choose
> the underlying connection automatically from the name of a
> prepared statement? I don't think it is the right direction.

--
Kyotaro Horiguchi
NTT Open Source Software Center