This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Servlets and the fly likes How do i create table in sql for webappcabaret Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Servlets
Bookmark "How do i create table in sql for webappcabaret" Watch "How do i create table in sql for webappcabaret" New topic
Author

How do i create table in sql for webappcabaret

Gaurav Kalra
Greenhorn

Joined: Mar 13, 2001
Posts: 27
Please guide me as i am unable to create tables for my site at www.webappcabaret.com
gaurav
Desai Sandeep
Ranch Hand

Joined: Apr 02, 2001
Posts: 1157
Gaurav,
Could you be more specific about your problem.Accessing your site gives Configuration error :500
Regards,

------------------
Sandeep Desai
vgdesai@vsnl.com

  1. Sun Certified Java Programmer Scored 93 per cent
  2. Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java Scored 56 out of 59
  3. IBM Enterprise Connectivity with J2EE Scored 72 per cent
  4. Enterprise Development on the Oracle Internet Platform Scored 44 out of 56


<b>Sandeep</b> <br /> <br /><b>Sun Certified Programmer for Java 2 Platform</b><br /> <br /><b>Oracle Certified Solution Developer - JDeveloper</b><br /><b>-- Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java </b><br /><b>-- Object-Oriented Analysis and Design with UML</b><br /> <br /><b>Oracle Certified Enterprise Developer - Oracle Internet Platform</b><br /><b>-- Enterprise Connectivity with J2EE </b><br /><b>-- Enterprise Development on the Oracle Internet Platform </b>
maha anna
Ranch Hand

Joined: Jan 31, 2000
Posts: 1467
Gaurav,
We have to go to a special URL where we have to give SQL statements and run them in order to create our initial tables.
A sample one which I use is

Note that at one time we can give only one SQL statement and execute. To check if the table was created properly, at last give "select * from System" SQL statement!

It was real pain though.
DataBase URL :
jdbc:mysql://mysql.webappcabaret.com/dbtest?user=dbtest&password=dbtest
Here dbtest is your database Name, user=username and password is password for your database. The link is here:
http://webappcabaret.com/apps/websql/websql_server_s.jsp

[This message has been edited by maha anna (edited April 07, 2001).]
Mark Leong
Ranch Hand

Joined: Dec 11, 2000
Posts: 60
I have developed a little utility that helps me manage my databases at webappcabaret.com. You can goto the link below:-
http://www.webappcabaret.com/smallalley/servlet/smallcon.wacdbutilities.sqlutilities
Enter your context and password. I suggest you test your connection before executing any SQL statement (just type the statement into the text box).
Hope the utility is useful.
 
Don't get me started about those stupid light bulbs.
 
subject: How do i create table in sql for webappcabaret
 
Similar Threads
Web Hosting that supports JSP?
what happen to
Hi Maha!
free hosting
Looking for JSP web hosting company...