Ok, I don't have experience with JDBC, rather ODBC. Recently I was involved in doing an upgrade where in a previous version of Gen there had been native support for a particular DB and that was deprecated. I tried defining it as an ODBC database and generating the code targeting ODBC, which worked for the most part. There were some things that didn't line up. For those things I ended up using inline code statements in some called action blocks I created with only the inline code statements in it.
This helped me around some of the incompatibility and we were able to deliver the required functionality.
If you are not familiar with the Inline code statement, it was put in place in Gen 8.5 IE 1 to allow the developer to write complicated SQL statements or other code which Gen might not do.
https://docops.ca.com/ca-gen/8-5/en/developing/designing/designing-action-diagrams/define-logic-for-elementary-processes-and-procedures/add-assignment-actions/inline-code-statement/
and related to ODBC/JDBC
https://docops.ca.com/ca-gen/8-5/en/developing/designing/using-toolset/working-with-toolset/use-action-diagram/assignment-action-statements/add-an-inline-code-statement/how-to-add-inline-code-statements-containing-odbc-jdbc-or-ado-net-statements
I have not Used JDBC in Gen, but I do expect that you might be able to have the connection managed by Gen and use inline code for anything that GEN might have a problem dealing with against the unsupported DBMS.
I would not recommend using the unsupported DBMS as CA would not be involved if you needed further assistance. Any help would come from this EDGE group, if they could provide it.
What I would recommend is that you add an "IDEA" for JDBC Support for the DBMS you are wanting to work with. If it gets enough traction, it could be added to a future release of the product and then become "supported"
I hope this helps
Darcy Elliott