A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
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
Sun Certified Java Programmer
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
<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>
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.
I agree. Here's the link:
- if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
subject: How do i create table in sql for webappcabaret
what happen to
Web Hosting that supports JSP?
Looking for JSP web hosting company...
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013