ORVE WS (Dynamic) (9) Persisting retrieved records and other control information (1). H2 DB proposal

0. Introduction As ORVE WS will have a daily usage, it is important to have a control, so it is required to: Persist all retrieved records. Have a logging system for failures. Know the last date the records were requested with success. Persist the which "ids" where not successfully retrieved. So we need a simple database management system for this purpose as this is not a critical system. It can be helped by a property file. A DBMS candidate for this is H2. Hibernate JPA is a good system to access this DBMS using Java. 1.Installing and testing H2 It can be downloaded from the H2 page , and unzipped into a folder. Open a console and go to the "bin" subfolder and run java -jar h2*.jar but if we want that anybody can access our database this command should be executed java -jar h2*.jar -webAllowOthers -tcpAllowOthers A new tab is opened in Firefox If the "Test Connection" button is pressed then the "Test succ...