Gerhard Froehlich
Fri, 22 Feb 2002 13:10:03 -0800
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.
>>
>
>Yeah, I can't argue with that. The problem is the customer wrote and
>or contracted out work to develop the application. I just have to worry
>about hosting it.
>
>Worse than using sql within a JSP, the customer turned almost their
>entire web site into a bunch of JSP pages to dynamically generate
>the content from a db. But they only change the db 5-6 times a day.
>So their pages generate all this load and are open to all kinds of
>potential failures for what is essentially static content. I strongly
>recommended to them that they switch it over to a publish system where
>they make changes to the db then generate the static html pages.
>But of course the customer says they don't have time to do that,
>they have something that "works". This is for a site with 500,000
>page views per month with spikes of 6-10k page views per hour.
>
>Sigh...
Dude, I can feel you pain, believe me... ~Gerhard -------------------------- Hey! It compiles! Ship it! -------------------------- -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>