Thanks. Then I will file a Jira ticket (hopefully doing it right, never done that before).
On Wed, Apr 23, 2014 at 10:27 AM, adrian.crum [via OFBiz] < [email protected]> wrote: > For the most part, that is the normal configuration process. I am > surprised we don't have a fieldtype.xml file for DB2. Please feel free > to create a Jira ticket and include your DB2 fieldtype.xml file. > > Adrian Crum > Sandglass Software > www.sandglass-software.com > > On 4/23/2014 5:55 AM, Gabriel Oberreuter wrote: > > > Hi, I was trying to connect OFBiz to the database which is included in > IBMi > > operating system. > > This database is "DB2 for i", and as DERBY (the db OFBiz includes and > uses > > by default) was bought by IBM and certified with its own db, I thought > it > > shouldn't be so hard to use DB2 for i instead. > > I had to do the following: > > > > - copy the file framework\entity\fieldtype\fieldtypederby.xml into the > new > > framework\entity\fieldtype\fieldtypedb2fori.xml file > > - replace sql-type="DOUBLE" with sql-type="FLOAT" (DB2 for i > specification > > names FLOAT to DOUBLES) > > - create the db2fori entry in framework\entity\config\entityengine.xml > > (copying the entries of derby) and pointing to the new file, as with the > > other databases > > - include lib for db2fori connection (I used jt400-6.7.jar): copied into > > framework\entity\lib\jdbc > > - also, schemas have to be manually created (I don't know if there is a > > command to create schemas automatically if they don't exist as ofbiz > does > > with derby db) > > (create schema OFBIZ, create schema OFBIZOLAP, create schema OFBIZTENAN) > > > > doing this, and configuring entityengine.xml accordingly, I could use > OFBiz > > with DB2 for i, the database that comes with IBMi systems. > > > > Just informing this as some other could find this useful. Also, is this > > worth to consider it as a modification to ofbiz to make it more generic? > > > > Cheers! > > > > > > > > -- > > View this message in context: > http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633.html > > Sent from the OFBiz - User mailing list archive at Nabble.com. > > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > > http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633p4650637.html > To unsubscribe from Using OFBiz with DB2 for i (AS400) database, click > here<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4650633&code=Z29iZXJyZXV0ZXJAZ21haWwuY29tfDQ2NTA2MzN8MjA4MDg2ODQ4NQ==> > . > NAML<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- Gabriel Oberreuter Mobile: +56 9 85299198 Innovandio S.A. -- View this message in context: http://ofbiz.135035.n4.nabble.com/Using-OFBiz-with-DB2-for-i-AS400-database-tp4650633p4650641.html Sent from the OFBiz - User mailing list archive at Nabble.com.
