Page Comparison

...

1. Access the path of the zipped database folders, e.g. D:\CT\dist\database.
   
   
   
   
2. Extract the files of the target database from the zip folder, e.g. canvasSetup_MYSQL. 
   
   1. Open the extracted folder of canvasSetup_MYSQL.
      
      
      
      
3. Open the bin folder in canvasSetup_MYSQL.
   
   
   
   
4. Open the config.txt file in bin folder.
   
   
   
   

   Multi App Schema enables you to use a single config schema for different applications, in this case, SmartBank and another application. This is similar to a functional application (e.g. Modelhouse) and Sigma, using the same config (metadata) schema instead of using two different schemas.

   
   

   Note
   title Note
   If you want to use multi app schema, then perform step 5 or else proceed to step 6.

   
   

5. Only when you use a multi-app schema, it is required for you to replace the existing name of the MULTI_APP_SCHEMA, with a new one, e.g. MULTI_14260 and then you must proceed to save the config.txt file.
   
   
   
   
6. Double-click the run windows batch file to generate the DB scripts.
   
   
   
   The DB scripts get generated. 
   
   
   
   

7. After the DB scripts get generated successfully, open server.xml file in the app server’s configuration folder to change the schema name, e.g. D:\Canvas\ apache tomcat 8.5.9\ conf\server.xml.
   
   

   Note
   title Note
   The same schema name, which was provided in the config.txt file, should be used in the server.xml file.

   
   
   
   The following sample code snippets serve as ideal references snippet serves as a reference of server.xml file for the sample application, Sigma and Canvas Studio. 
   
   

   Code Block

   Sample Application: <!-- <Resource auth="Container" driverClassName="com.mysql.cj.jdbc.Driver" factory="org.objectweb.jotm.datasource.DataSourceFactory" maxactive="10" maxidle="10" maxwait="-1" name="jdbc/ModelHouseCT" password="<SCHEMA PASSWORD>" type="javax.sql.DataSource" url="<APPLICATION URL>" username="<SCHEMA USERNAME>"/> <Resource auth="Container" driverClassName="com.mysql.cj.jdbc.Driver" factory="org.objectweb.jotm.datasource.DataSourceFactory" maxactive="10" maxidle="10" maxwait="-1" name="jdbc/ModelHouse" password="<SCHEMA PASSWORD>" type="javax.sql.DataSource" url="<APPLICATION URL>" username="<SCHEMA USERNAME>"/> --> Sigma: <!-- <Resource auth="Container" driverClassName="com.mysql.cj.jdbc.Driver" factory="org.objectweb.jotm.datasource.DataSourceFactory" maxactive="10" maxidle="10" maxwait="-1" name="jdbc/SigmaCanvasDataSource" password="<SCHEMA PASSWORD>" type="javax.sql.DataSource" url="<APPLICATION URL>" username="<SCHEMA USERNAME>"/> <Resource auth="Container" driverClassName="com.mysql.cj.jdbc.Driver" factory="org.objectweb.jotm.datasource.DataSourceFactory" maxactive="10" maxidle="10" maxwait="-1" name="jdbc/SigmaAppDataSource" password="<SCHEMA PASSWORD>" type="javax.sql.DataSource" url="<APPLICATION URL>" username="<SCHEMA USERNAME>"/> --> Canvas Studio: <!-- <Resource auth="Container" driverClassName="com.mysql.cj.jdbc.Driver" factory="org.objectweb.jotm.datasource.DataSourceFactory" maxactive="10" maxidle="10" maxwait="-1" name="jdbc/ExpertStudio" password="<SCHEMA PASSWORD>" type="javax.sql.DataSource" url="<APPLICATION URL>" username="<SCHEMA USERNAME>"/> <Resource auth="Container" driverClassName="com.mysql.cj.jdbc.Driver" factory="org.objectweb.jotm.datasource.DataSourceFactory" maxactive="10" maxidle="10" maxwait="-1" name="jdbc/ExpertStudioTarget" password="<SCHEMA PASSWORD>" type="javax.sql.DataSource" url="<APPLICATION URL>" username="<SCHEMA USERNAME>"/> -->

   
   
   

...