Versions Compared

Version Old Version 1 New Version 2
Changes made by

Ravikumar Babu CTOO (Unlicensed)

Ravikumar Babu CTOO (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleWhat is SQL Map?

Canvas uses the iBATIS framework for SQL mapping that fetches data using SQLs written in an XML file through a SQL_PARAM_MAP IDs. Within a Logical Data Source, all SQL Map IDs are expected to be unique (else will result in initialization error), ensure that any SQL Map IDs defined by you do not conflict with the existing ones.

Refer Quick primer on iBatis SQL Map for more detailed information.


Expand
titleWhere to store the SQL MAP file?

Within the Canvas workbench, the default SQL Map files that are used by CT ModelHouse application are stored in the CTModelHouseResources folder.

SQL Maps for Modelhouse Application in the Resources folder

All the default SQL Maps used by CT ModelHouse application is specified in the Implementation Database Config file. The default Implementation Database Config file used by CT ModelHouse is located in the CTModelHouseResources folder:

Implementation Configuration File for ModelHouse Application

It is advisable to store all the SQL Maps and other resources (e.g. property files) that your application requires under a common folder, e.g. MyApplicationResources.

...