From: LEON <ldai@accunettech.com>
To: Paul Thomas <paul@tmsl.demon.co.uk>
To: Achilleus Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-sql @ postgresql . org <pgsql-sql@postgresql.org>
Subject: Re: How can I to solute this problem?
Date: Wed, 30 Jul 2003 17:43:39 +0800
Message-ID: <001a01c3567f$0f356a20$1f00a8c0@leon> (raw)
References: <20030729082305.A23245@bacon>
<Pine.LNX.4.44.0307291409400.27224-100000@matrix.gatewaynet.com>
<20030729133703.G25238@bacon>
Hi,Thank your help yesterday.
Now I met a new question.
When I continued to clicking UI(jsp) some time, I will get a error in page.It is "Http 404" and Exception is "NullPoinerExcaption".
I checked the log of tomcat. It recorded a message"connected database failed. The user perporty is missing. It is mandoatory".
netstat | grep postgres |wc -l
The connection number is 278
lsof -i :5432 | wc -l
60
How can I solute this problem?
Is there bug in postgresql's jdbc?
Could you give me help?
Best regards
leon
2003-07-30
----- Original Message -----
From: "Paul Thomas" <paul@tmsl.demon.co.uk>
To: "Achilleus Mantzios" <achill@matrix.gatewaynet.com>
Cc: "LEON" <ldai@accunettech.com>; "pgsql-sql @ postgresql . org" <pgsql-sql@postgresql.org>
Sent: Tuesday, July 29, 2003 8:37 PM
Subject: Re: [SQL] How can I to solute this problem?
> On 29/07/2003 17:09 Achilleus Mantzios wrote:
> >
> > You may take a look at jboss connection pool
> > mechanism. (postgresql.xml)
>
> He doesn't mention JBoss, just Tomcat so I don't believe the
> postgresql.xml will help him much. He could use Tomcat's built-in
> connection pooling
> (http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html)
> but should note that there is an error in the web.xml fragment:
> <res-ref-name>jdbc/mydb</res-ref-name> should be
> <res-ref-name>jdbc/postgres</res-ref-name>. Leon, if you need more help
> please feel free to contact me off-list.
>
> >
> > Also a good way of ensuring that your app will
> > not leave open stale postgresql connections
> > is to initially configure your pool to only have a small
> > number of connections (e.g. 2,3).
>
> Good advice for any form of connection pooling.
>
> >
> > If your J2EE components (e.g. jsps) are fast enough
> > you should start facing connection shortages
> > only after the load on your machine increases
> > significantly. (and then safely increase the maximum
> > number of connections in your configuration (both postgresql wise
> > and app server (conn pool) wise).
> >
> >
> > On Tue, 29 Jul 2003, Paul Thomas wrote:
> >
> > >
> > > On 29/07/2003 07:18 LEON wrote:
> > > > I use tomcat+linux_postgresql+jsp to develop system.
> > > >
> > > > I start postgresql with 1024 processes.
> > > > FE:
> > > > postmaster -i -S -N 1024 -B 2048 -D /var/lib/pgsql/data
> > > >
> > > > My jsp doesn't implement connection pool.It directly connects
> > postgresql
> > > > by jdbc.
> > >
> > > IME, that is not a good way to do it. Use a connection pool.
> > >
> > > > After I run the Ui some times, the UI(jsp) would report "ieSorry,too
> > many
> > > > clientslg" .The exception is SQLException.
> > > >
> > > > I must restart tomcat or postgresql I can continue to running my UI.
> > >
> > > My guess would be that you have a bug in your application which is not
> > > always closing the connection so eventually you exceed max_connections.
> >
> > > You should always close the connection in a finally{} block so that is
> > > guaranteed that it will be closed regardless of any earlier exceptions
> > > which are thrown.
> > >
> > > HTH
> > >
> > >
> >
> > --
> > ==================================================================
> > Achilleus Mantzios
> > S/W Engineer
> > IT dept
> > Dynacom Tankers Mngmt
> > Nikis 4, Glyfada
> > Athens 16610
> > Greece
> > tel: +30-210-8981112
> > fax: +30-210-8981877
> > email: achill at matrix dot gatewaynet dot com
> > mantzios at softlab dot ece dot ntua dot gr
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ldai@accunettech.com, paul@tmsl.demon.co.uk, achill@matrix.gatewaynet.com
Subject: Re: How can I to solute this problem?
In-Reply-To: <001a01c3567f$0f356a20$1f00a8c0@leon>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox