Gabriel, There have been questions posted in the past about db2 support. If you would file an improvement/new feature JIRA and provide patches, I am sure these enhancements would be regarded as welcome.
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 Wed, Apr 23, 2014 at 2:55 PM, Gabriel Oberreuter <[email protected]>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. >
