File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes Threads and Dread Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Threads and Dread" Watch "Threads and Dread" New topic

Threads and Dread

Andrew DevSterMan

Joined: Nov 26, 2003
Posts: 6
Hi there.

I've been running up a new website, using Struts, the DAO pattern and Apaches DBCP (database connection pool).

Somewhere in here I have an action to do a search against the database. This takes about 2 seconds to return.

This opens up say 40 connections in the pool.

If I lean on F5 submitting request after request, and open the same page in a different browser, I don't get a results until my connection pool settles down to 0 again.

Is this because

- the request is the last one, and gets serviced last.
- the DB pool is doing something funny.
- I've totally missed something and everyone has to queue when accessing the database.

I'm worried. All my code if pretty clean, but I don't know how to test this to see if I can get any concurrency. I'm using tomcat 5.

Other pages continue to respond beatufiully.



A carrot is as close as a rabbit gets to a diamond.
I agree. Here's the link:
subject: Threads and Dread
It's not a secret anymore!