You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Jacques Le Roux <ja...@les7arts.com> on 2015/05/21 09:26:02 UTC
Re: Using OFBiz with DB2 for i (AS400) database
I propose we copy those params into EntityEngine.xml (with a comment about "Since version V7R1 (AS/400, db2)")
Could you please confirm you did not cross issues later Robert?
We would need also to download the JDBC driver with Ant+Ivy...
Jacques
Le 14/04/2015 13:37, robertpic a écrit :
> 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.
>
Re: Using OFBiz with DB2 for i (AS400) database
Posted by Rishi Solanki <ri...@gmail.com>.
Thanks for update Robert, this is great to see evidence that OFBiz scales
for large set of data.
The performance issue you had, could you please share its details. As far
as I know OFBiz can handle millions of products without any issue. Like
what you have setup in the cache and how it helps you to resolve your
performance problem.
Also do you need any external tool to resolve it or OFBiz was capable to do
that after setting the cache etc.
May be you like to share your experience with community on how easy or
difficult it was to overcome from the problem you were having.
Best Regards,
--
Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co
On Fri, Nov 23, 2018 at 7:26 PM robertpic <ro...@odoerfer.com>
wrote:
> 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/ <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
Posted by robertpic <ro...@odoerfer.com>.
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/ <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
Posted by robertpic <ro...@odoerfer.com>.
>>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
Posted by Jacques Le Roux <ja...@les7arts.com>.
Thanks for the update Robert,
I wish you best luck for the production release
Jacques
Le 06/07/2017 à 00:37, robertpic a écrit :
> @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
>
> <http://ofbiz.135035.n4.nabble.com/file/n4707470/Screenshot_Werkzeug.jpg>
>
> mobile
> <http://ofbiz.135035.n4.nabble.com/file/n4707470/Screenshot_Mobile.jpg>
>
>
>
> --
> 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
Posted by Taher Alkhateeb <sl...@gmail.com>.
Hi Robert,
Just out of curiosity, are you folks actually running DB2 on an IBM
AS/400 machine?
I didn't know those still exist, any reason why you chose this
architecture in the first place? Or is that a legacy system?
On Thu, Jul 6, 2017 at 1:37 AM, robertpic
<ro...@odoerfer.com> wrote:
> @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
>
> <http://ofbiz.135035.n4.nabble.com/file/n4707470/Screenshot_Werkzeug.jpg>
>
> mobile
> <http://ofbiz.135035.n4.nabble.com/file/n4707470/Screenshot_Mobile.jpg>
>
>
>
> --
> 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
Posted by robertpic <ro...@odoerfer.com>.
@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
<http://ofbiz.135035.n4.nabble.com/file/n4707470/Screenshot_Werkzeug.jpg>
mobile
<http://ofbiz.135035.n4.nabble.com/file/n4707470/Screenshot_Mobile.jpg>
--
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
Posted by Jacques Le Roux <ja...@Les7Arts.com>.
Hi Robert,
I haved copied your proposition for the DB2 data source at r1730616. Please
check, thanks!
--
View this message in context: http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633p4677172.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Using OFBiz with DB2 for i (AS400) database
Posted by Jacques Le Roux <ja...@les7arts.com>.
Thanks Robert,
I will document on this basis
Jacques
Le 21/05/2015 14:35, robertpic a écrit :
> 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
Posted by robertpic <ro...@odoerfer.com>.
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.