基于oracle數(shù)據(jù)庫(kù)的appfuse項(xiàng)目
一、環(huán)境
1、appfuse1.9.4
2. jdk1.5
3. tomcat5.5
4.ant 1.7
二、環(huán)境變量設(shè)置
JAVA_HOME=你的jdk安裝目錄,例如：
JAVA_HOME=C:\Program Files\Java\jdk1.5.0
ANT_HOME=你下載解壓后的Ant目錄,例如：
ANT_HOME=F:\apache-ant-1.7.0
注意：要拷貝一個(gè) junit.jar 到 %ANT_HOME%/lib 下，如果 lib 下沒(méi)有 junit.jar，AppFuse 的腳本在運(yùn)行時(shí)會(huì)給出警告信息。
CATALINA_HOME=你的Tomcat的安裝目錄,例如:
CATALINA_HOME=C:\Program Files\Apache Software Foundation\Tomcat 5.5
設(shè)置
-----------------------------------------------------------------------
PATH=%JAVA_HOME%/bin;%CATALINA_HOME%bin;%ANT_HOME%bin
-----------------------------------------------------------------------
三、appfuse目錄下更改
1、把Oracle的JDBC驅(qū)動(dòng)文件ojdbc14.jar,classes12.jar 復(fù)制到appfuse\lib\oracle目錄下,oracle目錄要新建
2、在Oracle中新增一個(gè)用戶(hù)有兩種
(1)直接打開(kāi)Oracle新增一個(gè)用戶(hù)，例如:ADMIN,權(quán)限最要少要有新增表的權(quán)限
(2)運(yùn)行以下sql語(yǔ)句
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文件的對(duì)應(yīng)-->
                    driver="${database.driver_class}"
                    url="${database.url}"
                    userid="${database.username}"
                    password="${database.password}">
原來(lái)的有一句是url="${database.admin.url}"改成url="${database.url}"
看清楚了，這里花了我好長(zhǎng)時(shí)間，要不能總是報(bào)Oracel用戶(hù)名密碼不對(duì).
---------------------------------------------------------------------
注意還有一個(gè)地方要修改，也是在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}">
----------------------------------------------------------------------------
在這里要新增一個(gè)schema="${database.schema}變成以下語(yǔ)句
要不能會(huì)報(bào)"org.dbunit.database.AmbiguousTableNameException ."這個(gè)錯(cuò)
userid="${database.username}" password="${database.password}"

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

oracle-create.sql

文件里什么都不用寫(xiě)

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

四、現(xiàn)在開(kāi)始生成你的Oracle項(xiàng)目了

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

   cd ..\myappname
   ant setup
五、檢驗(yàn)
   啟動(dòng)tomcat
   在瀏覽器敲入url：http://localhost:port/myappname檢驗(yàn)是否成功！