OLE Database Process

Checkout the project

svn checkout https://svn.kuali.org/repos/ole/branches/dev/50-upgrade-test-1

Change into the directory for the ole-sql module
```
cd ole-app/ole-db/ole-sql
```
Bundle the SQL
```
mvn clean install
```
Change directories back to the OLE FS directory
```
cd ../../ole-fs
```
Execute the SQL
```
mvn initialize -Pdb
```
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
The process will create a database user named OLE with the password set to OLE
The process will create and populate a database named OLE
To execute the SQL against an Oracle database
```
mvn initialize -Pdb,oracle
```

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

Default property values can be customized by
1. Setting a system property. You can do this on the command line using -Dname=value
```
mvn initialize -Pdb -Dmysql.dba.password=xyz
```
2. Adding them to the properties file
```
~/.kuali/ole/ole-fs.properties
```
System properties always win if the same customized property value is provided in more than one spot