Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

restoring databse using jdbc

 
sameera k
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Frank Carver
Sheriff
Posts: 6920
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
"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.
 
sameera k
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
pl do reply to above query
 
Thomas Paul
mister krabs
Ranch Hand
Posts: 13974
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please do create a new login id.
------------------
Moderator of the JDBC Forum
 
Raja Shekhar
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Sameera
Restoring the Data base ..throgh JSP?

Eloborate...

bye
Raj
 
sameera kocharekar
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic