Setup Project Directories - Create a directory where you will store working copies of files to be checked out from Subversion, such as <PATH>/subversion
Checkout Sample Embedded Client Project - Navigate to <PATH>/subversion
Code Block |
---|
|
[<PATH>/subversion]$ svn co https://mware.ucdavis.edu/svn/kuali/RiceApplications/sample-embedded-client/trunk/sample-embedded-client
|
Checkout the Kuali Impex Tool Code Block |
---|
|
[<PATH>/subversion]$ svn co https://test.kuali.org/svn/kul-cfg-dbs/trunk
|
Info |
---|
This creates a directory <PATH>/subversion/trunk. To make the directory structure more readable, rename trunk to kul-cfg-dbs. | Checkout the Sample Embedded Client Database Configuration Files Code Block |
---|
|
[<PATH>/subversion]$ svn co https://test.kuali.org/svn/rice-cfg-dbs/rice-client-db/branches/rice-release-1-0-0-br
|
Info |
---|
This creates a directory <PATH>/subversion/rice-release-1-0-0-br. To make the directory structure more readable, rename rice-release-1-0-0-br to rice-client-db. | Prepare Database Import Configuration - Copy <PATH>/subversion/kul-cfg-dbs/impex/impex-build.properties to <HOME>/impex-build.properties
- Set the following property values in /wiki/spaces/UCDK/pages/119111688:
Property
| Sample Value
|
---|
svn.module
| rice-cfg-dbs
| svn.base
| branches/rice-release-1-0-0-br
| torque.schema.dir
| <PATH>/subversion/rice-client-db
| drivers.directory
| <path to your client database JDBC driver> Use forward slashes, even in Windows!!!
| import.torque.database.url
| jdbc:oracle:thin:@<DB Host>.ucdavis.edu:1521:<DB SID>
| import.torque.database.user
| <user you will log in as> SYS, schema, etc.
| import.torque.database.schema
| <SCHEMA> Must be in UPPER CASE
| import.torque.database.password
| <password>
|
Set Environment Variables - Navigate to <HOME>/subversion/kul-cfg-dbs/impex
- Set JAVA_HOME
Code Block |
---|
|
[<PATH>/subversion/kul-cfg-dbs/impex]$ export JAVA_HOME=<path to Java>
|
- Set the classpath
Code Block |
---|
|
[<PATH>/subversion/kul-cfg-dbs/impex]$ export classpath=<PATH>/subversion/kul-cfg-dbs/impex/lib
|
Execute the Database Import - If you're starting with a blank database:
Code Block |
---|
|
[<PATH>/subversion/kul-cfg-dbs/impex]$ ant import
|
- If you're adding to an existing database:
Code Block |
---|
|
[<PATH>/subversion/kul-cfg-dbs/impex]$ ant create-ddl
|
Code Block |
---|
|
[<PATH>/subversion/kul-cfg-dbs/impex]$ ant dataxml-to-sql
|
- Navigate to <PATH>/subversion/rice-client-db/sql and execute the generated SQL statements.
- Navigate to <PATH>/subversion/rice-client-db/datasql and execute the generated SQL statements.
Tip |
---|
If you are updating the Database Configuration Files project from Kuali's Subversion repository and updating your client Rice database structure, delete <PATH>/subversion/rice-cfg-dbs/sql and /datasql subdirectories before running ant import, ant create-ddl, or ant dataxml-to-sql. |
|