This week's book giveaway is in the HTML Pages with CSS and JavaScript forum.
We're giving away four copies of Testing JavaScript Applications and have Lucas da Costa on-line!
See this thread for details.
Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

Threads and Dread

 
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
    Bookmark Topic Watch Topic
  • New Topic