You may also may your code Thread-Safe by implementing SingleThreadModel Interface.
regards, -jayprakash -----Original Message----- From: Tom K [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 5:16 PM To: [EMAIL PROTECTED] Subject: Re: servlet access in the same time and the result "error"(urgent) Andy, I'm not exactly sure on how you are querying your database but I use prepared statements for performance reasons. The only thing you need to synchronize is the prepared statement. You want to minimize synchronization because it can lower the performance of your application, but it's OK to synchronize your prepared statement and your results should be correct. It goes like this (from example in Jason Hunters book p.282: Synchronized(pstmt){ Pstmt.clearParameters(); Pstmt.setInt(1,2); Pstmt.setDouble(3, 53.43); } Tom Kochanowicz -----Original Message----- From: A mailing list for discussion about Sun Microsystem's Java Servlet API Technology. [mailto:[EMAIL PROTECTED] On Behalf Of Andy Susanto Sent: Tuesday, May 11, 2004 6:06 AM To: [EMAIL PROTECTED] Subject: servlet access in the same time and the result "error"(urgent) hai, my question is why my servlet if access in the same time with two or more user and the result is nor showing the right result. This error happen if performance computer is low. How can i fix this problem ? example: user JAVA 1.4 win2000Server MySQL 3.23.25 Servlet Name = test user A access test and User B access test. Sometimes result for user A get a user B Result otherwise User B get a result user A. and my code is public void doGet(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException{ synchronized(this){ MainProcess(req,res); } } public void MainProcess(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException{ //do something } TIA, andy ________________________________________________________________________ ___ 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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.557 / Virus Database: 349 - Release Date: 12/30/2003 ___________________________________________________________________________ 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 ************************************************************************** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ************************************************************************** ___________________________________________________________________________ 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
