Fix error creating new API revision and StuckThreadDetectionValve issue while creating an API Product

[YasasRangika]

[FIX-01]

Purpose

In order to fix the error when creating a new revision, we need to consider a situation where there is an API with two or more resources having the same resource method and the same resource path, but with different cases. This error occurs when attempting to create a new revision from this API.

Goal

Fixes: https://github.com/wso2/api-manager/issues/2999

Approach

Configuring resources in this way is not the best practice; however, we have addressed this by performing a case-sensitive URL_PATTERN search using Latin1_General_CS_AS collation on the URL mappings of the API during new revision creation.

[FIX-02]

Purpose

Fixes StuckThreadDetectionValve issue while creating an API Product.

Goal

Fixes: https://github.com/wso2/api-manager/issues/3030

Approach

Introduced getPublishedDefaultVersion method to resolve the default version of both migrated APIs and newly created APIs.