Return-Path: Delivered-To: apmail-jakarta-tomcat-user-archive@www.apache.org Received: (qmail 81014 invoked from network); 3 Nov 2003 06:29:35 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 3 Nov 2003 06:29:35 -0000 Received: (qmail 64025 invoked by uid 500); 3 Nov 2003 06:28:54 -0000 Delivered-To: apmail-jakarta-tomcat-user-archive@jakarta.apache.org Received: (qmail 63890 invoked by uid 500); 3 Nov 2003 06:28:53 -0000 Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Tomcat Users List" Reply-To: "Tomcat Users List" Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 63877 invoked from network); 3 Nov 2003 06:28:53 -0000 Received: from unknown (HELO hotmail.com) (64.4.18.208) by daedalus.apache.org with SMTP; 3 Nov 2003 06:28:53 -0000 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Sun, 2 Nov 2003 22:29:05 -0800 Received: from 61.11.83.4 by law12-oe73.law12.hotmail.com with DAV; Mon, 03 Nov 2003 06:29:04 +0000 X-Originating-IP: [61.11.83.4] X-Originating-Email: [antonypaul24@hotmail.com] From: "Antony Paul" To: "Tomcat Users List" Subject: Design advice needed. Date: Mon, 3 Nov 2003 12:06:01 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4927.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 Message-ID: X-OriginalArrivalTime: 03 Nov 2003 06:29:05.0060 (UTC) FILETIME=[C7503640:01C3A1D3] X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N Hi all, I need a replacement for row level locking in database. The requirement is if two users are updating the same row of a table only the user who updates first will be made to database second user must get a failed message. This can be done using row level locking. But it allows only one user to open page for editing at same time. If another user has locked the row then second user cannot lock the same row or update it. So I want to implement locking in Container. Is there any design patterns available for this. Or have anyone implemented this. I am using Tomcat 4.1,Servlets JSP and Oracle 8i. The application is using MVC pattern but do not use Struts. Antony Paul --------------------------------------------------------------------- To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: tomcat-user-help@jakarta.apache.org