Configuration of postgresql with Ofbiz
--------------------------------------
Key: OFBIZ-4443
URL: https://issues.apache.org/jira/browse/OFBIZ-4443
Project: OFBiz
Issue Type: Task
Components: ALL APPLICATIONS
Affects Versions: Release 10.04
Reporter: Dhiraj Gupta
i want to configure ofbiz with Postgresql.but i faced some problem in
configuration.
<delegator name="default" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz"
datasource-name="localpostgres"/>
<group-map group-name="org.ofbiz"
datasource-name="localpostnew"/>
</delegator>
<delegator name="default-no-eca" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main"
entity-eca-enabled="false"
distributed-cache-clear-enabled="false">
<group-map group-name="org.ofbiz"
datasource-name="localpostgres"/>
<group-map group-name="org.ofbiz"
datasource-name="localpostnew"/>
</delegator>
<delegator name="test" entity-model-reader="main"
entity-group-reader="main" entity-eca-reader="main">
<group-map group-name="org.ofbiz"
datasource-name="localpostgres"/>
<group-map group-name="org.ofbiz"
datasource-name="localpostnew"/>
</delegator>
and
<datasource name="localpostgres"
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="seed-initial"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<inline-jdbc
jdbc-driver="org.postgresql.Driver"
jdbc-uri="jdbc:postgresql://localhost:5432/ofbiz"
jdbc-username="ofbiz"
jdbc-password="ofbiz"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"
time-between-eviction-runs-millis="600000"/>
<datasource name="localpostnew"
helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
schema-name="public"
field-type-name="postnew"
check-on-start="true"
add-missing-on-start="true"
use-fk-initially-deferred="false"
alias-view-columns="false"
join-style="ansi"
result-fetch-size="50"
use-binary-type-for-blob="true">
<read-data reader-name="seed"/>
<read-data reader-name="seed-initial"/>
<read-data reader-name="demo"/>
<read-data reader-name="ext"/>
<inline-jdbc
jdbc-driver="org.postgresql.Driver"
jdbc-uri="jdbc:postgresql://localhost:5432/ofbiz"
jdbc-username="ofbiz"
jdbc-password="ofbiz"
isolation-level="ReadCommitted"
pool-minsize="2"
pool-maxsize="250"
time-between-eviction-runs-millis="600000"/>
</datasource>
after this i run the coomand
ant run-install
it give the following error
[java] 2011-10-20 08:49:39,430 (main) [ ModelReader.java:389:INFO ]
FINISHED LOADING ENTITIES - ALL FILES; #Entities=849 #ViewEntities=267
#Fields=8870 #Relationships=2925 #AutoRelationships=2157
[java] 2011-10-20 08:49:39,603 (main) [ GenericDelegator.java:244:INFO ]
Doing entity definition check...
[java] 2011-10-20 08:49:39,614 (main) [ ModelEntityChecker.java:502:INFO ]
[initReservedWords] array length=1023
[java] Exception in thread "main" java.lang.NullPointerException
[java] at
org.ofbiz.entity.GenericDelegator.getEntityFieldType(GenericDelegator.java:548)
[java] at
org.ofbiz.entity.model.ModelEntityChecker.checkEntities(ModelEntityChecker.java:101)
[java] at
org.ofbiz.entity.GenericDelegator.<init>(GenericDelegator.java:245)
[java] at
org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:33)
[java] at
org.ofbiz.entity.DelegatorFactoryImpl.getInstance(DelegatorFactoryImpl.java:25)
[java] at
org.ofbiz.base.util.UtilObject.getObjectFromFactory(UtilObject.java:202)
[java] at
org.ofbiz.entity.DelegatorFactory.getDelegator(DelegatorFactory.java:47)
[java] at
org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:230)
[java] at
org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:100)
[java] at org.ofbiz.base.start.Start.startStartLoaders(Start.java:272)
[java] at org.ofbiz.base.start.Start.startServer(Start.java:322)
[java] at org.ofbiz.base.start.Start.start(Start.java:326)
[java] at org.ofbiz.base.start.Start.main(Start.java:411)
[java] 2011-10-20 08:49:39,828 (OFBiz_Shutdown_Hook) [
ContainerLoader.java:113:INFO ] Shutting down containers
[java] Java Result: 1
BUILD SUCCESSFUL
Total time: 38 seconds
I want to know some other change will be required for configuration .
Please help me.My two days had lost on this thigs.
Thanks
Dhiraj
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
