Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Using SSL without Certificate Validation - Oracle SQL Developer

I am trying to connect to AWS Postgresql, which is SSL enabled, but I use Non validating factory parameter. Usually When I do this using any other client, I specify this parameter

ssl=TRUE&sslfactory=org.postgresql.ssl.NonValidatingFactory

But unfortunately I am not able to do the same with Oracle SQL developer. I keep getting this error when I modified the hostname to have these parameters. - Status : Failure -Test failed: The SSLSocketFactory class provided org.postgresql.ssl.NonValidatingFactory:/ could not be instantiated.

Can anyone suggest how to do this?

like image 572
ds_user Avatar asked Nov 26 '25 03:11

ds_user


1 Answers

Ok, I got the answer, updating here in case if anyone facing the same issue. I just changed the hostname to have these parameter and added '&' at the end.

Something like this,

yourhostname:portname/databasename?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory&
like image 128
ds_user Avatar answered Nov 28 '25 15:11

ds_user