> I'm using JSP's to call a Stored Procedures in Oracle.
> What I want is to lock the record when someone choose to update the
> information.
> The JSP_TESTS_SELECT_FOR_UPDATE(?,?) will return the name of the employee
> (to update).
>
> I think that everything is ok.
> I set the autocommit to False.
>
> But it's still possible to 2 diferent persons choose the same record ...
Think about it. Who (or what program) is the owner of the lock? Is ithe
user on the web browser, or the servlet running on your server? You can't
lock things away from yourself.
David
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
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
