I upgraded my Openhabian to 3.0 (btw - AMAZING upgrade), I used to have postgresql configured in my persistence, but now I am getting the following. Also putting the jar file in the addon directory does not resolve the issue.
2020-12-26 19:05:43.422 [ERROR] [ence.jdbc.internal.JdbcConfiguration] - JDBC::updateConfig: could NOT load JDBC-driverClassName or JDBC-dataSourceClassName. ClassNotFoundException: 'org.postgresql.
Driver cannot be found by org.openhab.persistence.jdbc_3.0.0'
2020-12-26 19:05:43.425 [WARN ] [ence.jdbc.internal.JdbcConfiguration] -
To avoid this error, place an appropriate JDBC driver file for serviceName 'postgresql' in addons directory.
Copy missing JDBC-Driver-jar to your openHab/addons Folder.
PostgreSQL:version >= 9.4.1208 from https://mvnrepository.com/artifact/org.postgresql/postgresql
Interesting the maven website only goes to 9.4.1206 and the link I gave was for the much newer 42.x versions. Remove the jar that was linked in my post as it probably is too new and the bundle:list is showing 9.4.1212 is active on your system.
Have you tried a reboot?
I am not familiar with that library sorry, it may be that you need the exact version that it is asking for if there were breaking changes in the newer 9.4.1212 version.
I tried reboot, nothing - also finally figured the addon repository contains the bundled 9.4.1212 postgresql version so I guess without hacking the kar file, not sure you can actually change the jdbc version. Knowing that it is a JDBC issue, I’m worried that there is another error trying to load the driver that might not be visible in the logs… I need to figure out how logging works in this new version…
Something else rather odd - I decided to use InfluxDB 2 as main persistence and stopped the postgresql database. When I did this, I started to see Java exceptions coming from the postgresql driver itself - so something was working although it complained about driver.