D-Net

1. pom.xml: Add commented plugin for surfire (possibly needed in openjdk: bug in their release) | update version of javax.mail.
2. FetchContextHandler.java: bug fix in parsing resultset.
3. QueryGenerator.java: bug fix in query of method 'generateSelectFirstContextByCommunityIdQuery'....

NotificationHandler.java & EmailSender.java: bug fix in calculating seconds (store 12:00 and add 1 sec to last_interaction_date when sending email).

springContext-claimsDemo.xml: targetHour and targetMinute beans restored (were changed for testing purposes).

1. FetchClaimHandler.java: add method fetchNumberOfClaimsByDateAndOpenaireId.
2. CommunityUtils.java: request datasource API to get community information (including managers).
3. FetchContextHandler.java: Method fetchFirstContextByCommunityId to parse name of community to be used in the above API....

Add database sql script to remove 'token' and 'notify' from project table and create notification table.

1. Add entity 'Notification': pairs of mail-openaireId, with the preferences for notifications of this user for this id.
2. Add FetchNotificationHandler and NotificationHandler for 'Notification' entity.
3. springContext-claimsDemo.xml: Add beans for FetchNotificationHandler, NotificationHandler, defaultFrequencyInHours....

1. Project.java: Remove 'token' field from 'Project' entity.
2. FetchProjectHandler.java, ProjectHandler.java, TestClass.java: Remove methods related to 'token' field.
3. FetchProjectHandler.java: Add 'fetchProjectIdsAndNamesByProjectManagerMail' method | Change 'fetchContactEmailsByProjectId' method (mails are returned as List from DAO).

SqlStore.java:
close ResultSet and Statement in finally clause
return CachedRowSet instead of ResultSet when needed (avoids problems with closed connection, nothing else changes because CachedRowSet extends ResultSet)

Parameterize context utils methods with a boolean parameter for productionIndex, add production url
In delete claims method add check for deleting record

Creating a branch of project for refactor con
nections issue