Hi. i need to insert data into 2 tables in database after one by one. the first table has a primary key auto increment after inserting data into first table, with the help of first table primary key id i am inserting data into second table. this should not be overlapped if more than one users accessing the site simultaneously. i think so this can be achieved by 1) locking table, so that others can't access at that time. or 2) locking application. or 3)single thread model. can any one help on this. what is function we have in jsp to lock application............ many thanx Senthil. =========================================================================== 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
