Analytics Postgres JDBC Driver

[simonB2020]

I am configuring my Analytics Repository connection.

Am getting the following error which infers that I don't have the PostgreSQL JDBC driver available.

• Unable to connect to the repository
• Cannot create JDBC driver of class 'org.postgresql.Driver' for connect URL 'jdbc:postgresql://xxxxxxxxxxxxx.com/:5432/mydatabase'

I can easily download a jdbc driver, but where do I located the jar so that QEM can find it ?

Thanks for any help ....

[Dana_Baldwin]

Hi @simonB2020 

As long as it's in the Windows path, it should be found by QEM. You may need to restart the QEM service before the driver is recognized.

Hope this helps

Dana

[mitchel66]

Jpa2 and/or Hibernate will do anything you want. I have recently converted a project from Java AppEngine + Google Data Store to SpringBoot + JPA2/Hibernate with various extensions/custom user types to support special Postgres features such as Json/jsonb and array types. And yes it will generate all the tables for you, although you may not want always want that to happen.

[DesmondWOO]

Hi @simonB2020 ,

PostgreSQL JDBC driver should be found under "Attunity\Enterprise Manager\java\external" folder.

Regards,
Desmond