Software AG Products 10.7 | Integrating On-Premises and Cloud Applications | Integration Server Built-In Services | OAuth Folder | Summary of Elements in this Folder | pub.oauth:​removeExpiredAccessToken
 
pub.oauth:​removeExpiredAccessToken
WmPublic. Removes expired OAuth access tokens from the database.
Input Parameters
maxRows
String. Optional. Maximum number of rows containing expired tokens to be deleted from the database, where each row contains a single expired access token. If you specify 0 or do not specify a value, the service removes all of the rows containing expired tokens from the database.
The maxRows parameter applies to Oracle or DB2 databases only. The maxRows parameter is ignored for all other database types, such as MySQL, SQL Server, or Derby. Instead, the service deletes all of the rows containing expired tokens.
Output Parameters
None.
Usage Notes
To improve the performance of the pub.oauth:removeExpiredAccessTokens service, create the following two database indexes:
*Create index idx_oauth_tmp_idx on IS_OAUTH_ACCESSTOKEN(TOKEN_ID);
*Create index idx_oauth_tmp_idx2 on IS_OAUTH_REFRESHTOKEN(TOKEN_ID);