Hi Jarrod.
My company is using Informix SE with the entity engine.
Notice the join-style is theta-ifnromix We had to make some changes to
the entity engine to deal with this.
we also created a field-type file to fit our needs but that was nothing
special. Informix SE has no VARCHAR or TEXT types, Things like that.
I would have to look into the code to find the changes we made to do
the join. It was a while ago.
We are only using informix for the next year or so then plan to move to
postgres once our port is complete.
Well worth the effort getting it going. The entity engine has worked
great for us.
Reply to this thread if you are still moving ahead with informix and
maybe I can help.
-mark
<datasource name="telesoftinformix"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
field-type-name="informix"
check-on-start="false"
add-missing-on-start="false"
check-indices-on-start="false"
use-foreign-keys="true"
use-foreign-key-indices="true"
use-fk-initially-deferred="false"
join-style="theta-informix"
schema-name="sunbelt"
use-schemas="true"
alias-view-columns="true">
<read-data reader-name="main"/>
<inline-jdbc
jdbc-driver="com.informix.jdbc.IfxDriver"
jdbc-uri="jdbc:informix-sqli://server:1532//var/dev:informixserver=svrname"
jdbc-username="dbuser"
jdbc-password="dbpass"
isolation-level="None"
pool-minsize="1"
pool-maxsize="20"/>
<!-- <jndi-jdbc jndi-server-name="localjndi"
jndi-name="java:/HsqlDataSource" isolation-level="ReadUncommitted"/>
-->
<!-- <jndi-jdbc jndi-server-name="default"
jndi-name="comp/env/jdbc/xa/localhsql"
isolation-level="ReadUncommitted"/> --> <!-- Orion Style JNDI
name -->
</datasource>
Jarrod Ribble wrote:
Has anyone connected the
entity engine to Informix?
I’m looking for an Informix datasource example and fieldtype.xml file.
Thanks,
Jarrod Ribble
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev
Locked
