RunningOnOracle

This is version 35. 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
• [4] Generate Application
• [5] Deploy Application
• [6] Test Database Access

Create Database Schema [#1]

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.

CREATE USER <database-schema-owner> IDENTIFIED BY <password>;  
GRANT CONNECT TO <database-schema-owner>;
GRANT RESOURCE TO <database-schema-owner>;

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 [#3]

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

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.host=localhost
#database.admin.* info is for autogenerating schema account (works only with MySQL)
#database.admin.url=jdbc:${database.type}://${database.host}/template1
#database.admin.username=adminname
#database.admin.password=adminpwd

hibernate.dialect=net.sf.hibernate.dialect.Oracle9Dialect
database.driver_class=oracle.jdbc.driver.OracleDriver
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

Generate Application [#4]

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

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

Deploy Application [#5]

Run "ant setup" within your new web app directory to compile and deploy your new application on Tomcat. Next, 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.