I do not know mySQL well, see manual page, looking for transactions. (begin - commit - rollback - if it is supported ...)
boolean doit = true; stm.execute("begin"); stm2.execute("begin"); stm3.exexute("begin"); if(!stm.execute("insert into ...")){ doit = false; } if(!stm2.execute("insert into ...")){ doit = false; } if(!stm3.execute("insert into ...")){ doit = false; } if(doit){ stm.execute("commit"); stm2.execute("commit"); stm3.execute("commit"); }else{ stm.execute("rollback"); stm2.execute("rollback"); stm3.execute("rollback"); } Jiri Chaloupka <citováno kdo="Deepak"> > Hi folks > > I guess this is off-topic. am sorry for that. > > Is it possible to execute a set of SQL statements in a batch using JSP. > The db is MySQL. > > I have 3 SQL statements. I want all of them to execute correctly. > If one fails the others should be rolled back. > its all or none. > > Is it possible? > > Thank you > Deepak > -- Jiri Chaloupka B2BExpander.com [EMAIL PROTECTED] ********************************************** http://www.b2bexpander.com/ http://www.chalu.cz - intranet groupware system =========================================================================== 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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com