Contents

Versions Compared

Old Version 2

changes.mady.by.user Prathewraj M

Saved on

compared with

New Version 3

changes.mady.by.user Prathewraj M

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note
  • To configure the database for the FioranoMQ Server, add the corresponding JAR files to the configuration file of the server, fmq.conf. This file can be located at fmq_installation_dir\fmq\bin.
  • To start the FioranoMQ Server with one of the databasedatabases, run create-database.bat/sh file after adding the required JAR to the classpath of create-database.conf.

...

Sample Configuration

DB2

URL: jdbc:db2://<DBServer>:6789/sample

JdbcDriver: COM.ibm.db2.jdbc.net.DB2Driver

...

MaxConnections: 200

Oracle

URL: jdbc:oracle:thin:@<machine @<machine Ip>:1521:<sid>

JdbcDriver: oracle.jdbc.driver.OracleDriver

...

  • dataTypesFileName: This parameter specifies the complete path name of the file that contains the mapping of the Java data 'types' to SQL data 'types'. Please see the Sample configuration section the Sample configuration section above to know the complete property file name for a specific database. If a different database is being used, please send a mail to :  presales@fiorano.com.
  • databaseType: This parameter specifies the name of the database being used. Valid database 'types' include oracle, mssql, mysql, db2, and cloudscape. If a different database is being used, please send a mail to :  presales@fiorano.com.

Pre-configured Profile

...

Run the create-database script and specify the profile directory. Enter the 'type' of database being of the database being used. 

Code Block
create-database -profile <FMQProfile> -dataBaseType <DataBaseType>
Note
  • Ensure that the database driver classes are present in the classpath.
  • FioranoMQ ships the library that contains thejdbcdriver the JDBC driver for HSQL.

Profile Directory is relative to the profiles directory. 

...

FioranoMQ provides the option to configure the store of a destination and set it to either a File-based or a an RDBMS based database. 
The administrator is free to use both databases by creating destinations on Files and on RDBMS. To create RDBMS based destinations, follow the steps below:

  1. Launch Studio and right-click on the FMQ server node to select the server. Select Login from the pop-up menu.
  2. To create a new destination, navigate to the Destinations node.
  3. Right-click on either 'Queue' or on 'Topic' and select Add Queue or Add Topic. The dialog box that appears displays properties for the destination. Select storage type as RDBMS-Based Destination, as shown in the figure below:

...

Adaptavist ThemeBuilder EngineAtlassian Confluence