Hi Gabriel, Robert, A JIRA issue already exists. See https://issues.apache.org/jira/browse/OFBIZ-1607
Please feel free to share your solution as a patch to that issue and I am sure it will get reviewed and committed. Best regards. Pierre Smits *ORRTIZ.COM <http://www.orrtiz.com>* Services & Solutions for Cloud- Based Manufacturing, Professional Services and Retail & Trade http://www.orrtiz.com On Tue, Apr 14, 2015 at 1:37 PM, robertpic <robert.pichelho...@odoerfer.com> wrote: > 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. >