Dear Sir/Madam,
We have one sevlet that opens connection with oracle data base in our
servlet source code. It opens connection in init method and do query in
service method.
We are using Apache 1.3.6 webserver with JServ 1.0.
Our code and queries are working perfectly fine, but it is giving INTERNAL
SERVER ERROR after few requests.
To debug the aforesaid problem we put two counters that are shared by all
instances and servlets. It gives INTERNAL SERVER ERROR when the counter
reaches 79 requests.
May we request you all to let us know
(i) what the exact problem is?
(ii) How can we overcome with INTERNAL SERVER ERROR?
(iii) How can we make our code more flexible to accept as many requests as
it comes to the web server?
We are also putting our code which we have used in our project. It is shown
below:-
class abc
{
Connection con;
init(.....){
//opens conection using jdbc odbc brigde
}
syncronized service(...)
{
//do query on data base like select/insert/update/delete
}
destroy(..)
{
//close connection
}
}
May we request you all to send us the solution of this problem and oblige.
Thank you very much for your keenness shown in this problem.
With warm regards
Ambuj Kumar
___________________________________________________________________________
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
