Re: [JDBC] Questions on use

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: [JDBC] Questions on use
Дата
Msg-id CAKFQuwauXz=yMLifau5xkxncy9Zy77nq6d_-xB_7B8PH=67Wdw@mail.gmail.com
обсуждение исходный текст
Ответ на [JDBC] Questions on use  (Rich Shepard <rshepard@appl-ecosys.com>)
Ответы Re: [JDBC] Questions on use
Re: Questions on use
Список pgsql-jdbc
On Wed, Dec 28, 2016 at 8:45 AM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
  PostgreSQL-9.6.1 and openjdk-8u91_b14 are installed on my Slackware-14.1
system and I am trying to use schemaSpy_5.0.0.jar on a couple of databases.
I have downloaded postgresql-9.4.1212.jre6.jar but cannot get schemaSpy to
run.

  1) Is the -9.4.1212 version of the driver compatible with postgres-9.6.1?
If not, is there a working alternative?

​Should work.  The 9.4 doesn't imply server compatability.

  2) My databases are used by only me. All non-postgres-installed databases
are owned by me so neither a username nor a password is required for me to
access them. My login name is used by psql to allow me access. Is the lack
of a password preventing the driver from functioning? If so, is there a way
to inform it that no password is required here?

​The default for PostgreSQL is to listen on Unix sockets.  JDBC doesn't talk to Unix sockets - it only uses TCP/IP sockets.  You need to configure the database to listen on an IP address and port and point to that.  You also need to ensure pg_hba.conf and/or have a password on the user JDBC is using (changing to "trust" might work).

David J.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Rich Shepard
Дата:
Сообщение: [JDBC] Questions on use
Следующее
От: Rich Shepard
Дата:
Сообщение: Re: [JDBC] Questions on use