Обсуждение: Re: DataSource.setMaxConnections() - Does not work

Поиск
Список
Период
Сортировка

Re: DataSource.setMaxConnections() - Does not work

От
Michael Andreasen
Дата:
Even though I set it at 3, if I look on the server I can see many more connections have been made?


On Sat, Sep 26, 2009 at 2:25 PM, Michael Andreasen <michael@dunlops.com> wrote:
Hi,

Using version: 8.3-605.jdbc3

DataSource.setMaxConnections() does not work.

I create my datasource as such;
dataSource = new PGPoolingDataSource();
        dataSource.setServerName("10.44.73.50");
        dataSource.setDatabaseName("ops");
        dataSource.setUser("postgres");
        dataSource.setPassword("postgres");
        dataSource.setMaxConnections(3);

--
Regards,
Michael Andreasen
Senior Analyst / Developer



--
Regards,
Michael Andreasen
Senior Analyst / Developer

Re: DataSource.setMaxConnections() - Does not work

От
Kris Jurka
Дата:

On Sat, 26 Sep 2009, Michael Andreasen wrote:

> Even though I set it at 3, if I look on the server I can see many more
> connections have been made?

The three connection limit is the most the datasource will open for you,
but it cannot prevent other people/processes from opening other
connections to the server.  If you really believe all of these are being
opened by the datasource, perhaps you really have many instances of the
datasource, each of which will open up to three connections.

Kris Jurka