Thanks alot Chris - you've been very helpful! Rick
Chris Howe <[EMAIL PROTECTED]> wrote: I don't believe that the webtools entity maintenance script(FindGeneric.bsh) is set up to handle the possiblility of multiple delegators. your error is on the method delegator.findCountByCondition (and other delgator.someOtherMethods) if you were to run: del = delegator.getDelegatorName(); del would equal "default" The script needs to somehow determine which delegator controls the entity of interest. and then run delegator = GenericDelegator.getGenericDelegator( nameOfCorrectDelegator); then run the rest of the script --- Richard Fleming wrote: > 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 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 > >
