hi folks i am restoring a database in SQL thru jsp using JDBC api it restores database but maybe it goes into a infinite loop . bcoz it doesnt come out of the jsp page even if i redirect it or even if i display some text in the same page after the restore commad is being executed the restore command is given thru executeUpdate can u plz help me its urgent thanks guys bye sameera
"sameera k", The Java Ranch has thousands of visitors every week, many with surprisingly similar names. To avoid confusion we have a naming convention, described at http://www.javaranch.com/name.jsp . We require names to have at least two words, separated by a space, and strongly recommend that you use your full real name. Please log in with a new name which meets the requirements. Thanks.
well hi i am back registerd with a new name but plz if anyone can solve the above prob i will explain it in detail See i have a registration page and for every user who registers i create a new database But in this new database there are 30 tables and some of the tables are master tables which have to be restored along with the data . hence rather than creating a new database and then creating the new tables all over again what i am doing is i am taking a backup of the database(a .dmp file) which i want and then using the restore command i am restoring the database so that a database gets created with the tables along woith the data But the problem is if i try doing this in JSP using JDBC and the sql restore command the database gets restored but any command or any out.println statement doesnt get executed after the restore command is given .the jsp page just doesnt go any further plz can someone help is it possible to do what i said above