Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-jdbc by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group