Page History

...

• In the Console Navigation menu on the left click on Database Manager.
• Enter SecurityDatabase in the Create DB: field and click Create.
• Select the SecurityDatabase database from the Use DB: pull-down menu, enter the following SQL command and click Run SQL.
  CREATE TABLE USERS create table users
(username VARCHARvarchar(15),
password VARCHARvarchar(15));
CREATE TABLE GROUPS create table groups
(username VARCHARvarchar(15),
groupname VARCHARvarchar(15));
• Select the SecurityDatabase database from the Use DB: pull-down menu, enter the following SQL command and click Run SQL.
  INSERT INTO USERS VALUESinsert into users values('USERONEuserone','P1p1');
INSERT INTO USERS VALUESinsert into users values('USERTWOusertwo','P2p2');
INSERT INTO USERS VALUESinsert into users values('USERTHREEuserthree','P3p3');
INSERT INTO GROUPS VALUESinsert into groups values('USERONEuserone','admin');
INSERT INTO GROUPS VALUESinsert into groups values('USERTWOusertwo','admin');
INSERT INTO GROUPS VALUESinsert into groups values('USERTHREEuserthree','user');

Create connection pool

• In the Console Navigation menu on the left click on Database Pools.
• Click on Using the Geronimo database pool wizard.
• Enter SecurityDatabase as the database pool name. Select Derby embedded from the database pool type pull-down menu and click Next.
• Verify the JDBC driver class is org.apache.derby.jdbc.EmbeddedDriver.
• From the Driver Jar pull-down menu select org.apache.derby/derby/10.1.1.0/jar.
• Enter UserOne userone and p1 as the connection user name and password.
• Enter SecurityDatabase as the database name and click Next.
• Click Test Connection.
• Click Deploy.

...