4. Database Configuration

In Jiffy, DB nodes can be configured with various flavours of Databases like (Postgress, Oracle and Mysql) Please find the below DB configuration url and Driver Class file details.

POSTGRESS:

During task creations in Jiffy using DB node, configuration parameters for DB node to be keyed in with DB url, JDBC driver class file name and DB credentials.

Refer the below sample screenshot for POSTGRESS database DB node configuration.

Database URL Format: jdbc:cognos:dbapi@<HOST>:<PORT>?domain= <DOMAIN> &dataSource=’<DATABASE_NAME>

Normally this is the only JDBC client connection used to establish client-server connections to Virtual View Manager, where cognos is the default value unless an LDAP or dynamic domain user is negotiating the connection.

NOTE: DB URL, DB Name specified in the URL, Username and Password may vary depends on the client-side configuration/setup.

ORACLE:

During task creations in Jiffy using DB node, configuration parameters for DB node to be keyed in with DB url , JDBC driver class file name and DB credentials .

Refer the below sample screenshot for ORACLE database DB node configuration.

Database URL Format: jdbc:cognos:dbapi@<HOST>:<PORT>?domain= <DOMAIN>&dataSource=<DATABASE_NAME>

Normally this is the only JDBC client connection used to establish client-server connections to Virtual View Manager, where cognos is the default value unless an LDAP or dynamic domain user is negotiating the connection.

NOTE: DB URL, DB Name specified in the URL, Username and Password may vary depends on the client-side configuration/setup.

MYSQL:

During task creations in Jiffy using DB node, MySQL can be configured by doing the following:

1. Server side
   • Download the jdbc driver for MySQL from here.
     Note:Make sure that the version of the jdbc driver matches with the MySQL version.
   • Unzip the downloaded file and upload the mysql-connector-java-X.X.XX.jar file to jiffy server.
     Server path: $JIFFY_HOME/orang/lib/
     Example: mysql-connector-java-5.1.48.jar
   • Give the read and execute permission to the uploaded jar using the following command.
chmod 755 $JIFFY_HOME/orang/lib/mysql-connector-java-*.jar
   • Restart the Jiffy server for safe restart of OReng processes.
supervisorctl stop OrengDesign OrengExecution
supervisorctl start OrengDesign OrengExecution
2. Jiffy Email configuration(web) Create the DB configuration in jiffy with the folowing values:
   • Driver class: com.mysql.jdbc.Driver
   • Connection string: jdbc:mysql://localhost:3306/sonoo

   NOTE: DB URL, DB Name specified in the URL, Username and Password may vary depends on the client-side configuration/setup.