...
Config Key | Mandatory/ Optional | Type | Purpose | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CT_FW_IBATIS_DATASOURCE_KEY | Mandatory | String | This key is used to provide the iBatis data source key for CT framework. | ||||||||||||
CT_FW_DATASOURCE | Mandatory | String | This key is used to provide data source that must be used by the CT framework for connecting to its data model. | ||||||||||||
CT_FW_DATABASE_VENDOR | Mandatory | String | This key is used to provide the database vendor for which vendor-specific-scripts will be loaded. The possible valid values for this option are:
This is used for switching the underlying database between Oracle or Microsoft SQL Server where the users and objects related to Canvas framework are created. | ||||||||||||
DATASOURCE_NAME | Mandatory | String | This key is used to provide the name of the implementation data source. | ||||||||||||
PROVIDER_URL | Mandatory | String | This key is used to provide the provider URL. | ||||||||||||
JNDI_FACTORY | Mandatory | String | This key is used to provide the default JNDI API for data source connection.The value must be org.apache.naming.NamingContext | ||||||||||||
CT_IBATIS_DATASOURCE_KEYS | Mandatory | Comma separated String | This key provides the list of Logical data sources that the application wishes to use. You must ensure to not include the Data Source name provided under the key CT_FW_IBATIS_DATASOURCE_KEY. In order to use the external data source, you have to define the data source key in this property and add two additional keys for the configuration. Refer Fetching Data from a Schema Different from Implementation Schema for more information. | ||||||||||||
CTDS_MODELSIGMA_HOUSE_DSXML | Mandatory | Resource Path | For every data source configured under CT_IBATIS_DATASOURCE_KEYS, it is expected that the iBatis configuration XML that corresponds to this Logical data source is pointed out here. | ||||||||||||
CT_DEFAULT_IBATIS_DATASOURCE_KEY | Mandatory | String | This is the Logical data source that must be taken as the default by the framework whenever a developer tries to execute a Database request without explicitly providing the Logical Data Source. This must be one of the data sources defined under the key CT_IBATIS_DATASOURCE_KEYS. | ||||||||||||
USER_TXN_NAME.JNDIName | Mandatory | String | This key is used to provide the JNDIName for the user transaction that is getting created.
| ||||||||||||
REMOTE_TXN_NAME.JNDIName | Mandatory | String | This key is used to provide the JNDIName for the remote user transaction that is getting created. | ||||||||||||
| CT_MYBATIS_DATASOURCE_KEY | Optional | String | This key is needed in case of MyBatis usage to indicate the name key value of the implementation data source. | ||||||||||||
| CT_MYBATIS_CONFIG_XMLDATASOURCE | Optional | Resource PathString | This key is needed in case of MyBatis usage to indicate the configuration XML that corresponds to the Logical name of the implementation data source. |
The following is a sample data base configuration databaseconfigSigmadatabaseconfig.properties (as per the name given in the default descriptor):
| Code Block | ||
|---|---|---|
| ||
########################################################################################### # The FW Datasource key, framework datasource name and database vendor. ########################################################################################### ####################################################################### CT_FW_IBATIS_DATASOURCE_KEY = CT_DS # The data source that should be used by the CT framework for connecting to # its data model. # CT_FW_DATASOURCE = java:/comp/env/jdbc/OraSource CT_FW_DATASOURCE = java:/OraSource SigmaCanvasDataSource # The database vendor for which vendor specific scripts will be loaded. #CTCT_FW_DATABASE_VENDOR = mysql # CT_FW_DATABASE_VENDOR = db2 #CT_FW_DATABASE_VENDOR = mssql CT#CT_FW_DATABASE_VENDOR = oracle ################################################################################################################################################################## # The Impl Datasource key Name ####################################################################### #WebLogic #DATASOURCE_NAME = ImplOraSource #PROVIDER_URL = localhost:7001 #JNDI_FACTORY = weblogic.jndi.WLInitialContextFactory ####################################################################### #JBOSS # ########################################################################################### DATASOURCE_NAME = java:/comp/env/jdbc/ImplOraSource DATASOURCE_NAME = java:/ImplOraSource SigmaAppDataSource PROVIDER_URL = localhost:9080 JNDI_FACTORY = org.apache.naming.NamingContext ########################################################################################### ####################################################################### # The Impl Datasource keys and its corresponding iBATISibatis SQLsql MAPmap file. ################################################################################################################################################################## #CT_IBATIS_DATASOURCE_KEYS = #[CT_IBATIS_DATASOURCE_KEY]_DSXML = CT_IBATIS_DATASOURCE_KEYS = CTDS_MODEL_HOUSE CT_MODEL_HOUSESIGMA DS_SIGMA_DSXML = com/intellectdesign/app/modelhousesigma/database/ibatis/config/CTIMPLDatabaseConfigSigmaDBConfig.xml ################################################################################################################################################################## # The default iBATISibatis datasource key for the implementation SQLsql MAPmap file. ################################################################################################################################################################## CT_DEFAULT_IBATIS_DATASOURCE_KEY=CTDS_MODEL_HOUSESIGMA ################################################################################################################################################################## # The JNDIName for the user transaction which is getting created. ################################################################################################################################################################## USER_TXN_NAME.JNDIName = java:comp/UserTransaction REMOTE_TXN_NAME.JNDIName = java:comp/UserTransaction CTMYBATIS_DATASOURCE_KEY=MYBATIS_DATASOURCE MYBATIS_DATASOURCE= java:comp/ModelHouse CT_env/jdbc/SigmaAppDataSource MYBATIS_CONFIGQUERY_XML PREPROCESSOR= com/intellectdesign/modelhouse/database/mybatis/config.xml.intellectdesign.canvas.mybtis.CanvasQueryFunctionProcessor |