Global list of synchronized objects

[maciaszczykm]

New interface needs to be created. Objects synchronized with database should be stored in map or structure like it.

[maciaszczykm]

Satisfies #27 issue:

If database structure contains loop it is possible for application to have one too. 
It cannot happen.

[maciaszczykm]

Avoid loading of same object more than once. Check how global objects list can be used to achieve it. Maybe it should be used in other CRUD methods too?

Sample loop in database structure:

DROP DATABASE EMPLOYEES;

CREATE DATABASE EMPLOYEES;

USE EMPLOYEES;

CREATE TABLE COMPANY (
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
COMPANYNAME VARCHAR(30),
EMPLOYEE INT);

CREATE TABLE EMPLOYEE (
ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
FIRSTNAME VARCHAR(10),
LASTNAME VARCHAR(20),
BIRTHDAY DATE,
GENDER VARCHAR(6),
COMPANY INT,
HIREDATE TIMESTAMP,
SALARY DOUBLE,
CHILDREN INT,
FOREIGN KEY(COMPANY) REFERENCES COMPANY(ID));

ALTER TABLE COMPANY ADD FOREIGN KEY (EMPLOYEE) REFERENCES EMPLOYEE(ID);

COMMIT;

[maciaszczykm]

Load objects from database or cache (pointer to currently synchronized object from global list)? Check how Hibernate handles it.

[maciaszczykm]

Objects are loaded always from database.