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

Re: Connection Problem

From: Thomas Markus <t(dot)markus(at)proventis(dot)net>
To: Rob Stone <robstone(at)mira(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Connection Problem
Date: 2010-12-10 07:27:50
Message-ID: 4D01D676.6080209@proventis.net (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

maybe this is your problem 
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=560056

try to start your java class with -Djava.net.preferIPv4Stack=true

regards
Thomas

Am 07.12.2010 14:29, schrieb Rob Stone:
> Good morning,
>
> I don't know if I've done something really stupid or if I've stumbled on
> a bug.
>
> Run Debian on my laptop, version 2.6.32-3-686. Downloaded the PostgreSQL
> 9.0.1 source and compiled it following all the instructions. Downloaded
> the PGAdminIII 1.12 source plus heaps of .cpp files, compiled it. I can
> access the 9.0 database via psql or PGAdmin, view the database I
> created, display data in tables. (Not much to display at present but
> some rows exists in a couple of tables.)
>
> Downloaded the JDBC driver postgresql-9.0-801.jdbc4.jar, put it in my
> CLASSPATH, etc.
>
> Downloaded the latest version of ExecuteQuery, declared the new driver,
> created a connection to my 9.0 database using the new driver but unable
> to connect to the database. See stack trace attached.
>
> Postmaster is started with the -i option which I believe is the same as
> saying "listen_addresses='*'".
>
> Using jdk1.6.
>
> Wrote a mickey mouse java class (testdbconn) to see if I could access
> the database and read data from a table that has two rows. See attached.
> When it runs it displays the same SQL error code as ExecuteQuery --
> 08001 -- which is the "can't connect error".
>
> The developer of ExecuteQuery is a former colleague of mine and a
> friend. We have been sending each other e-mails about this trying to
> suss out the problem.
>
> Obviously, I have installed something incorrectly OR there is something
> awry with java making the connection. psql and PGAdmin talk directly to
> the database without using a JDBC driver. Seeing as they are both
> functioning normally, what have I done to cause java to pull connect
> errors???
>
> Any advice will be greatly appreciated.
>
> Cheers,
> Rob
>
>
>


In response to

pgsql-jdbc by date

Next:From: Francesco DegrassiDate: 2010-12-10 08:07:04
Subject: Postgresql XA prepare() method behaviour
Previous:From: Dave CramerDate: 2010-12-10 01:18:12
Subject: Re: Connection Problem

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