Message-ID: <002501c336cd$02b110a0$d400a8ca@zhuj2k>
From: "zhuj" <zhuj@dragontec.com.cn>
To: <Dave@micro-automation.net>
Cc: <pgsql-jdbc@postgresql.org>
References: <00dc01c334b2$04876130$d400a8ca@zhuj2k>
	<1056054233.1307.37.camel@localhost.localdomain>
	<001701c336c7$c5013b90$d400a8ca@zhuj2k>
	<1056070724.1307.47.camel@localhost.localdomain>
Subject: Re: maxconnection
Date: Fri, 20 Jun 2003 09:41:03 +0800
MIME-Version: 1.0
Content-Type: text/plain;
	charset="gb2312"
Content-Transfer-Encoding: 7bit

I am testing our connection pool program.
The constructor of connection pool class
shows below:
public ConnectionPool(int size, int maxSize) throws  SQLException {
    try {
        this.size = size;
        this.maxSize = maxSize;
        for (int i = 0; i < this.size; i++) {
            PooledConnection pooledConnection = (PooledConnection)
                   DataSource.this.getPooledConnection();// get connection
from postgres
            if (this.connectionMemento == null)
                  this.connectionMemento =
pooledConnection.createConnectionMemento();
            pooledConnection.addConnectionEventListener(this);
            this.pool.add(pooledConnection);
        }
    } catch (SQLException e) {
        closeAll(this.pool);
        throw e;
    }
}

the details of getPooledConnection() method:
public javax.sql.PooledConnection getPooledConnection() throws SQLException
{
        return new PooledConnection(DriverManager.getConnection(this.url,
this.user,
               this.password));
}

The test program create the ConnectionPool object:
    new ConnectionPool(30, 50);

if max connection is set to 25, "new ConnectionPool(30, 50)"
should throw SQLException. But it did not. It runs normally.


----- Original Message -----
From: "Dave Cramer" <Dave@micro-automation.net>
To: "zhuj" <zhuj@dragontec.com.cn>
Cc: <pgsql-jdbc@postgresql.org>
Sent: Friday, June 20, 2003 8:58 AM
Subject: Re: [JDBC] maxconnection


> Really, what happens? I am pretty sure you won't get more than 25
> connections.
>
> Dave
> On Thu, 2003-06-19 at 21:03, zhuj wrote:
> > I try to edit the postgresql.conf, set
> > "max_connections " to 25 then restart
> > postgres, but it seems not work.
> >
> > ----- Original Message -----
> > From: "Dave Cramer" <Dave@micro-automation.net>
> > To: "zhuj" <zhuj@dragontec.com.cn>
> > Cc: <pgsql-jdbc@postgresql.org>
> > Sent: Friday, June 20, 2003 4:23 AM
> > Subject: Re: [JDBC] maxconnection
> >
> >
> > > You have to limit the connections on the backend, in postgresql.conf.
> > >
> > > Dave
> > > On Tue, 2003-06-17 at 05:22, zhuj wrote:
> > > > hi,all:
> > > >     I want to constraint the maximum number of concurrent
connections to
> > 25
> > > > in postgres
> > > > jdbc driver. There are no methods for this
> > > > change. How would i do?
> > > >
> > > > TIA
> > > >                                  zhuj
> > > >
> > > >
> > > >
> > > > ---------------------------(end of
broadcast)---------------------------
> > > > TIP 3: if posting/reading through Usenet, please send an appropriate
> > > >       subscribe-nomail command to majordomo@postgresql.org so that
your
> > > >       message can get through to the mailing list cleanly
> > > >
> > > --
> > > Dave Cramer <Dave@micro-automation.net>
> > >
> > >
> >
> --
> Dave Cramer <Dave@micro-automation.net>
>
>