CR2020 and PostgreSQL JDBC Driver

[vitaly_izmaylov]

Hi All,

I'm working with CR2020 and trying to connect to a PostgreSQL database. I have downloaded the PostgreSQL drivers and added them correctly to the classpath. CR2020 recognizes them (it initially was giving me the no driver found error until I fixed that config).

No when I try to connect to the database, I get:
"Logon Failed: Details: SQL Exception: [SQL State:] 08001 [Error Message] The connection attempt failed"

I am successfully able to connect to this database using the PGAdmin tool on the same endpoint, so this does not appear to be a networking issue.

PostgreSQL version is 11.9

JDBC driver version is 42.2.18 from postgresql.org which states it supports this DB version.

I am using the PostgreSQL "dvdrental" sample database for testing.

Connection URL is formatted as jdbc:postgresql://<mydatabaseurl>:5943/dvdrental

Database Classname is : org.postgresql.Driver

Database is set to: dvdrental

User ID and PW have been verified valid via PGAdmin connection.

Any advice appreciated. I'm not sure of what other steps I can try. Driver and connection seem to be good. I supsect issue is something to do with where/how CR2020 expects the db name.

Thanks much.

[vitaly_izmaylov]

Have you configured the connection in CRConfig.xml file?

[Former Member]

vitaly.izmaylov Yes. Originally was having the driver not recognized problem and solved that by adding the classpath to CRConfig.xml. After I configured that correctly, the driver not recognized problem went away, and left me with the current Error 08001 problem.