"William D. Sheppard" wrote:
> Hi,
>
> I have a servlet that implements a complex 3 tier service with
> an Oracle Database and an IBM mainframe using JDBC from the
> Servlet. We are using JavaWebServer1.1.3 and Oracle 7.3.2
>
> In general the Servlet performs very well. However, occasionally
> a database call blows up (a software bug is hit). When this happens
> the ENTIRE SERVICE appears to hang. New threads are created but
> are not run. Also attempting to restart the service once its
> hung from the JWS admin. page fails. The only way out is
> is to manually kill JWS and restart it. Event and Error
> logs report no problems.
>
> Has anyone else seen this problem? What tools if any are available
> for troubleshooting problems like these?
> Under what conditions can a service get into such a state?
>
One possible cause of this kind of thing is a synchronized method that is
accessed by all of the servlets. The first thread in locks the corresponding
object, and if it hangs, and any other servlet tries to access the locked
object, it will also appear to hang.
If you haven't done so, I would strongly recommend upgrading to the most
recent versions of the Oracle JDBC driver -- the early version was really
buggy. I also seem to remember that Oracle says you needed 7.3.3 or later (or
something like that) on the database itself for reliable access.
>
> Thanks in advance,
> --Bill
>
Craig McClanahan
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
