Hello to All,
Before stating my question or problem I am facing, let me gives you the
complete architecture we are currently using.
- Intel Xeon CPU 3.20 GHz (2 Processor)
- Windows Server 2008 Standard
- RAM 8.00 GB
- JDK 1.6 (With following JAVA_OPTS Environment Variable value
-Xmx1024M)
- Microsoft SQL Server 2008 Enterprise
- Oracle 10g (On different Physical machine)
- Apache Tomcat 5.0.28 Server
- Single Web Application on Apache Tomcat 5.0.28 Server
- Single Database in Microsoft SQL Server 2008 Enterprise
- Both Microsoft SQL Server 2008 Enterprise and Apache Tomcat
5.0.28 Server is on same physical as well as logical machine
- The Web is simultaneously communicating with Oracle 10g and
Microsoft SQL Server 2008 Enterprise for Database transaction.
- There are around 15 to 20 users are using this web apps
simultaneously.
- The Web Apps is used on Hand Held Terminals having Windows CE OS.
- Hand Held Terminals are connected using Wi-Fi access point. This
access point again connected to server using LAN wire (LAN Network).
- Hand Held Terminals (Wi-Fi) àAccess
Point(Wi-Fi)àSwitchàServer(Via LAN).
- Each transaction, i.e. Data Insertion in both Database took
around 3 to 5 seconds.
- We have used DBCP for Database connection.
- When data insertion took place we are using servlet for
transaction to Database. So request raise from JSP to Servlet.
Now the issue I am facing right now is in a middle of any transaction to DB
or say while user try to opening any form or try to load the application in
IE,
He/she does not get any response in browser, the browser simply display
progress bar and keep on processing and then after fair enough time(say 2 to
3 Minutes). Its stop processing page.
While I restart my Apache Tomcat 5.0.28 Service, the web apps start
responding smoothly again as in normal state.
The issues frequency in one day is 3 to 4 time at any given time, say
randomly. They called it Hanging of Apache Tomcat, but I am not still
fully sure what is actually happening.
Following is my web apps context.
<Resource name="jdbc/wipo" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/wipo">
<parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourc
eFactory</value></parameter>
<parameter><name>driverClassName</name><value>oracle.jdbc.driver.OracleDrive
r</value></parameter>
<parameter><name>url</name><value>jdbc:oracle:thin:@IP:PORT:SID</value></par
ameter>
<parameter><name>username</name><value>UNAME</value></parameter>
<parameter><name>password</name><value>PASS</value></parameter>
<parameter><name>maxActive</name><value>500</value></parameter>
<parameter><name>maxIdle</name><value>75</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>
<Resource name="jdbc/wips" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/wips">
<parameter><name>url</name><value>jdbc:sqlserver://IP:PORT;forwardReadOnlyMe
thod=serverCursor;loginTimeout=30;databaseName=dbname</value></parameter>
<parameter><name>driverClassName</name><value>com.microsoft.sqlserver.jdbc.S
QLServerDriver</value></parameter>
<parameter><name>username</name><value>UNAME</value></parameter>
<parameter><name>password</name><value>PASS</value></parameter>
<parameter><name>maxActive</name><value>500</value></parameter>
<parameter><name>maxIdle</name><value>75</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>
While this particular situation arises, my tomcat service shows running.
Please help me with this issued as I am able to resolve it.
Manny Thanks.
Thanks and Regards,
Milan Dalsaniya
BIPL
