Page History

...

After starting Apache Geronimo log into the console and follow the given steps to create CustomerDB.

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');

1. Select DB Manager link from the Console Navigation in the left.
2. Give the database name as CustomerDB and click Create button.
3. Select CustomerDB to the Use DB field.
4. Open CustomerService.sql in the CustomerService directory from a text editor.
5. Paste the content CustomerService.sql to the SQL Commands text area and press Run SQL button.

...