Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How do i create table in sql for webappcabaret

 
Gaurav Kalra
Greenhorn
Posts: 27
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please guide me as i am unable to create tables for my site at www.webappcabaret.com
gaurav
 
Desai Sandeep
Ranch Hand
Posts: 1157
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
maha anna
Ranch Hand
Posts: 1467
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 60
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic