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
```
Execute the SQL
```
mvn initialize -N -Pdb,mysql
```
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 the default MySQL port which is 3306
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 -N -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 and database to create
jdbc.password	OLE	The password for the `OLE` user