Re: Problems using Tomcat 7 connection pool to PostgreSQL with Axis2
Deepal jayasinghe <[email protected]>
| Newsgroups | gmane.text.xml.axis.user |
|---|---|
| Message-ID | <[email protected]> |
I guess main issue is not closing the connections (or rather not reusing them). So any approach that helps you to reuse the connections would help to resolve the issue. In the article I mentioned an approach, but there could be many. One thing you need to make sure is depending on the request scope you might have a large number of services instances so does the DB connections. Deepal >> This might give you some light. >> >> http://www.developer.com/db/article.php/3735771/Exposing-a-Database-as-a-Web-Service.htm >> >> Deepal > Darren said that he is using a connection pool, not the DriverManager > API. In that case, you manage connections differently than the pattern > shown in your article. If you use that pattern together with a > container managed connection pool, then it becomes an anti-pattern. > > Andreas > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >