Chris, Thanks for the quick reply. You were right, I changed the web.xml file and the entity engine created the tables in the remote database. However, when I go to WebTools and click on the new tables, I get the following error: Target exception: org.ofbiz.entity.GenericEntityException: Helper name not found for entity HelloHobby (Sourced file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh : Method Invocation delegator.findCountByCondition) (Error running BSH script at [component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh], line [121]: Sourced file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh : Method Invocation delegator.findCountByCondition : at Line: 121 : in file: component://webtools/webapp/webtools/WEB-INF/actions/entity/FindGeneric.bsh : delegator .findCountByCondition ( findByEntity .getEntityName ( ) , condition , null ) The generic helper is defined in the datasource. what other change is needed? Thanks Rick
Richard Fleming <[EMAIL PROTECTED]> wrote: 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... entityengine.xml - created a new delegator.. and created a new datasource.. 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"> result-fetch-size="50" --> 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"/> --> --> --> --> --> 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
