Our postgres server forces connection via SSL only. Can I still use Hibernate for my java process to persist/retrieve objects?

Hi gorcasvlatin,

if you want to access your PostgreSQL you can use an SSH tunnel and port forward the remote database port to your local host. Refer to the PostgreSQL documentation.

If you establish the tunnel before you access the DB this should be possible, I guess (without knowing).

CU
Froestel

Hmm, that's not the answer I was hoping to hear. I am not the DBA and cannot turn off SSL. I am not the SA for the box in production so I cannot forward ports.

I was hoping Hibernate would own the DB connection and would connect using SSL. Perhaps a flag or setting can be turned on to tell it to do this?

Hi gorcasvlatin,

so I guess you have to rely on the PostgreSQL JDBC Driver that you have access to in your app. Take a look at this documentation page. You should be able to configure a connection to your PostgreSQL server using SSL.

CU
Froestel