Roullier... I Can understand you, but you agree to me that is strange? I don't wanna also get into a protracted discussion here... =) I am Brazilian, then almost all days I am happy...=)
But, the enviroment of my application is: WebServices Which I am using Apache Axis, Then I can to use JBoss with TomCat, And uses DBCP from this guy. But, besides this, I will use DataSource to use CMP's. By this trouble, I am asking you about some special configuration using JBoss DataSources, in transaction-services.xml, or something inside dabase-ds.xml, Do you know? Imagine one Application using a big amount of StoredProcedures, So I could not use EntityBeans, the major possibility is to Use SessionBeans. However , I am worried with this problem. Do You can guarantee me that whether always I close my connections, the Pool will work fine? Best Regards Edgar ----- Original Message ----- From: "Guy Rouillier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 02, 2003 12:28 AM Subject: Re: [JBoss-user] Datasource Problems > Edgar, I haven't used Common-DBCP, but I just downloaded it and quickly > read some documentation. I don't want to get into a protracted > discussion here, but there are many reasons why a Tomcat-based > implementation might not exhibit exhausted connections when JBoss does. > For example, JBoss works in a persistent environment. That is, JBoss > run continuously, and your client makes intermittent use of the services > it provides. Between those uses, things like database pools continue to > exist. Things you do in Tomcat, on the other hand, typically have > shorter lifetimes. Much of the time, variables exist only for the > duration of a request, so once a request is finished, everything gets > cleaned up (assuming things are working properly.) There are other > options, of course; you can choose to give things session or application > lifetimes. One of the difficulties in database pooling in a JSP > environment is that there is no place to put a shared pool. > > 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 > ------------------------------------------------------- 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