Page Comparison

...

Checkout the project

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

Change into the directory for the ole-sql module
No Format
cd ole-app/ole-db/ole-sql
Bundle the SQL
No Format
mvn clean install
Change directories back to the OLE FS directory
No Format
cd ../../../ole
Execute the SQL
No Format
mvn initialize -N -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
No Format
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/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
  No Format
  mvn initialize -N -Pdb -Dmysql.dba.password=xyz
2. Adding them to the properties file
  No Format
  ~/.kuali/ole/ole-fs.properties
System properties always win if the same customized property value is provided in more than one spot

Versions Compared