Best practices on using custom java tags in GEL


Article ID: 102406


Updated On:


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


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


Component: ODENV


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.