I can only guess what's maybe wrong, but are you sure that you clean up
all unused database connections?
Maybe the jdbc driver can't get more connections from the db, and if you
recompile (or I think just copying the class files from another place to
the zone dir also might work) the servlets are finalized (and the
connection objects are dropped) and reloaded again. The same happens to
the jdbc driver, as it is istanciated in your first servlet that is
loaded.
Hope that helps,
DD - Shaun Collopy wrote:
>
> I am experiencing a problem with some of my servlets that use objects
> that store state/data (Collection Managers that collect and store data
> from the DB). After about 3 of 4 days of regular use the servlet stops
> working and generates an SQLException reporting that it cannot make a
> connection to the database.
>
> My initial reaction was to try and track down the error in the servlet
> and related objects. I can't find any errors and the weird part is,
> when I recompile the servlet without making any changes it works again??
>
> Any ideas was this is happening or how I can fix it would be
> appreciated.
>
> Regards,
>
> Shaun Collopy
> Web Applications Developer
> Dow Digital
> http://www.dowdigital.com.au
> >>
> >
> >Your message could not be processed because you are not allowed to post
> >messages to the Java Apache Users list.
> >
> >This could be because your From: address is not the same as what you used
> >to subscribe to the list with. Please try changing your From: address to
> >match what you originally subscribed with.
> >
> >For more information, you can contact the list administrator at:
> >
> > Jon S. Stevens <[EMAIL PROTECTED]>
> >
>
> ----------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> READ THE FAQ!!!! <http://java.apache.org/faq/>
> Archives and Other: <http://java.apache.org/main/mail.html/>
> Problems?: [EMAIL PROTECTED]
--
Guenther Wieser
creative-it/Guenther Wieser Software KEG
Student of Telematik at Graz University of Technology
http://www.creative-it.com mailto:[EMAIL PROTECTED]
-> In A World Without Walls And Fences, Who Needs Windows And Gates? <-
----------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
READ THE FAQ!!!! <http://java.apache.org/faq/>
Archives and Other: <http://java.apache.org/main/mail.html/>
Problems?: [EMAIL PROTECTED]
