Versions Compared

Version Old Version 40 New Version 41
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 -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 connection URL that must respond is jdbc:mysql://localhost
  6. To execute the SQL against an Oracle database
    No Format
    mvn initialize -Pdb,oracle -N
  7. The process will create a database user named OLE with the password set to OLE
  8. The process will create and populate a database named OLE
  9. To execute the SQL against an Oracle database
    No Format
    mvn initialize -Pdb,oracle -N

PROPERTIES

Name

Default

Description

mysql.dba.url

jdbc:mysql://localhost

The URL the MySQL dba user connects to

mysql.dba.username

root

MySQL user with dba privileges

mysql.dba.password

NONE

Special value meaning there is no password for root

oracle.dba.url

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

The URL the Oracle dba user 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

jdbc.username

OLE

The name of the user and database to create

jdbc.password

OLE

The password for OLE

...