search

dbacvetkov / PASH-Viewer

PostgreSQL ASH Viewer (PASH Viewer) provides graphical view of active session history data within the PostgreSQL database
GNU General Public License v3.0
120 stars 18 forks source link

SQL Exception occured: ERROR: column "waiting" does not exist #20

Open vsbace opened 1 year ago

vsbace commented 1 year ago

Hi, i have a problem with connecting to PostgreSQL database instance 14 version with the next error: SQL Exception occured: ERROR: column "waiting" does not exist Position: 216 java.lang.NullPointerException

vsbace commented 1 year ago

I have installed extensions: image

lex-sey commented 1 year ago

before run .\gradlew.bat assembleDist add files to PASH-Viewer-master\build\classes\main\org\ash\database\ ASHDatabasePG14.class ASHDatabasePG14ASH.class as copy ASHDatabasePG13.class ASHDatabasePG13ASH.class and add to PASH-Viewer-master\src\org\ash\gui\MainFrame.java 338 if (versionOracleDB.startsWith("13")) { if(ASHsupport) { this.database = new ASHDatabasePG13ASH(this.model); } else { this.database = new ASHDatabasePG13(this.model); } } else if (versionOracleDB.startsWith("14")) { if(ASHsupport) { this.database = new ASHDatabasePG14ASH(this.model); } else { this.database = new ASHDatabasePG14(this.model); } }

vsbace commented 1 year ago

Hi,

Thank you very much. I did all recommendations and compile JAR archive in a separate branch. All works is correct!