FioranoMQ can be configured to store the messages in a JDBC-compliant relational database. By default, FioranoMQ is configured to use the HSQL database. Fiorano ships the library containing the JDBC driver for HSQL with the FioranoMQ product. If a different RDBMS is required, administrators need to create the FioranoMQ database in their RDBMS. If FioranoMQ needs to store messages in an Oracle database, administrators are expected to create database tables for storing messages and related content in the Oracle database. FioranoMQ provides scripts that can be used to create the required tables.
These scripts need to be executed before running the RDBMS enabled FioranoMQ server. These scripts accept the URL, UserName and Password as system variables and then create the file-based or RDBMS-based databases.
A FioranoMQ database can be created using:
- Command Line parameters
- Fiorano Studio