Roullier...
I Can understand you, but you agree to me that is strange?
Not really, seems to me to be an apples to oranges comparison. Sure, at a basic level we are all talking about data sources, but the runtime semantics are very different.
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?
Sorry, I don't understand the question.
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?
I doubt you will find any open source project that will guarantee anything. However, I will point out that datasources are one of the most heavily used components in JBoss. If there was a basic connection leak, many people would have encountered it by now (and thus it would have been fixed.)
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
-- 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
