Versions Compared

Version Old Version 1 New Version Current
Changes made by

Former user

Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

DEFAULT PROCESS

  1. Checkout the project Open the default local properties file
    No Format
    svn checkout https://svn~/.kuali.org/repos/ole/branchesfs/dev/50-upgrade-test-1
    Change into the directory for the ole-sql module 
    ole-fs.properties
  2. Add the workflow unpack property
  3. Default property values can be customized by
    1. Setting a system property. You can do this on the command line using -Dname=value
      No Format
      mvn initialize -Pdb -Dmysql.dba.password=xyz
    2. Adding them to the properties file
      No Format
      ~/.kuali/ole/ole-fs.properties
  4. System properties always win if the same customized property value is provided in more than one spot
    No Format
    cd ole-app/ole-db/ole-sql
  5. Bundle the SQL
    No Format
    mvn clean install
  6. Change directories back to the OLE FS directory
    No Format
    cd ../../ole-fs
  7. Execute the SQL
    No Format
    mvn initialize -Pdb
  8. The default MySQL process assumes
    1. There is a MySQL server running locally
    2. The MySQL server is version 5.1+
    3. The MySQL server is listening for connections on the default MySQL port which is 3306
    4. The root user for MySQL does not have a password which is the default
    5. There is a response from the default MySQL jdbc url which is jdbc:mysql://localhost
  9. The process will create a database user named OLE with the password set to OLE
  10. The process will create and populate a database named OLE
  11. To execute the SQL against an Oracle database
    No Format
    mvn initialize -Pdb,oracle

PROPERTIES

Name

Default

Description

mysql.dba.username

root

MySQL user with dba privileges

mysql.dba.password

NONE

Special value meaning there is no password for root

mysql.dba.url

jdbc:mysql://localhost

The JDBC URL root connects to

oracle.dba.username

SYS AS SYSDBA

Oracle user with dba privileges

oracle.dba.password

CHANGE_ON_INSTALL

The default password after a new install

oracle.dba.url

jdbc:oracle:thin:@localhost:1521:XE

The JDBC URL the Oracle dba user connects to

jdbc.username

OLE

The name of the user/database/schema to create

jdbc.password

OLE

The password for the OLE user

CUSTOMIZATION

  1. ole.workflow.unpack=true
  2. Start Tomcat

DETAILS

  1. During application startup the default workflow XML files for OLE FS will be automatically unpacked into the default pending directory
    No Format
    ~/.kuali/ole/fs/work/staging/workflow/pending
  2. You should see these 2 lines in the Tomcat output
    No Format
    
Copying [classpath:META-INF/ole-workflow.resources] -> [~/.kuali/ole/fs/work/staging/workflow/pending]
Copied 28 files
  3. Once the application has started up you will have a local directory structure that mimics what is in Subversion
    1. https://svn.kuali.org/repos/ole/branches/dev/50-upgrade-test-1/ole-app/ole-db/ole-workflow/src/main/resources/