How can I safely write my GEL script using SQL database connections?
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.