Page Comparison

...

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

   Multi App Schema enables you to use a single configuration schema for different applications, in this case, SmartBank and other applications. 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.
   Image Removed
   Image Added
6. Double-click the run windows batch file to generate the DB scripts.
   Image Removed
   Image Added
   The DB scripts get generated. 
   Image Removed
   Image Added

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 schema names for application, Studio, and Sigma application that were provided in the config.txt file, must be specified in the server.xml file.

   
   Image RemovedImage Added
   The following sample code snippet serves as a reference of server.xml file for the schema details of sample application (Modelhouse), Sigma and Canvas Studio:

   Code Block
   language xml
   <!-- Schema for application, e.g. Modelhouse --> <Resource auth = "Container" driverClassName = "com.mysql.cj.jdbc.Driver" factory = "org.objectweb.jotm.datasource.DataSourceFactory" maxactive = "10" maxidle = "10" maxwait = "-1" name = "jdbc/ModelHouseCT" username = "<SCHEMA USERNAME>" password = "<SCHEMA PASSWORD>" type = "javax.sql.DataSource" url = "<APPLICATION URL>" /> <Resource auth = "Container" driverClassName = "com.mysql.cj.jdbc.Driver" factory = "org.objectweb.jotm.datasource.DataSourceFactory" maxactive = "10" maxidle = "10" maxwait = "-1" name = "jdbc/ModelHouse" username = "<SCHEMA USERNAME>" password = "<SCHEMA PASSWORD>" type = "javax.sql.DataSource" url = "<APPLICATION URL>" /> <!-- Schema for Sigma application --> <Resource auth = "Container" driverClassName = "com.mysql.cj.jdbc.Driver" factory = "org.objectweb.jotm.datasource.DataSourceFactory" maxactive = "10" maxidle = "10" maxwait = "-1" name = "jdbc/SigmaCanvasDataSource" username = "<SCHEMA USERNAME>" password = "<SCHEMA PASSWORD>" type = "javax.sql.DataSource" url = "<APPLICATION URL>" /> <Resource auth = "Container" driverClassName = "com.mysql.cj.jdbc.Driver" factory = "org.objectweb.jotm.datasource.DataSourceFactory" maxactive = "10" maxidle = "10" maxwait = "-1" name = "jdbc/SigmaAppDataSource" username = "<SCHEMA USERNAME>" password = "<SCHEMA PASSWORD>" type = "javax.sql.DataSource" url = "<APPLICATION URL>" /> <!-- Schema for 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" username = "<SCHEMA USERNAME>" password = "<SCHEMA PASSWORD>" type = "javax.sql.DataSource" url = "<APPLICATION URL>" /> <Resource auth = "Container" driverClassName = "com.mysql.cj.jdbc.Driver" factory = "org.objectweb.jotm.datasource.DataSourceFactory" maxactive = "10" maxidle = "10" maxwait = "-1" name = "jdbc/ExpertStudioTarget" username = "<SCHEMA USERNAME>" password = "<SCHEMA PASSWORD>" type = "javax.sql.DataSource" url = "<APPLICATION URL>" />

   
   

...