wood burning stoves 2.0*
The moose likes JDBC 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
Bookmark "restoring databse using jdbc" Watch "restoring databse using jdbc" New topic
Author

restoring databse using jdbc

sameera k
Greenhorn

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
Sheriff

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 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.


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

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?

Eloborate...

bye
Raj
sameera kocharekar
Greenhorn

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


SCJP
 
 
subject: restoring databse using jdbc
 
Similar Threads
Writing a simple login app using JSP & MS Access
Runtime.exec()
JDBC - JSP help required.
select multiple dataitem
Revert Back Changes from Update query