Connection Problem
От | Rob Stone |
---|---|
Тема | Connection Problem |
Дата | |
Msg-id | 1291728544.3489.28.camel@localhost обсуждение исходный текст |
Ответы |
Re: Connection Problem
Re: Connection Problem |
Список | pgsql-jdbc |
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
Вложения
В списке pgsql-jdbc по дате отправления: