Specialized Readmulti operations and non-standard operations allow the developer a greater level of freedom when handcrafting database access code. However in certain situations this may prove to be too limiting. For example where the SQL string will be derived from the input parameters to a method; parts of the 'where' clause will be optional or expressed differently depending on the input. In these situations the developer can obtain the Connection being used for database communication through the TransactionInfo. getInfoConnection interface. Once this connection has been obtained it is possible to execute any form of handcrafted JDBC in the context of the Cúram transaction.
To enable this style of database access to be visible in the model it should be placed in an entity which has theNO_SQL option enabled. This is detailed in the Cúram Modeling Reference Guide.