You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Dhiraj Gupta (JIRA)" <ji...@apache.org> on 2011/09/23 07:32:26 UTC

[jira] [Created] (OFBIZ-4443) Configuration of postgresql with Ofbiz

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

        

[jira] [Closed] (OFBIZ-4443) Configuration of postgresql with Ofbiz

Posted by "Adrian Crum (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OFBIZ-4443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Adrian Crum closed OFBIZ-4443.
------------------------------

    Resolution: Not A Problem

Please stop using Jira to ask general questions. Ask your questions on the user mailing list instead.


> 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