Hello All,
I need some help regarding multiuser programming using Servlet. We have
developed an application which runs as follows
HTML ----> Servlet----->
Database(MS Access)
HTML <---Servlet<-----
The problem here is that we are opening just one connection to the database in
the init() of the servlet and using the same connection for any request coming
from any user.
This could led to problems of data corruption such as variable getting changed
before the query which uses it gets executed (This would happen if two users
access the servlet at the same time).
The two solutions known to handle this problem are syncronising or using
SingleThreadModel. But both these methods have their drawbacks. Also these
handle multithreading aspect rather than multiuser. Is there any third way to
handle this kind of a multiuser aspect.
Quick help will be appreciated.
Thanks
Nitin
___________________________________________________________________________
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
