Re: Bug (?) in JDB

From: "Harald Armin Massa" <haraldarminmassa(at)gmail(dot)com>
To: Calum <caluml(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Bug (?) in JDB
Date: 2008-01-28 17:00:45
Message-ID: 7be3f35d0801280900l36c81fc9g6c7c5fc2f7484da3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Calum,

I do not know about Java and jdbc, but had similiar problems with
various Python-Database adapters. Have you double-checked that true
and false are valid options?

at http://www.postgresql.org/docs/current/interactive/libpq-connect.html
you can read

sslmode

This option determines whether or with what priority an SSL
connection will be negotiated with the server. There are four modes:
disable will attempt only an unencrypted SSL connection; allow will
negotiate, trying first a non-SSL connection, then if that fails,
trying an SSL connection; prefer (the default) will negotiate, trying
first an SSL connection, then if that fails, trying a regular non-SSL
connection; require will try only an SSL connection.

If PostgreSQL is compiled without SSL support, using option
require will cause an error, while options allow and prefer will be
accepted but libpq will not in fact attempt an SSL connection.

so probably you should use "disable" instead of "false", and "require"
or "prefer" instead of true?

Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dominique Bessette - Halsema 2008-01-28 17:30:28 close connection
Previous Message Harald Fuchs 2008-01-28 16:53:51 Re: Is news.postgresql.org down?

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2008-01-28 17:53:50 Re: backpatching 8.2 to deal with batch callable statements
Previous Message Dave Cramer 2008-01-28 13:42:07 backpatching 8.2 to deal with batch callable statements