โ10-14-2019 12:31 AM
Hi,
While trying to connect PostgreSQL using JDBC getting below error.
.
Could you please help to resolve this issue.
Thanks in advance!
Thanks,
Venu
โ10-14-2019 03:13 AM
Hi,
I donโt understand what is the exact issue. Can any one help here please as this is on priority . Itโs very urgent
Thanks,
Venu
โ10-15-2019 12:59 AM
Hi, can you try this:
When connecting to an SSL enabled PostgreSQL account, the account fails in validation. To overcome this, configure the URL properties in Account settings to establish an SSL connection with the following parameter and value:
URL property name | URL property value |
---|---|
sslmode | require |
or try
URL property name: ssl
Value: true
โ10-15-2019 06:07 AM
Hello Venu,
Your screenshot shows the โMin pool sizeโ was reduced from the default value of 3 to 0. Can you return that value back to the default value then try again?
Documentation link for PostgreSQL account:
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438860/PostgreSQL+Account
โ10-16-2019 03:11 AM
Many thanks !
Itโs now working