Metacat

remove "al" prefix from subquery since we are only querying one table and do not need to use a prefix.

merge from 2.5 branch: use subquery to do paging before joining to identifier table. https://redmine.dataone.org/issues/7491

Add more statement to debug the query performance.

Use conditional method for retrieving server URL (http vs https). When metacat is configured to force SSL communication we get the https url, otherwise we get http. this allows us to use the DBTransform on localhosts that are not using SSL.

Fixed a bug that the publish method should throw an io exception.

Move the editScienceMetadata method to the MNodeService class - only update packageId in EML on publish()

Fixed a bug in the condition check for the archive field in the updateSystemMetadata method.

The archived field can't be reset to false if it is true in the systemMetadataChanged method.

Doesn't allow to reset the archived field to be false if the field is true in the updateSystemMetadata method.

In the systemMetadataChanged method, we will update system metadata when the local serial version is less than or equals the comming one.