THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
After starting Apache Geronimo log into the console and follow the given steps to create CustomerDB.
No Format | ||||
---|---|---|---|---|
| ||||
create table customer (
customerid varchar(10) primary key,
fullname varchar(30),
emailaddress varchar(30),
interests varchar(100)
);
insert into customer values ('A100','John Doe10','Doe10@work.com','Java,Open Source, Computer Graphics');
insert into customer values ('b100','Jane Doe20','Doe20@home.net','Budget Travel, New Zealand, Martial Arts');
|
- Select DB Manager link from the Console Navigation in the left.
- Give the database name as CustomerDB and click Create button.
- Select CustomerDB to the Use DB field.
- Open CustomerService.sql in the CustomerService directory from a text editor.
- Paste the content CustomerService.sql to the SQL Commands text area and press Run SQL button.
...