Andrew Xu

8888 Server (Bob)

Setup (IntelliJ):

-Import all maven dependencies from pom.xml

-Run Main method in the "Application" class

-Client output will appear in console

-Login with the following credentials:

Saved Settings: Generic H2 (Embedded)
Driver Class: org.h2.Driver
JDBC URL: jdbc:h2:mem:testdb
User Name: sa
Password: leave empty ('')

-Click connect

-Run the following SQL code in the box

create table pendingtransaction
(
   change integer not null,
   proposedBalance integer not null,
);

create table account
(
   balance integer not null,
   name varchar(255) not null,
);

insert into account
values(0,'Bob');
select * from account;
select * from pendingtransaction;

-You should see two tables- account and pendingtransaction

-Account should have an entry for Bob with a starting balance of 0

-If you would like to check the database contents at any time, navigate back to this page and run the last two lines of SQL code

-If the other Server (Alice on port 8080) is ready, you are ready to configure and run the client