Forum Discussion

eshanbhatt's avatar
eshanbhatt
New Contributor
4 years ago

Conection attempt failing when using JDBC

Can’t connect to my JDBC database Error: Failed to validate account: Failed to retrieve a database connection. Cause: The connection attempt failed. (Reason: The connection attempt failed.; Resolut...
jdbc
bojanvelevski's avatar
bojanvelevski
Valued Contributor
4 years ago

Hey @eshanbhatt,

I’ve also had some issues with JDBC snaps in the past, especially with the Select. As I remember my error was related to the tables, and switching to Execute snap with query, fixed the problem. You can give it a try.

I hope this helps,
Bojan

eshanbhatt's avatar
eshanbhatt
New Contributor
4 years ago

Hi @bojanvelenski,

Thanks for the quick response.

I’ve tried the same steps with all JDBC snaps. My issue is within the Account Setup, where I’ve tried with different postgresql jars but the account validation itself is failing.

The error is also not clear if there is an issue with my server or driver or some issue with snapLogic.