• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

restoring databse using jdbc

 
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Sheriff
Posts: 7001
6
Eclipse IDE Python C++ Debian Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
pl do reply to above query
 
mister krabs
Posts: 13974
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Please do create a new login id.
------------------
Moderator of the JDBC Forum
 
Ranch Hand
Posts: 49
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Sameera
Restoring the Data base ..throgh JSP?

Eloborate...

bye
Raj
 
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
reply
    Bookmark Topic Watch Topic
  • New Topic