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.