[
https://issues.apache.org/jira/browse/RANGER-4664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Subhrat Chaudhary reassigned RANGER-4664:
-----------------------------------------
Assignee: Subhrat Chaudhary
> SQL Exception is thrown, if resource is null in POST sharedResource API
> -----------------------------------------------------------------------
>
> Key: RANGER-4664
> URL: https://issues.apache.org/jira/browse/RANGER-4664
> Project: Ranger
> Issue Type: Bug
> Components: admin
> Reporter: Subhrat Chaudhary
> Assignee: Subhrat Chaudhary
> Priority: Major
>
>
> If resource is not passed in sharedResource request body (POST API
> /service/gds/resource):
>
> {code:java}
> {
> "name": "SHR4",
> "dataShareId": 5,
> "resource": { }
> }{code}
>
> Following error is received:
>
> {code:java}
> {
> "statusCode": 1,
> "msgDesc": "Exception [EclipseLink-4002] (Eclipse Persistence Services -
> 2.7.12.v20230209-e5c4074ef3):
> org.eclipse.persistence.exceptions.DatabaseException\nInternal Exception:
> java.sql.SQLIntegrityConstraintViolationException: (conn=106) Column
> 'resource' cannot be null\nError Code: 1048\nCall: INSERT INTO
> x_gds_shared_resource (access_types, ADDED_BY_ID, additional_info,
> condition_expr, CREATE_TIME, data_share_id, description, guid, is_enabled,
> name, options, profiles, resource, resource_signature, row_filter,
> sub_resource, sub_resource_masks, sub_resource_type, UPDATE_TIME, UPD_BY_ID,
> version) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
> ?)\n\tbind => [21 parameters bound]\nQuery:
> ValueReadQuery(name=\"X_GDS_SHARED_RESOURCE_SEQ\" sql=\"SELECT
> LAST_INSERT_ID()\")"
> }{code}
> Ideally in response, HTTP Status code 400 (Bad request) should be thrown with
> custom error message.
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
