On 12/27/2013 4:31 AM, Milan wrote:
Hello to All,
...
(Lots of good information snipped)
- 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.
To me, this "feels" like an issue with the database or your app's
connections to it. A few of possibilities come to mind:
1. there is a rogue query in your app that is taking a very long
time to return.
2. You are running out of db resources, such as connections or open
statements, and it is blocking other operations while waiting for
resources to be freed up.
3. A query or other db operation is blocking (due to record locks
or similar things) for a long time, and the users time out while waiting
for the block to be released.
So, to help isolate the problem, a few questions:
1. When this is happening, is it only this client who is affected,
or are others stopped as well?
2. What are the cpu and memory usage during the hang time? 8GB
doesn't seem like a lot of memory for SQL Server Enterprise when it's
sharing a machine with other services.
3. Is the memory usage pretty steady, or is it going up over time
before you get this hang?
While I restart my Apache Tomcat 5.0.28 Service, the web apps start
responding smoothly again as in normal state.
The issue’s 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 app’s 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
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
