RunningOnOracle

This is version 33. It is not the current version, and thus it cannot be edited.
[Back to current version]   [Restore this version]

Table of Contents

• [1] Create Database Schema
• [2] Setup JDBC Driver
• [3] Edit build.properties in the main AppFuse Directory (optional)
• [4] Generate Application
• [5] Deploy Application
• [6] Test Database Access

Create Database Schema [#1]

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 USER APPFUSE IDENTIFIED BY APPFUSE;  
GRANT CONNECT TO APPFUSE;
GRANT RESOURCE TO APPFUSE;

Setup JDBC Driver [#2]

Obtain the Oracle JDBC driver appropriate for your database and JDK version. (Oracle's license agreement will be shown just be downloading, make sure you read and understand it.)

NOTE: According to the Oracle JDBC Driver README , classes12.jar is for JDK1.2 & 1.3, ojdbc14.jar is for JDK 1.4. The instructions here assume you will be using ojdbc14.jar, modify the instructions below accordingly if otherwise.

Next, in your {AppFuse home}/lib directory, add an "oracle" directory and place the ojdbc14.jar in it.

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

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:

• 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.

Whether you edit one or both files, here is a idea of what the database entries should look like for Oracle (modify the various fields as appropriate for your system):

database.jar=${lib.dir}/oracle/ojdbc14.jar
database.type=oracle
database.name=appfuse
database.host=localhost
#database URL for creating other databases (doesn't work with pgsql)
#database.admin.url=jdbc:${database.type}://${database.host}/template1
database.admin.username=appfuse
database.admin.password=appfuse

hibernate.dialect=net.sf.hibernate.dialect.Oracle9Dialect
database.driver_class=oracle.jdbc.driver.OracleDriver
database.url=jdbc:oracle:thin:@localhost:1521:myDB
database.username=appfuse
database.password=appfuse

Generate Application [#4]

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

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.

Deploy Application [#5]

Run "ant setup" within your new web app directory to compile and deploy your new application on Tomcat. Start tomcat and bring up the application: http://localhost:8080/myappname

Test Database Access [#6]

To test that database accesses are working properly, edit one of the profiles within the sample application and change the country listed. Then, within Oracle SQL*Plus, log in as "appfuse" user and issue this command:

select username, country from app_user;  

If everything is working correctly, you should see that the country value has changed for the profile that you edited.