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