6.4 Creating a Default Database

Following topics are covered in this section:

 

FioranoMQ comes with a script (fmq/bin/ create-database) that allows the creation of a default database for the server. This script accepts input from the database in the following ways:

• Through the command line parameters
• Through a pre-configured Fiorano Profile

6.4.1 Command Line Parameters

The following command lines are accepted through the create-database script

• driver :This parameter specifies the class name of the driver class for the database.

• url: This parameter specifies the URL of the database.

• username: This parameter specifies the login name of the User that the database script uses to connect to the database.

• password: This parameter specifies the Password of the User that the database script uses to connect to the database.

• 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 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.

6.4.2 Pre-configured Profile

Configure the server to enable RDBMS as explained in Enabling RDBMS section. 

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

Profile Directory is relative to the profiles directory. 

If the profile is not specified, the default profile FioranoMQ is used.