Page History

...

Multiple FEWS schemas/systems in a single database (since 2022.01)

It is now possible to have multiple FEWS schemas/systems in a single (managed) database instance. By this you only need a single database and you can use a single OC/CM shortcut to access multiple FEWS systems.

When the database contains multiple FEWS schemas and the schema is not specified in the URL the OC/CM user gets automatically a pop-up to select the desired FEWS schema.

The schema creation script should be executed for every schema. Every FEWS schema/system can use a different FEWS version.

For non-OC/CM database connections and if you want to use a non-default schema you have to add the desired schema to the database URL.

1. jdbc:sqlserver://dummy_hostname:1433;database=dummy_databasename;user=dummy_username;password=dummy_password;currentSchema=test

2. jdbc:postgresql://dummy_hostname/dummy_databasename?user=dummy_username&password=dummy_password%currentSchema=test

3. jdbc:oracle:thin:dummy_username/dummy_password@dummy_hostname:1521:dummy_databasename/currentSchema=test

Create shortcut with existing clientConfig.xml

For the third option the path to an existing clientConfig.xml file can be entered directly, obtained by clicking on the Browse button or, alternatively, a completely new clientConfig.xml can be created by clicking the New button. This last option will by default create a clientConfig.xml file for a Stand Alone application (which could be edited to make it suitable for an Operator Client application). More information on what should be included in the clientConfig.xml file can be found at: Root Configuration Files for Operator Client and Forecasting Shell Servers. When this option is selected, shortcuts can be created at three possible locations (Desktop, Start Menu and/or Region Home directory, which is the same as the location of the clientConfig.xml file).

...

1. Create a new folder (somewhere on your system) where the application will be located. We'll use /FEWS/201802/ in this example.
2. Create a /bin/ folder in this (201802) folder.
3. Copy/extract the FEWS build package in this /bin/ folder.
4. Copy a (Stand Alone) application folder into this (201802) folder. This is the Region Home folder for this application. We'll use /FEWS/201802/Example_SA/ in this example.
5. Copy the patch into the Region Home folder (Example_SA). The directory structure should now look similar to this (some elements are optional):
   

6. Open the clientConfig.xml file here, if it exists, and check if it contains at minimum the configuration below. More configuration options are available (see its XML schema and/or documentation page: Root Configuration Files for Operator Client and Forecasting Shell Servers). If the file does not exist, it can either be created manually with this minimum configuration or, alternatively, it can be created automatically during step 8.

   Code Block
   language xml
   <?xml version="1.0" encoding="UTF-8"?> <clientConfiguration xmlns="http://www.wldelft.nl/fews" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.wldelft.nl/fews http://fews.wldelft.nl/schemas/version1.0/clientConfig.xsd"> <clientType>Stand alone</clientType> </clientConfiguration>

   
   

7. Navigate to /FEWS/201802/bin/windows/ and double-click createShortcuts.exe.
8. Click the option to use a clientConfig.xml file, navigate to the relevant folder (/FEWS/201802/Example_SA) using the Browse button and click on the clientConfig.xml file there. Alternatively, if it does not exist yet it can now be created automatically using the New button (make sure to place it in the same /FEWS/201802/Example_SA folder). Depending on your choices, the menu will look similar to this:
   
9. Select the location(s) to place the shortcut(s) and click on 'Create shortcuts'.
10. The next time you would like to start the application you can use any of the just created shortcuts.

...