Re: [GENERAL] Bug (?) in JDB - Mailing list pgsql-jdbc

From Harald Armin Massa
Subject Re: [GENERAL] Bug (?) in JDB
Date
Msg-id 7be3f35d0801280900l36c81fc9g6c7c5fc2f7484da3@mail.gmail.com
Whole thread Raw
In response to Bug (?) in JDB  (Calum <caluml@gmail.com>)
List 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!

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: backpatching 8.2 to deal with batch callable statements
Next
From: Kris Jurka
Date:
Subject: Re: backpatching 8.2 to deal with batch callable statements