Re: Embedding Postgres in Java Application

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Embedding Postgres in Java Application
Дата
Msg-id 41EAC2F8.1070502@hogranch.com
обсуждение исходный текст
Ответ на Embedding Postgres in Java Application  (Jasper Potts <jasper@squarepark.com>)
Ответы Re: Embedding Postgres in Java Application
Список pgsql-jdbc
Jasper Potts wrote:
> I am developing a desktop GUI application and am using postgres 8. I
> need to be able to embed/bundle postgres with my application. To start
> with I am releasing on windows with Linux and OSX later.
>
> Is there a way of creating a JDBC connection to the db not over a
> network socket?

not only does JDBC not support unix sockets, neither does Windows.


> The other way is going to be to start/stop the database from Java by
> calling "pg_ctl start/stop". But that issues with this because of the
> windows restrictions that postgres can't be run as a user with admin
> privileges. Any Ideas?

I'd suggest your windows installer install postgres as a system service by
cloning the operation of the standard windows installer for pgsql, and you use
localhost for your database connections.   If you're using a java installer
that doesn't understand windows services, maybe you could put it in a MSI
(Microsoft Installer) wrapper that invokes both Postgres's MSI based
installation and your java installer.


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

Предыдущее
От: Jasper Potts
Дата:
Сообщение: Re: Embedding Postgres in Java Application
Следующее
От: Jasper Potts
Дата:
Сообщение: Re: Embedding Postgres in Java Application