Java Reference
In-Depth Information
INSERT INTO "FOREST"."PERSON"
(FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,
PASSWORD,DTYPE) VALUES ('Robert','Exampler','robert@example.com',
'Example street','San Fran-
cisco','81dc9bdb52d04dc20036dbd8313ed055',
'Customer');
INSERT INTO "FOREST"."PERSON"
(FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,
PASSWORD,DTYPE) VALUES ('Ad-
min','Admin','admin@example.com','Example street',
'Belmont','81dc9bdb52d04dc20036dbd8313ed055','Administrator');
INSERT INTO "FOREST"."PERSON"
(FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,
PASSWORD,DTYPE) VALUES
('Jack','Frost','jack@example.com','Example Blvd',
'San Francisco','81dc9bdb52d04dc20036dbd8313ed055','Customer');
INSERT INTO "FOREST"."PERSON"
(FIRSTNAME,LASTNAME,EMAIL,ADDRESS,CITY,
PASSWORD,DTYPE) VALUES ('Pay-
ment','User','paymentUser@dukesforest.com',
'-','-','58175e1df62779046a3a4e2483575937','Customer');
INSERT INTO "FOREST"."GROUPS" (NAME, DESCRIPTION)
VALUES ('USERS', 'Users of the store');
INSERT INTO "FOREST"."GROUPS" (NAME, DESCRIPTION)
VALUES ('ADMINS', 'Administrators of the store');
INSERT INTO "FOREST"."PERSON_GROUPS" (GROUPS_ID,EMAIL)
VALUES (1,'robert@example.com');
INSERT INTO "FOREST"."PERSON_GROUPS" (GROUPS_ID,EMAIL)
VALUES (2,'admin@example.com');
INSERT INTO "FOREST"."PERSON_GROUPS" (GROUPS_ID,EMAIL)
VALUES (1,'jack@example.com');
INSERT INTO "FOREST"."PERSON_GROUPS" (GROUPS_ID,EMAIL)
VALUES (1,'paymentUser@dukesforest.com');
The Duke's Tutoring case study uses a singleton bean,
ConfigBean
, to populate
its database tables, instead of using SQL commands.
3. Create a JDBC connection pool for the database.
Duke's Forest uses an Ant task,
create-forest-pool
, to create the
derby_net_forest_forestPool
JDBC connection pool for the database:
