Hi all-
I'm using the opentaps tutorial as an example....
I need to have ofbiz create tables in a remote database server. I have the
following definitions..webapp/hello3/entitydef/
entitymodel.xml - I made no changes.
entitygroup.xml - redefined the enities to...
<entity-group group="org.ofbiz.lookup" entity="HelloPerson" />
<entity-group group="org.ofbiz.lookup" entity="HelloHobby" />
<entity-group group="org.ofbiz.lookup" entity="HelloPersonHobby" />
entityengine.xml - created a new delegator..
<delegator name="partslookup" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz.lookup" datasource-name="lookuppostgres"/>
</delegator>
and created a new datasource..
<datasource name="lookuppostgres"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
schema-name="public"
field-type-name="postgres"
check-on-start="true"
add-missing-on-start="true"
use-fk-initially-deferred="false"
alias-view-columns="false"
join-style="ansi"
use-binary-type-for-blob="true">
<!-- use this attribute to make the EntityListIterator more effective for
pgjdbc 7.5devel and later:
result-fetch-size="50"
-->
<read-data reader-name="seed"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<inline-jdbc
jdbc-driver="org.postgresql.Driver"
jdbc-uri="jdbc:postgresql://192.168.0.28:5432/lookup"
jdbc-username="postgres"
jdbc-password=""
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="20"/>
<!-- <jndi-jdbc jndi-server-name="default"
jndi-name="java:comp/env/jdbc/localpostgres"
isolation-level="ReadCommitted"/>-->
<!-- <jndi-jdbc jndi-server-name="default"
jndi-name="comp/env/jdbc/xa/localpostgres" isolation-level="ReadCommitted"/>
--> <!-- Orion Style JNDI name -->
<!-- <jndi-jdbc jndi-server-name="localweblogic"
jndi-name="PostgresDataSource"/> --> <!-- Weblogic Style JNDI name -->
<!-- <jndi-jdbc jndi-server-name="default" jndi-name="jdbc/localpostgres"
isolation-level="ReadCommitted"/> --> <!-- JRun4 Style JNDI name -->
<!-- <tyrex-dataSource dataSource-name="localpostgres"
isolation-level="ReadCommitted"/> -->
</datasource>
When I restart ofbiz, the tables are not created. What am I doing wrong? The
connections in the datasource are valid since I can have ofbiz create the 700+
tables using the default delegator and this connection.
Thanks
Rick
