Versions Compared

Version Old Version 52 New Version 53
Changes made by

Former user

Former user

Saved on

Key

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

...

  1. Checkout the project
    No Format
    svn checkout https://svn.kuali.org/repos/ole/branches/dev/50-upgrade-test-1
  2. Change into the directory for the ole-sql module
    No Format
    cd ole-app/ole-db/ole-sql
  3. Bundle the SQL
    No Format
    mvn clean install
  4. Execute the SQL
    No Format
    mvn initialize -N -Pdb,mysql -N
  5. The default MySQL process assumes
    1. There is a MySQL server running locally
    2. The server is version 5.1+
    3. The root user for MySQL does not have a password
    4. The server is listening for connections on port 3306
    5. The JDBC URL that must respond is jdbc:mysql://localhost
  6. The process will create a database user named OLE with the password set to OLE
  7. The process will create and populate a database named OLE
  8. To execute the SQL against an Oracle database
    No Format
    mvn initialize -N -Pdb,oracle -N

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 and database to create

jdbc.password

OLE

The password for the OLE user

...

  1. Default property values can be customized by
    1. Using -Dname=value to set a system property
      No Format
      mvn initialize -N -Pdb,mysql -N -Dmysql.dba.password=xyz
    2. Adding them to the properties file
      No Format
      ~/.kuali/ole/ole-sql.properties
  2. System properties always win if a custom value is provided in both places