SQL Query Details

Products

• CA API Gateway

Issue/Introduction

Gateway nodes executing the following query. Please update the purpose of this query:

SQL TEXT

DELETE FROM oauth_session WHERE expiration <= :1

Environment

Gateway 11.0  OTK 4.X

Resolution

The gateway has maintenance tasks that cleans up expired session 

The maintenance task are backend policies in folder; OTK -> Policy Fragments -> maintenance 

"OTK Database Maintenance - sessions"

Default runs every 7 minutes 

Perform JDBC Query - Delete expired sessions

“Deletes all expired sessions from oauth_session”

Query that is run 

DELETE FROM oauth_session

                WHERE expiration <= ${now.seconds}