It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes restoring databse using jdbc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "restoring databse using jdbc" Watch "restoring databse using jdbc" New topic

restoring databse using jdbc

sameera k

Joined: Oct 27, 2000
Posts: 5
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 kocharekar
Frank Carver

Joined: Jan 07, 1999
Posts: 6920
"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 . 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.

Read about me at ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
sameera k

Joined: Oct 27, 2000
Posts: 5
pl do reply to above query
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Please do create a new login id.
Moderator of the JDBC Forum

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Raja Shekhar
Ranch Hand

Joined: Apr 02, 2001
Posts: 49
Hi Sameera
Restoring the Data base ..throgh JSP?


sameera kocharekar

Joined: Apr 23, 2001
Posts: 23
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

I agree. Here's the link:
subject: restoring databse using jdbc
jQuery in Action, 3rd edition