At any rate, I provided one suggestion in my last message which may allow you to determine in a JBoss environment if you are indeed leaking connections.
Edgar Silva wrote:
Hi Roullier, this behavior of the JBoss's DataSource is very strange, because I solved this trouble changing the Datasource from JBoss to TomCat. I Know that TomCat uses Jakarta Commons DBCP, and with this Container I solved all my troubles, when JBoss arrives in a number of connection greater than 200 ,Then JBoss Crashes. This number was defined in XML Configuration. The right behavior from a DataSouce that I Believe is: Make the Connections and after client uses it, this object will be consumed by other client. When I made the deploy of the same application, changing only lookup statement to TomCat Requirements, The Application is working fine now, And in each test I had only of 2 to 6 Connections established. Then I am in doubts about JBoss's Datasources to provide Connection Pool. But, I know that can be my technical problem, however I had been using several other J2EE Containers like Borland, BEA and IBM , And I do not remember of fails like this. I will buy the JBoss Documentation, then who knows I will can understand it better. Because is like a friend talks: "The software is free, however the work is not slave". And I hope solve many problems after read some Chapters in JBoss's Documentation. I like too much JBoss, in addition to this I am trying to migrate many projects to JBoss. Because is free, and I Believe in the Project.
If you know some article or resource talking about Connection Pooling of Datasouces in JBoss would be cool.
I am using JBoss 3.2, Oracle 9.i, in a RedHat 7.2 .
Thanks by help friend ...
Edgar
----- Original Message ----- From: "Guy Rouillier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 01, 2003 6:08 PM Subject: Re: [JBoss-user] Datasource Problems
Edgar, please identify what version you are using. I'm not saying what you are seeing isn't true, but as you know from these forums, inevitably when a runaway connection problem appears, it is because of the application not closing connections somewhere. That "somewhere" is not always easy to find. We've been using Oracle 9i for quite some time now (at least a year) and some of our EJBs have been running for 150 days without exhausting connections.
Perhaps one easy place to start is to turn on tracing for a particular datasource this is happening with. You should be able to watch the logs and do a count of connections obtained from the pool and returned to the pool. These 2 numbers should obviously stay the same.
Edgar Silva wrote:
Hi All...
My friends, I spent almost 3 weeks with a big problem with JBoss's DataSource.
I am using Oracle, and I am sure of to close the connections after my events. However, seem never JBoss closes these connections... Then this fact happens every time , until to explode the number of connections, causing JBoss's restart.
In more details: The number of connections grow from: 3-12-20-26-30-46.......214.... Then the service fails.
This Application is WebService providing searches against a DataBase, with some services with EJB and JMS. The only problem is above, with connections about DataSource.
I am using Oracle 9i and the newest jdbc driver....
Any Idea?
Since now Thanks
Edgar
------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
-- Guy Rouillier
------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
-- Guy Rouillier
------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user