File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
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.
 
 
subject: How do i create table in sql for webappcabaret