ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Best practices on using custom java tags in GEL

book

Article ID: 102406

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

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

Environment

Release:
Component: 

Resolution

  • Broadcom 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 Clarity 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.