Meaningless Drivel is fun!*
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
Author

Threads and Dread

Andrew DevSterMan
Greenhorn

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.

Cheers

Andrew


A carrot is as close as a rabbit gets to a diamond.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Threads and Dread
 
Similar Threads
Object structure for databases in servlets
How to open a connection pool to a database?
Connection pools in WAS 5
How to detect wrong login earlier
Right or not? Servlets share the same object.