I was able to get my web service working by storing the DataSource (instead of the connection) in the ConfigurationContext and just getting connections from the persisted DataSource each time the service is invoked.
It turns out someone else did something similar on 12/30/2011-- http://mail-archives.apache.org/mod_mbox/axis-java-user/201112.mbox/%3ccb2355cb.3606e%25z...@adobe.com%3E Thanks for the replies. Darren -----Original Message----- From: Deepal jayasinghe [mailto:deep...@gmail.com] Sent: Friday, September 21, 2012 18:34 To: java-user@axis.apache.org Subject: Re: Problems using Tomcat 7 connection pool to PostgreSQL with Axis2 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-a >> s-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: java-user-unsubscr...@axis.apache.org > For additional commands, e-mail: java-user-h...@axis.apache.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: java-user-unsubscr...@axis.apache.org For additional commands, e-mail: java-user-h...@axis.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: java-user-unsubscr...@axis.apache.org For additional commands, e-mail: java-user-h...@axis.apache.org
