SCRAM authentication

[stedliu]

Is SCRAM authentication supported by PASH-Viewer? My JDK is 11.0.12. I don't think I have control of the pgjdbc version.

C:\PASH\PASH-Viewer-0.4.2\PASH-Viewer-0.4.2\bin>PASH-Viewer.bat
SQL Exception occured while connection pool initialize: SCRAM authentication is not supported by this driver. You need JDK >= 8 and pgjdbc >= 42.2.0 (not ".jre" vesions)

C:\PASH\PASH-Viewer-0.4.2\PASH-Viewer-0.4.2\bin>java --version
java 11.0.12 2021-07-20 LTS
Java(TM) SE Runtime Environment 18.9 (build 11.0.12+8-LTS-237)
Java HotSpot(TM) 64-Bit Server VM 18.9 (build 11.0.12+8-LTS-237, mixed mode)

[portnov]

This particular issue I've worked around by simply downloading newer postgresql jdbc driver (jar file) and replacing the reference to driver file in the bat / shell script.

[Haric110]

Yes, it is JDK version used in postgresql jdbc driver library. But in newer versions of this library there is new other issue #17 with nullPointerException on getting connection from the connection pool.