Raible's Wiki: RunningOnOracle

At line 6 changed 1 line.

* [3] Edit build.properties in the main AppFuse Directory (optional)

* [3] Edit build.properties in the main AppFuse Directory

At line 13 changed 1 line.

Create the Oracle Database schema account that will hold the default application tables. This can be done by your Oracle DBA. (A different user/schema name and password can be chosen, just modify the subsequent instructions accordingly.)

Create the Oracle Database schema account that will hold your application's tables. This value should correspond to the {{-Ddb.name}} you use when running the __ant new__ task.

At line 16 changed 3 lines.

CREATE USER APPFUSE IDENTIFIED BY APPFUSE;

GRANT CONNECT TO APPFUSE;

GRANT RESOURCE TO APPFUSE;

CREATE USER <database-schema-owner> IDENTIFIED BY <password>;

GRANT CONNECT TO <database-schema-owner>;

GRANT RESOURCE TO <database-schema-owner>;

At line 30 changed 1 line.

!!Edit build.properties in the main AppFuse Directory (optional) [#3]

!!Edit build.properties in the main AppFuse Directory [#3]

At line 32 changed 1 line.

Next, the build.properties file needs to be updated to switch from a MySQL to an Oracle database. This can be done in two ways:

Next, the build.properties file needs to be updated to use an Oracle (instead of the default MySQL) database.

At line 34 removed 4 lines.

* If most of your work is in Oracle, update the build.properties file in the AppFuse distribution. Most of its values will carry over to the build.properties file created within each app generated by AppFuse, so only a minor amount of editing of that second file will be necessary.

* If most of your work is not in Oracle, you can ignore the build.properties file in the AppFuse distribution, and just edit the build.properties in the directory of the web app generated by AppFuse.

At line 43 removed 1 line.

database.name=appfuse

At line 45 changed 1 line.

#database URL for creating other databases (doesn't work with pgsql)

#database.admin.* info is for autogenerating schema account (works only with MySQL)

At line 47 changed 2 lines.

database.admin.username=appfuse

database.admin.password=appfuse

#database.admin.username=adminname

#database.admin.password=adminpwd

At line 52 changed 3 lines.

database.url=jdbc:oracle:thin:@localhost:1521:myDB

database.username=appfuse

database.password=appfuse

database.url=jdbc:oracle:thin:@localhost:1521:mySID

#use the database schema owner and password created in step #1 above here

database.username=username

database.password=password

At line 57 changed 1 line.

<div class="note" style="margin: 10px">__NOTE:__ In the listings above, database.host should refer to the machine the Oracle database is running on. Also, database.url's "myDB" at the end should refer to the SERVICE_NAME within the tnsnames.ora database file on the database server machine.</div>

<div class="note" style="margin: 10px">__NOTE:__ In the listings above, database.host should refer to the machine the Oracle database is running on. Also, database.url's "mySID" at the end should refer to the SERVICE_NAME within the tnsnames.ora database file on the database server machine.</div>

At line 55 added 3 lines.

<div class="note" style="margin: 10px">__NOTE:__ There is also a {{database.name}} parameter available, but usage of it should be avoided. This parameter's value is automatically overwritten by what you will provide in the next step as the {{-Ddb.name}} parameter to the __ant new__ task.</div>

At line 61 changed 1 line.

Run "ant new -Dapp.name=myappname -Ddb.name=appfuse" as usual to generate the new web application directory.

Run "ant new -Dapp.name=myappname -Ddb.name={{mydbname}}" as usual to generate the new web application directory.

At line 63 changed 1 line.

After this is done, the build.properties file in the new "myappname" directory will need to be configured, following the instructions in [#3] above. Either a few or most of the database-related properties will need to be changed, depending on whether or not the build.properties file in the AppFuse distribution was updated.

For {{mydbname}}, use the schema owner name you created in Step #1 above.

At line 64 added 1 line.

Raible's Wiki

AppFuse

Other Applications

RunningOnOracle