Best practices on using custom java tags in GEL

book

Article ID: 102406

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

How can I safely write my GEL script using SQL database connections?

Environment

Release:
Component: ODENV

Resolution

CA Support recommends to only use the OOTB gel tags to query the database which are approved, such as sql:query. The full list can be found in our CA PPM documentation. The rest of the tags are unsupported.
 
We do not recommend using custom java tags. In our experience this has caused system outages, (crash on BG service) when the script encounters an issue, and the connection is not being closed. This will create an unhandled memory leak. To avoid this issue - please follow the recommendation on using only supported OOTB gel tags.