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>
