DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG· RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://issues.apache.org/bugzilla/show_bug.cgi?id=40000>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND· INSERTED IN THE BUG DATABASE.
http://issues.apache.org/bugzilla/show_bug.cgi?id=40000 Summary: tomcat / context freezes when hitting maxActive parameter in (oracle) database resource Product: Tomcat 5 Version: 5.5.17 Platform: PC OS/Version: Linux Status: NEW Severity: major Priority: P2 Component: Catalina AssignedTo: tomcat-dev@jakarta.apache.org ReportedBy: [EMAIL PROTECTED] i have the following in context.xml <Resource auth="Container" name="jdbc/ConnName" type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver" password="mypass" maxIdle="10" maxWait="-1" validationQuery="SELECT SYSDATE FROM DUAL" username="myuser" url="jdbc:oracle:thin:@127.0.0.1:1521:SID" maxActive="25" initialSize="10" /> benchmarking with siege the tomcat server stops responding when it hits the maxActive setting. even when the 25 queries finish on the database server tomcat doesn't seem to return to life ^^. workaround: set maxActive to "-1" and control maximum active processes with the "processes" or "sessions" parameter on the oracle server. i do not know if the same problem exists in conjunction with other databases, i have only tried it with oracle (10g enterprise and XE) setup: apache 1.3.33 on debian stable, mod-jk connector via ajp13, latest ojdbc14.jar from oracle.com, tomcat 5.5.17 jdk 1.5.0_06-b05 BEA Systems, Inc 2.6.8 kernel on a 32 bit x86 smp machine if any additional information is required i hope i can provide it :) -- Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug, or are watching the assignee. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
