Raible's Wiki: RunningOnOracle

At line 1 changed 1 line.

The following instructions explain how to configure AppFuse so that the applications it generates will work with an Oracle database.

The following instructions describe the steps required to configure AppFuse so that the applications it generates will work with an Oracle database.

At line 3 changed 1 line.

# Create the Oracle Database schema account that will hold the default application tables. This can be done by your Oracle DBA. (You can choose a different user/schema name and password, just modify the subsequent instructions accordingly.)<div class="note" style="margin: 10px">

!Table of Contents

* [1] Create Database Schema

* [2] Setup JDBC Driver

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

* [4] Generate application

* [5] Other issues

* [6] Sample CREATE DATABASE script

!!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. (You can choose a different user/schema name and password, just modify the subsequent instructions accordingly.)

At line 9 changed 4 lines.

</div>

# Obtain the [Oracle JDBC driver|http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html] appropriate for your database and JDK version. (Oracle's license agreement will be shown just be downloading, make sure you read and understand it.) <div class="note" style="margin: 10px">__NOTE:__ According to the [Oracle JDBC Driver README | http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_readme9201.html], 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.</div>

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

# 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:<div>

!!Setup JDBC Driver [#2]

Obtain the [Oracle JDBC driver|http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html] appropriate for your database and JDK version. (Oracle's license agreement will be shown just be downloading, make sure you read and understand it.)

<div class="note" style="margin: 10px">__NOTE:__ According to the [Oracle JDBC Driver README | http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_readme9201.html], 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.</div>

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

!!Edit build.properties -- 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:

At line 14 changed 1 line.

* 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.<div> 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):</div><div style="margin: 10px">

* 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.<div> 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):

At line 31 changed 1 line.

</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 "myDB" at the end should refer to the SERVICE_NAME within the tnsnames.ora database file on the database server machine.</div></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 "myDB" at the end should refer to the SERVICE_NAME within the tnsnames.ora database file on the database server machine.</div>

!!Generate application[4]

Raible's Wiki

AppFuse

Other Applications

RunningOnOracle