D-Net

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

Adding branches folder

Enable claiming for ORPs
Set direct index url in properties
Migration:
save orphan Ids, claims
uncomment fetch dedup

1. FetchProjectHandler.java: Rename 'fetchProjectIdByToken' to 'fetchProjectIdByTokenAndEmail' and create 'public String fetchProjectIdByToken(String token)' method.
2. QueryGenerator.java: Rename 'generateSelectProjectIdByTokenQuery' to 'generateSelectProjectIdByTokenAndEmailQuery' -...

Change ContextUtils to get concept label from new Context API

add communities xml files| change fetching methods for communities | set properly date in migration | change ORCID API

fixing issues with ordering and types filter

close the db connection per request, in fetch claims by context id use like and wild character in order to get all claims of a community