RE: commons dbcp or pool problems

[Gerhard Froehlich]

Hi,
 
>I have reviewed the customers JSP pages and found one page
>where they were not wrapping their use of a db connection within a
>try {} block.  I have informed them how to fix it.
>
>But this one page does not explain running out of connections in a pool
>with a max of 75 connections.  In the logs that page only failed twice
>during the run of Tomcat before it ran out of db connections.

I know deadline is coming closer, customer is in a bad mood and the
requirements are doubled during the project, but I recommend to avoid
any SQL and Busines Logic in JSP. They are hard to debug and somehow
that's dirty. IMHO JSP it's for presentation.

my 0.02 cents...

  ~Gerhard

"things, that try to look like things, do often more look "

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>