Re: Using OFBiz with DB2 for i (AS400) database

[robertpic]

Update

We are running Ofbiz since 16 months (B2B) and now B2C without any troubles
on DB2 (on AS/400 aka iSeries aka Power7/8/9).

https://shop.odoerfer.com/   

We had some performance issues because of the big product tree (> 70.000
products). We used the ofbiz caching to hold the tree one day inside the
cache/memory.



--
Sent from: http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html

Re: Using OFBiz with DB2 for i (AS400) database

[robertpic]

>>Or is that a legacy system? 
Yes. We use an self-made ERP on this system for ~ 350 Users.  Most parts of
the ERP working with "green screen/telnet".

Why we chosse ofbiz?
- it can handle all our needs (multishop, variants)
- very clean overrides for i.e. own prices --> override event, extend Event
- well known technology (J2EE)

why we use db2/as400?
- for seamless integration with our greenscreen ERP (Cobol/RPG could
read/update ofbiz data)
- our db2 is clustered




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

Re: Using OFBiz with DB2 for i (AS400) database

[robertpic]

@Jacques Le Roux

DB2 data source at r1730616
looks, fine

there are some troubles with the native (AS/400) backup/restore tools
(savobj/rstobj) and the contraints.
--> actually we do an xml-export, 'll check this out later


status update
we will go online in about 2 weeks (B2B) ... and B2C in about 2 months

 

mobile
 



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

Re: Using OFBiz with DB2 for i (AS400) database

[robertpic]

Jacques Le Roux wrote
 I propose we copy those params into EntityEngine.xml (with a comment about
 Since version V7R1 (AS/400, db2))

I wrote since V7R1, because our AS/400 has V7R1 installed. I've checked the
docs and find out, that DOUBLE should work at least at version V6R1. I could
not test it, but the docs say DOUBLE is ok.
Note: Only the fieldtype is problem in early releases. All other stuff (JDBC
parameters...) should be the same in all releases.


Jacques Le Roux wrote
 Could you please confirm you did not cross issues later Robert?

We have not any problems so far. FLOAT and DOUBLE mean the same for
DB2/AS400. 
I have to say: We don't use any ERP functions and the ecommerce-project is
on an early stage (~ 15 products).
But i have not any problems with float/double in may other projects.
 

Jacques Le Roux wrote
 We would need also to download the JDBC driver with Ant+Ivy...

I'm not sure about Ant+Ivy. There is an open source version of the jdbc
driver at sourceforge:
http://sourceforge.net/projects/jt400/

About our project:
Actually we try to migrate our existing  40.000 products (online-catalog)
http://online.odoerfer.com/OdKatalog/   into OfBiz. But we have also to
record the 30.000 ERP-only producs. So I expect a Go-Live between Q4/2015 -
Q1/2016.






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

Re: Using OFBiz with DB2 for i (AS400) database

[robertpic]

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=60/

/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.