ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From robertpic <robert.pichelho...@odoerfer.com>
Subject Re: Using OFBiz with DB2 for i (AS400) database
Date Tue, 14 Apr 2015 11:37:40 GMT
FYI

We have installed Apache Ofbiz on Debian 7 ("Wheezy") and use DB2 for i
AS/400 as database.

Since version V7R1 (AS/400, db2) there is no need for an own fieldtype.xml -
just use the derby-fieldtypes like this:

<datasource name="devdb2"
        helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
        schema-name="OFBIZ"
        field-type-name="derby"
        check-on-start="true"
        add-missing-on-start="true"
        use-pk-constraint-names="false"
        use-indices-unique="false"
        alias-view-columns="false"
        use-order-by-nulls="true"
        offset-style="fetch">
        <read-data reader-name="tenant"/>
        <read-data reader-name="seed"/>
        <read-data reader-name="seed-initial"/>
        <read-data reader-name="demo"/>
        <read-data reader-name="ext"/>
        <read-data reader-name="ext-test"/>
        <read-data reader-name="ext-demo"/>
        
        <inline-jdbc
            jdbc-driver="com.ibm.as400.access.AS400JDBCDriver"
           
jdbc-uri="jdbc:as400:192.168.1.10;prompt=false;libraries=ofbiz;lazy
close=true;translate binary=true"
            jdbc-username="OFBIZUSR"
            jdbc-password="***"
            isolation-level="ReadCommitted"
            pool-minsize="2"
            pool-maxsize="250"
                time-between-eviction-runs-millis="600000"/>
        
</datasource>

I've copied the jdbc parms (lazy close...) from my hibernate projects. I'll
check this later. The demo and our first steps running without problems.

Important:
- You have the create the schemas manually. (Gabriel wrote this already)
- the codepage of the user (in my case OFBIZUSR) is used for the create
table (CCSID)
--> actually we use an ebcdic codepage, this allow green screen programs to
access the data with native database commands

   




--
View this message in context: http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633p4666589.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Mime
View raw message