Client's server with applications stops ~ 1 in two days. Configuration: Win2003 server, sp4, Tomcat 5.12, Oracle 9.2. I'd like to ask a couple of questions
1. Is there a method to have a load on 80 роrt, determine the number of inquiries and see how the system operates? 2. Do I need the Shareable parameter in в web.xml? <resource-ref> <description>Database Reference</description> <res-ref-name>ORAPOOL</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> <res-sharing-scope>Shareable</res-sharing-scope> </resource-ref> 3. Are my Tomcat Connection pool parameters normal? <Resource auth="Container" description="Oracle 9i database" name="portalDataSource" scope="Shareable" type="javax.sql.DataSource" /> <ResourceParams name="portalDataSource"> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> <parameter> <name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value> </parameter> <parameter> <name>url</name> <value>jdbc:oracle:thin:@192.168.0.10:1521:APPL</value> </parameter> <parameter> <name>username</name> <value>username</value> </parameter> <parameter> <name>password</name> <value>pwd</value> </parameter> <parameter> <name>maxActive</name> <value>80</value> </parameter> <parameter> <name>maxIdle</name> <value>40</value> </parameter> <parameter> <name>maxWait</name> <value>10000</value> </parameter> <parameter> <name>removeAbandoned</name> <value>true</value> </parameter> <parameter> <name>removeAbandonedTimeout</name> <value>60</value> </parameter> <parameter> <name>logAbandoned</name> <value>true</value> </parameter> </ResourceParams> Any advises ? Help & advises are appreciated ! regards, Sergey mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]