A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
The Software Craftsman
this week in the
How do i create table in sql for webappcabaret
Joined: Mar 13, 2001
Apr 07, 2001 10:48:00
Please guide me as i am unable to create tables for my site at
Joined: Apr 02, 2001
Apr 07, 2001 16:01:00
Could you be more specific about your problem.Accessing your site gives Configuration error :500
Scored 93 per cent
Oracle JDeveloper Rel. 3.0 - Develop Database Applications with Java
Scored 56 out of 59
IBM Enterprise Connectivity with
Scored 72 per cent
Enterprise Development on the Oracle Internet Platform
Scored 44 out of 56
Joined: Jan 31, 2000
Apr 07, 2001 21:08:00
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
/* Working for Online System CREATE TABLE System( ID int NOT NULL auto_increment,ParamName varchar(20), ParamValue varchar(20),PRIMARY KEY(ID)) INSERT INTO System (ParamName,ParamValue) values ('BaseBranch', 'Chennai') */
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).]
Joined: Dec 11, 2000
Apr 08, 2001 17:44:00
I have developed a little utility that helps me manage my databases at webappcabaret.com. You can goto the link below:-
Enter your context and password. I suggest you
your connection before executing any SQL statement (just type the statement into the text box).
Hope the utility is useful.
It is sorta covered in the
JavaRanch Style Guide
subject: How do i create table in sql for webappcabaret
Web Hosting that supports JSP?
what happen to
Looking for JSP web hosting company...
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015