Yes. It does show that maxactive has reached 100. I also use splunk to get the connection status at the oracle side. What I dont understand is that Resin needs just 50 connections to handle the same load. I am in the process of increasing the count to 300 and see if that makes a difference. Oracle has the capacity to handle that many connections.
On Thu, Jun 28, 2012 at 11:01 AM, Hedrick, Brooke - 43 < brooke.hedr...@rainhail.com> wrote: > > > -----Original Message----- > > From: Yasser [mailto:yarafa...@gmail.com] > > Sent: Thursday, June 28, 2012 9:44 AM > > To: users@tomcat.apache.org > > Subject: Tomcat 7.0.28 connection pool issue > > > ... > > What is the issue? > > When we run a stress test on the same codebase deployed to Tomcat 7.0.28, > > at about 2hr45min into the test with 530 virtual users logged in (at > peak load), > > I get a lot of connection pool empty errors. The maxactive attribute > (using > > tomcat connection pool) has been set to 100. > > > > Have you used jconsole to monitor the pool usage? > > -Brooke > > > Other information: > > CAS runs on a different server with a dedicated tomcat home and base. I > > dont see any errors on this box. > > 7.0.26 was found to have a bug in the way connection count is determined, > > which got fixed in 7.0.28, hence we switched to the latest version. > > > > Here is one of the connection pool config from server.xml. We do a > resource > > link to this pool in the context.xml > > > > <Resource name="jdbc/global-wl" auth="Container" > > type="javax.sql.DataSource" username="webconnect" > > password="xxxxxxx" > > driverClassName="oracle.jdbc.driver.OracleDriver" > > > > url="jdbc:oracle:thin:@&&dbs.ip&&:&&oracle.db.port&&:&&dts.dbname&& > > " > > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" > > maxActive="100" /> > > > > Any help is appreciated. Please let me know if you need more information > or > > code snippets. > > > > Thanks, > > > > Yasser > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
