File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Java Interview Guide this week in the Jobs Discussion 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

How do i create table in sql for webappcabaret

Gaurav Kalra

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

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

Sandeep Desai

  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

Joined: Jan 31, 2000
Posts: 1467
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 :
Here dbtest is your database Name, user=username and password is password for your database. The link is here:

[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 You can goto the link below:-
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.
I agree. Here's the link:
subject: How do i create table in sql for webappcabaret
It's not a secret anymore!