Need help!

[Sergey Livanov <Se...@ukrpost.net>]

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:Sergey.Livanov@ukrpost.net


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org