Missing tables and procedures for JEE - 1.0

Compatibilty: v2 v3 Cloud
What's new? Release Notes
ID: com.castsoftware.jee.missingtable

Description

This extension is designed to analyze SQL queries embedded in JEE code / ORM Crud objects aka Entity Operations and create “missing” SQL and JEE table / procedure objects to represent SQL objects that have not been delivered for analysis. Links to these objects are also created. The primary goal of the extension is to ensure that a full transaction is identified by CAST, resulting from the SQL queries embedded in the JEE code/ORM CRUD objects aka Entity Operations, even if none or only part of the referenced SQL objects are delivered for analysis.

Supported client languages

Language Supported?
JEE ✅

Function Point, Quality and Sizing support

  • Function Points (transactions): a green tick indicates that OMG Function Point counting and Transaction Risk Index are supported
  • Quality and Sizing: a green tick indicates that CAST can measure size and that a minimum set of Quality Rules exist
Function Points (transactions) Quality and Sizing
✅ ❌

Prerequisites

Item Description
✅ An installation of any compatible release of CAST Core (see table above)
✅ An installation of com.castsoftware.sqlanalyzer (from version ≥ 3.6.9-funcrel)

Download and installation instructions

The extension will be automatically downloaded and installed in CAST Console when JEE source code is delivered for analysis. You can manage it using the Application - Extensions interface.

What results can you expect?

Objects

Icon Object Type Description Metamodel Type
Missing Schema Parent of the missing tables and procedures, attached to the JEE / Java JSP Project. CAST_Java_MissingTable_Schema
Missing Table A table or a view selected/updated/deleted/inserted in a JEE Query / ORM CRUD object missing from the DDL file. CAST_Java_MissingTable_Table
Missing Procedure A procedure or a function called in a JEE Query missing from the DDL file. CAST_Java_MissingTable_Procedure
SQL Missing Table A table or a view selected/updated/deleted/inserted in a JEE Query / ORM Crud object missing from the DDL file, but we have a SQL Schema, and only one. SQLScript_Missing_Table
SQL Missing Procedure A procedure or a function called in a JEE Query missing from the DDL file but we have a SQL Schema, and only one. SQLScript_Missing_Procedure

Links are created for transaction and function point needs. You can expect the following links on the JEE Embedded SQL queries / ORM CRUD objects:

  • useSelect/useUpdate/useDelete/useInsert from JEE Query / ORM CRUD object to Missing Table/SQL Missing Table
  • call from JEE Query to Missing Procedure/SQL Missing Procedure