Hi Nitim,
I would use the synchronize method to avoid data corruption and do connection
pooling. If you use MS Access you are limited on the number of users anyway
because of scalability. I do not believe their is a JDBC driver for Access. The
JDBC/ODBC bridge which you probably using is not made for production use.
Nitin Kulkarni wrote:
> 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
___________________________________________________________________________
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
