将Ofbiz数据库迁移到OracleXE

1,将ofbiz迁移到OracleXE：
Oracle的web端口8080和Ofbiz冲突，更改Oracle的端口，Ofbiz有些地方已经写死了：
执行以下SQL语句：

call dbms_xdb.cfg_update(updateXML(dbms_xdb.cfg_get(),'/xdbconfig/sysconfig/protocolconfig/httpconfig/http-port/text()',8088))

或者：

call dbms_xdb.sethttpport('8088'); 

2,更改oracle字符集，更改oracle的日期格式化字符串；

sqlplus :
sql>connect system/zha798186@xe as sysdba
sql>shutdown immediate;
sql>startup mount;
sql>alter system enable restricted session;
sql>alter system enable restricted session ;
sql>alter system set JOB_QUEUE_PROCESSES=0;
sql>alter system set AQ_TM_PROCESSES=0;
sql>alter database open;
sql>alter database character set internal_use ZHS16GBK;
sql>shutdown immediate;
sql>startup mount; 

3.调整时间格式：
执行过程

UPDATE sys.PROPS$ SET value$='YYYY-MM-DD HH24:MI:SS.FF'
WHERE NAME='NLS_TIMESTAMP_FORMAT';
UPDATE sys.PROPS$ SET value$='YYYY-MM-DD HH24:MI:SS.FF'
WHERE NAME='NLS_TIMESTAMP_TZ_FORMAT';
commit;

还要加以下内容

UPDATE sys.PROPS$ SET value$='YYYY-MM-DD'
WHERE NAME='NLS_DATE_FORMAT';
UPDATE sys.PROPS$ SET value$='ZHS16GBK'
WHERE NAME='NLS_DATE_LANGUAGE';
UPDATE sys.PROPS$ SET value$='HH24:MI:SS.FF'
WHERE NAME='NLS_TIME_FORMAT'; 

4，修改D:\JavaPrj\ofbiz-trunk\framework\entity\config\entityengine.xml

<delegator name="default" entity-model-reader="main" entity-group-reader="main" entity-eca-reader="main" distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz" datasource-name="[color=red]localoracle[/color]"/>
<group-map group-name="org.ofbiz.olap" datasource-name="localderbyolap"/>
</delegator>

 <datasource name="localoracle"
            helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"            
            field-type-name="oracle"
            check-on-start="true"
            add-missing-on-start="true"
            alias-view-columns="false"
            join-style="ansi">
        <read-data reader-name="seed"/>
        <read-data reader-name="seed-initial"/>
        <read-data reader-name="demo"/>
        <read-data reader-name="ext"/>
        <inline-jdbc
                jdbc-driver="oracle.jdbc.driver.OracleDriver"
               [color=red] jdbc-uri="jdbc:oracle:thin:@192.168.1.100:1521:XE"
                jdbc-username="scott"
                jdbc-password="tiger"[/color]
                pool-minsize="2"
                pool-maxsize="250"/>
    </datasource>

5，ant clean-all 然后 ant run-install
6，startofbiz.bat
7，https://localhost:8443/webtools/

Visual Theme resources not found.
初始化数据和导入：
ofbiz$ java -jar ofbiz.jar -install
通过以上命令即可进行数据库的初始化和初始数据的导入，这里包括了ofbiz自带的例子，应用的所有的数据表和初始化数据


顺便补充一个mysql的：

<datasource name="localmysql"
            helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
            field-type-name="mysql"
            check-on-start="true"
            add-missing-on-start="true"
            check-pks-on-start="false"
            use-foreign-keys="true"
            join-style="ansi-no-parenthesis"
            alias-view-columns="false"
            drop-fk-use-foreign-key-keyword="true"
            table-type="InnoDB"
            character-set="utf8"
            collate="utf8_general_ci">
        <read-data reader-name="seed"/>
        <read-data reader-name="seed-initial"/>
        <read-data reader-name="demo"/>
        <read-data reader-name="ext"/>
        <inline-jdbc
                jdbc-driver="com.mysql.jdbc.Driver"
                jdbc-uri="jdbc:mysql://127.0.0.1:3309/ofbiz_db?autoReconnect=true"
                jdbc-username="ofbiz"
                jdbc-password="ofbiz"
                isolation-level="ReadCommitted"
                pool-minsize="2"
                pool-maxsize="250"/>
        <!-- <jndi-jdbc jndi-server-name="localjndi" jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> -->
    </datasource>