Re: Are these bugs?

Hello Brian,

See my answers below

Dave Cramer

www.postgres.rocks

On Sat, 7 Aug 2021 at 11:50, Brian Ye <brian.y.ye@gmail.com> wrote:

Dear Sirs,

I was trying to use postgresql jdbc.  The downloaded version did not work for me so I tried to build the project myself using Eclipse (the suggested gradle build method gave me errors).

Why did the download version not work? Can you elaborate.

What errors were encountered when you tried to build it?

 

I have encountered several problems:

1) Download the source from jdbc.posgresql.org, this source does not have the SSPIClient implementation  (it only has the ISSPIClient interface).

Interesting. I can confirm that it does not exist. I will rectify this.

 

2) Downloaded the source from github.  This version does not have the souce code for org.postgresql.util.DriverInfo.java.  I copied it from the downloaded file from step 1) above.

 https://github.com/pgjdbc/pgjdbc/archive/refs/tags/REL42.2.23.tar.gz does have DriverInfo

3) After adding all the missing external libraries (such as jna, waffle, osgi...) it compiled successfully.

4) There are run time errors after testing the built library with a small test program:

    (4.1) If jna and jna-platform are of version 5.0.0 or newer,  the following line causes errors because no such a constructor exists:

SecBufferDesc continueToken = new SecBufferDesc(Sspi.SECBUFFER_TOKEN, receivedToken);

Note: Verson 5.0.0 (or newer) has only one constructor SecBufferDesc().

    (4.2) If jna and jna-platform are of older version (4.5.2), SecBufferDesc does provide 3 different constructor, but the following code causes errors:

Class.forName("waffle.windows.auth.impl.WindowsSecurityContextImpl");

This class references SspiUtil$ManagedSecBufferDesc, which is only available from version 5.0.0 of jna-platform (or newer).

So basically the implementation of SSPIClient uses different JNA APIs from incompatible versions.

Would you please take a look?

I can, but if you can provide your test program that would be helpful

Dave 

Thanks,
Brian Ye

Virus-free. www.avg.com