Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Financials development requires a standalone Rice instance.  Here are instructions to setup a standalone rice instance and database to use for development.

Setup Database

These procedures will create 3 databases in MySql:

  • kfsonly - This database contains Financials tables and no Rice tables.  It is used by Financials when running with standalone Rice.
  • rice - This database contains Rice tables only.  It is used by the standalone rice instance.
  • kfs - This database contains both Financials and Rice tables.  It is used for the unit tests.

Steps

  1. Login to Mysql as the root user.  Run these commands to create the databases, users and permissions.

    create database kfs default character set 'utf8' default collate 'utf8_bin';
create database kfsonly default character set 'utf8' default collate 'utf8_bin';
create database rice default character set 'utf8' default collate 'utf8_bin';

create user kfs@localhost identified by 'kfs';
create user kfs@'%' identified by 'kfs';

create user kfsonly@localhost identified by 'kfsonly';
create user kfsonly@'%' identified by 'kfsonly';

create user rice@localhost identified by 'rice';
create user rice@'%' identified by 'rice';

grant all on kfs.* to kfs@localhost;
grant all on kfs.* to kfs@'%';

grant all on kfsonly.* to kfsonly@localhost;
grant all on kfsonly.* to kfsonly@'%';

grant all on rice.* to rice@localhost;
grant all on rice.* to rice@'%';

  2. Create a properties file for LiquiRelational to populate the kfsonly and rice databases.  Name the file lr-kfsonly.properties.  Here are the contents:

    datasource.driver=com.mysql.jdbc.Driver

kfs.datasource.ddl.username=kfsonly
kfs.datasource.ddl.password=kfsonly
kfs.datasource.ddl.url=jdbc:mysql://localhost/kfsonly

rice.datasource.ddl.url=jdbc:mysql://localhost/rice
rice.datasource.ddl.username=rice
rice.datasource.ddl.password=rice

updateDatabaseFullRebuild=true
updateDatabaseContext=demo

  3. Create a properties file for LiquiRelational to populate the kfs database.  Name the file lr-kfs.properties.  Here are the contents:

    datasource.driver=com.mysql.jdbc.Driver

kfs.datasource.ddl.username=kfs
kfs.datasource.ddl.password=kfs
kfs.datasource.ddl.url=jdbc:mysql://localhost/kfs

rice.datasource.ddl.url=jdbc:mysql://localhost/kfs
rice.datasource.ddl.username=kfs
rice.datasource.ddl.password=kfs

updateDatabaseFullRebuild=true
updateDatabaseContext=unit

  4. Run LiquiRelational for kfsonly and rice.  Make sure to adjust the paths appropriately.  You must be in the root of the financials project when running this.

    mvn -DskipTests clean package
java -classpath ./kfs-web/target/kfs-web/WEB-INF/lib/*:/Users/user/java/drivers/mysql-connector-java-5.1.36.jar -Dadditional.kfs.config.locations=/Path/lr-kfsonly.properties co.kuali.financials.datatools.liquirelational.LiquiRelational

  5. Run LiquiRelational for kfs  Make sure to adjust the paths appropriately.  You must be in the root of the financials project when running this.

    mvn -DskipTests clean package (you do not need to run this again if you ran it in step 4 without making code changes)
java -classpath ./kfs-web/target/kfs-web/WEB-INF/lib/*:/Users/user/java/drivers/mysql-connector-java-5.1.36.jar -Dadditional.kfs.config.locations=/Path/lr-kfs.properties co.kuali.financials.datatools.liquirelational.LiquiRelational

Setup Standalone Rice

Steps

 

  • No labels