基于oracle數據庫的appfuse項目
一、環境
1、appfuse1.9.4
2. jdk1.5
3. tomcat5.5
4.ant 1.7
二、環境變量設置
JAVA_HOME=你的jdk安裝目錄,例如：
JAVA_HOME=C:\Program Files\Java\jdk1.5.0
ANT_HOME=你下載解壓后的Ant目錄,例如：
ANT_HOME=F:\apache-ant-1.7.0
注意：要拷貝一個 junit.jar 到 %ANT_HOME%/lib 下，如果 lib 下沒有 junit.jar，AppFuse 的腳本在運行時會給出警告信息。
CATALINA_HOME=你的Tomcat的安裝目錄,例如:
CATALINA_HOME=C:\Program Files\Apache Software Foundation\Tomcat 5.5
設置
-----------------------------------------------------------------------
PATH=%JAVA_HOME%/bin;%CATALINA_HOME%bin;%ANT_HOME%bin
-----------------------------------------------------------------------
三、appfuse目錄下更改
1、把Oracle的JDBC驅動文件ojdbc14.jar,classes12.jar 復制到appfuse\lib\oracle目錄下,oracle目錄要新建
2、在Oracle中新增一個用戶有兩種
(1)直接打開Oracle新增一個用戶，例如:ADMIN,權限最要少要有新增表的權限
(2)運行以下sql語句
CREATE USER ADMIN IDENTIFIED BY ADMIN; 
GRANT CONNECT TO ADMIN;
GRANT RESOURCE TO ADMIN;
3、修改build.properties文件如下
database.jar=${lib.dir}/oracle/ojdbc14.jar
database.type=oracle
database.host=10.*.*.170
#use the database schema owner and password created in step #1 above here
database.username=edu
database.password=edu
database.schema=EDU

hibernate.dialect=org.hibernate.dialect.Oracle9Dialect
database.driver_class=oracle.jdbc.driver.OracleDriver
database.url=jdbc:oracle:thin:@10.*.*.170:1521:q1spc01

4、修改bulid.xml文件
<!=================================================================== -->
    <!-- The "db-create" target creates a database based on properties       -->
    <!-- from the database.properties file                                   -->
    <!-- =================================================================== -->
    <target name="db-create" depends="init"
        description="create database for ${database.type}">
        <echo level="debug">${database.jar}</echo>
        <if>
            <equals arg1="${database.type}" arg2="oracle"/>
            <then>
                <echo message="Detected Oracle, creating database..."/>
                <echo>Creating '${database.name}' database with: ${database.type}-create.sql</echo>
                <echo>URL: ${database.admin.url}</echo>
                <copy tofile="${build.dir}/dao/gen/${database.type}-create.sql" overwrite="true" filtering="true">
                    <fileset file="metadata/sql/${database.type}-create.sql"/>
                    <filterset refid="db.variables"/>
                </copy>
           <sql onerror="continue"
<!--注意以下要與上面的bulid.properties文件的對應-->
                    driver="${database.driver_class}"
                    url="${database.url}"
                    userid="${database.username}"
                    password="${database.password}">
原來的有一句是url="${database.admin.url}"改成url="${database.url}"
看清楚了，這里花了我好長時間，要不能總是報Oracel用戶名密碼不對.
---------------------------------------------------------------------
注意還有一個地方要修改，也是在bulid.xml文件下
 <!-- =================================================================== -->
    <!--            Export the data                                          -->
    <!-- =================================================================== -->
    <target name="db-export" depends="prepare"
        description="Exports the current data in the database">
        <dbunit driver="${database.driver_class}" url="${database.url}"
            userid="${database.username}" password="${database.password}">
            <export dest="db-export.xml" format="xml"/>
        </dbunit>
    </target>
    <target name="db-load" depends="prepare" description="Loads the database with sample data">
        <!-- Conditionally change operation based on whether database is mssql -->
        <condition property="operation" value="MSSQL_CLEAN_INSERT" else="CLEAN_INSERT">
            <equals arg1="${database.type}" arg2="sqlserver"/>
        </condition>
        <property name="file" value="metadata/sql/sample-data.xml"/>
        <dbunit driver="${database.driver_class}"
            supportBatchStatement="false" url="${database.url}"
-----------------------------------------------------------------------------
            userid="${database.username}" password="${database.password}">
----------------------------------------------------------------------------
在這里要新增一個schema="${database.schema}變成以下語句
要不能會報"org.dbunit.database.AmbiguousTableNameException ."這個錯
userid="${database.username}" password="${database.password}"

schema="${database.schema}">
4、在appfuse\metadata\sql目錄新建一個文件

oracle-create.sql

文件里什么都不用寫

------------------------------------------------

四、現在開始生成你的Oracle項目了

   cd {appfuse path}
   ant new -Dapp.name=myappname -Ddb.name=appftest

   cd ..\myappname
   ant setup
五、檢驗
   啟動tomcat
   在瀏覽器敲入url：http://localhost:port/myappname檢驗是否成功！