Win a copy of The Journey To Enterprise Agility this week in the Agile and Other Processes forum! And see the welcome thread for 20% off.
  • 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 all forums
this forum made possible by our volunteer staff, including ...
  • Jeanne Boyarsky
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Paul Clapham
  • Junilu Lacar
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Ganesh Patekar
  • Tim Moores
  • Pete Letkeman
  • Stephan van Hulst
  • Carey Brown
  • Tim Holloway
  • Joe Ess

Need Help in loading Data base  RSS feed

Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I know my question is on database but still i am posting it here as it is related with servlets/jsp.
I have made a small site and used to test it on my computer using either oracle database. Now when i want to host it on net i am getting economical space on linux OS with MySQL database.
Server people have provided me with username, password and database name. Now the problem is that how or by using what should i create tables on server. How should i insert values in it.
Some have suggested using telnet....but i don't know how to use it. Some say that i will have to use scripting language. Again how shoud i do that?
Pls can any one help me with this.
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Telnet isn't too scary.
If you have a M$ OS, just get online, click START, RUN, TELNET. You will get a little white window, you need to supply the name of the remote host and then connect. Then you will be prompted for a login and password. MySQL has a command line utility that allows SQL statments. Never used it before but I suggest you ask the people that admin the server or I think you might find some useful stuff at (they have a bunch of MySQL tutorials)
Another option would be write a servlet that does what ever you want to the DB. This might not be the best option for initializing the DB but it will work in a pinch. I suggest you just learn to use telnet.
Nita Kaur
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Today i tried using telnet. I provided the ftp host name and port 8080 / 8000/ 80 but i was not able to get the connection. later i contacted the Server service provided then they said that we are anot given access to use telnet.
They adviced me to use scripting language or to make a servlet and execute it and it will create table.
But till date i have worked only on oracle/access databse and know drivers related to it only. From where can i get information on what type of drivers are required for MySql databse and what is the format of JDBC url.
Can any one be kind enough to help me out.
[This message has been edited by Nita Kaur (edited May 04, 2001).]
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!