...
Configure sbwdb.cfgfile in the FES profile located at FIORANO_HOME/esb/server/profiles/<PROFILE NAME>/FES/conf by enabling all the properties related to the respective database and disabling the default settings.
Tip For example, to use an Oracle database,
uncomment the following line:
Code Block #JDBC_DRIVER=oracle.jdbc.driver.OracleDriver
comment out the default one below:
Code Block JDBC_DRIVER=org.h2.Driver
Figure 1: sbwdb.cfg file data after commenting and commenting out properties for Oracle DB
Follow the same process for all the properties where Oracle-specific details are enabled and disable the defaults.Note For an HA profile, configure these settings in the secondary profile too.
To store the message as XML, set the REPRESENTABLE_DATA_TYPES property (property #12) to 'true'.
Info Retaining the value as 'false' allows to store the message as a blob.
Figure 2: sbwdb.cfg file data with REPRESENTABLE_DATA_TYPES set to 'true'
Add the driver in FES server classpath in the FIORANO_HOME/esb/server/bin/server.conf under <java.classpath> section.
Tip - Place the file in the FES machine to use the path here.
- Both absolute and relative paths will work.
Restart the server.
Note Check the server logs to ensure that there are no error messages during the startup.
...