hello everybody, I have an application which has 2 users... My problem is that there are some tables and rows in the database which more than one user can do some actions There is a user who is the only one that has the rights to psysically delete rows from the database.This is done by the application not from rights assigned in tha database users. Another user is presentd with some pages which contain pop lists that are filled with values from the datadase. So, this user enters a page and from a pop list which is called -let's say- NAME, he selects a name. Before he hits the enter button the other user has deleted the row which concerns the name the first user has selected. The second user cannot see that as the query which return the names has run before the other user deleted the row. In such a case an exception will be thrown. Although i do exception handling, so nothing will be inserted in the datadase, how can I see that this row i'm going to use does not exist any more or -let me put it other way- if the second user did not delete the row but changed a field so the action the first user is trying to commit can not be done, how can i know that this row has in the meantime been updated and the second user cannot use it? If i didn't have exception handling, such cases would create problems.. Is there a way that some rows can be "locked" let's say in order not to be used by more than one user at thesame time? Thanx in advance Isidoros =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
