Question

How to add postgresql jdbc driver

I add jdbc driver add knowage/lib

But i can not connect i get this error

[http-nio-8080-exec-7] 10 Feb 2020 19:34:18,166 ERROR it.eng.spagobi.tools.datasource.service.rest.TestConnection.testDataSourceNew:217 - Error testing datasources
java.lang.ClassNotFoundException: org.postgresql.Driver

Answer 1

You have to add postgres jdbc in Knowage-Server-CE/lib folder

then update conf files (all hibernate.cfg.xml ...)

(source: configuration-of-the-metadata-db-dialect)

Comments

Dear

If you are connecting to PostgreSQL to read data only (I mean not for metadata database ) you don't change hibernate.cfg.xml

Best Regards

ANgelo