*Hello Kapil,
*Update your code, you are having two entries of same name it must look like
<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="mysql"/>
<group-map group-name="org.ofbiz.olap"
datasource-name="localderbyolap"/>
<group-map group-name="org.ofbiz.tenant"
datasource-name="ocalderbytenant"/>
</delegator>
now create database and execute commands for "clean-all" and "run-install"
Its done now.
*
Yours,
Santosh Singh.*
On Sat, Oct 30, 2010 at 1:52 AM, BJ Freeman <[email protected]> wrote:
> just declare the datasource for you db.
>
>
>
> =========================
> BJ Freeman
> Strategic Power Office with Supplier Automation <
> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
> Specialtymarket.com <http://www.specialtymarket.com/>
> Systems Integrator-- Glad to Assist
>
> Chat Y! messenger: bjfr33man
>
>
> Kapil garg sent the following on 10/29/2010 1:01 PM:
>
>
>> Does that mean that I dont need to associate a datsource I create with a
>> delagator ? As in the datasource entry need not have a group associated
>> with it? or a delagator associated with it?
>>
>>
>> Kapil Garg
>>
>>
>>
>>
>>
>> Date: Fri, 29 Oct 2010 12:54:13 -0700
>>> From: [email protected]
>>> To: [email protected]
>>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema
>>>
>>> you did add more than the datasource
>>> you make it default delegator.
>>> this will cause the database to be updated with ofbiz schema
>>>
>>>
>>> =========================
>>>
>>> BJ Freeman
>>> Strategic Power Office with Supplier Automation<
>>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>>> Specialtymarket.com<http://www.specialtymarket.com/>
>>> Systems Integrator-- Glad to Assist
>>>
>>> Chat Y! messenger: bjfr33man
>>>
>>>
>>> Kapil garg sent the following on 10/29/2010 12:45 PM:
>>>
>>>>
>>>> Yes I created only the datasource by putting an entry in the
>>>> entity-engine.xml file. I did not create anything else and intentionally
>>>> put
>>>> it in default delegator. Still I am not ale to Induce. IT says unrecognised
>>>> datasource. I also get Null Pointer exception for localmysql datasource
>>>> whose entry is already in there. DO I need to do anything else?
>>>>
>>>> Do I need to do ant run-install, restart before hitting induce?
>>>>
>>>>
>>>> Kapil Garg
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> Date: Fri, 29 Oct 2010 12:41:59 -0700
>>>>> From: [email protected]
>>>>> To: [email protected]
>>>>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema
>>>>>
>>>>> only create a datasource. nothing else
>>>>> the mysql one you created you use the name.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> =========================
>>>>> BJ Freeman
>>>>> Strategic Power Office with Supplier Automation<
>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>>>>> Specialtymarket.com<http://www.specialtymarket.com/>
>>>>> Systems Integrator-- Glad to Assist
>>>>>
>>>>> Chat Y! messenger: bjfr33man
>>>>>
>>>>>
>>>>> Kapil garg sent the following on 10/29/2010 12:29 PM:
>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> I actually did use mysql as the datasource and tried using the link
>>>>>> below by putting in the datasource name in the text box and clicking on
>>>>>> Induce. For existing datasources name such as localmysql or localderby, I
>>>>>> got a NullPointer Exception.
>>>>>> For the one that I had an new entry witin the default delegator, I got
>>>>>> " unrecognized datasource" name sort of message. Do I need to create a
>>>>>> new
>>>>>> entity-group.xml file for the datasource mysql I created below even if
>>>>>> I am
>>>>>> using a default delagator similar to the data-source localmysql? Does it
>>>>>> need to be having group name org.ofbiz or something else within the
>>>>>> delegator tag?
>>>>>>
>>>>>>
>>>>>>
>>>>>> Date: Fri, 29 Oct 2010 12:23:37 -0700
>>>>>>> From: [email protected]
>>>>>>> To: [email protected]
>>>>>>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema
>>>>>>>
>>>>>>> use mysql as the datasource
>>>>>>> https://localhost:8443/webtools/control/view/ModelInduceFromDb
>>>>>>>
>>>>>>> =========================
>>>>>>> BJ Freeman
>>>>>>> Strategic Power Office with Supplier Automation<
>>>>>>> http://www.businessesnetwork.com/automation/viewforum.php?f=52>
>>>>>>> Specialtymarket.com<http://www.specialtymarket.com/>
>>>>>>> Systems Integrator-- Glad to Assist
>>>>>>>
>>>>>>> Chat Y! messenger: bjfr33man
>>>>>>>
>>>>>>>
>>>>>>> Kapil garg sent the following on 10/29/2010 12:09 PM:
>>>>>>>
>>>>>>>>
>>>>>>>> I am trying to create a entities within OFbiz out of an existing
>>>>>>>> schema in production. Not sure if this is the best way to create
>>>>>>>> entties out
>>>>>>>> of an existing schema. Suggestions are welcomed!!
>>>>>>>>
>>>>>>>> I tried to add a datasource tag in default delegator in
>>>>>>>> entity-engine.xml
>>>>>>>> Followed the instructions on
>>>>>>>>
>>>>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
>>>>>>>> Would like to know where I am going wrong. On restart, I realised
>>>>>>>> that ofbiz does not finish to the point that I can get webtools or even
>>>>>>>> login for ecommerce. IT has just stuck at soem point saying
>>>>>>>> ServiceDispatcher.java 584 INFO Sync service..
>>>>>>>> There is no exception or anything but OFbiz does not go further with
>>>>>>>> complete laoding. Anything I am doing wrong?
>>>>>>>> Being a default delegaotr, there was no special entity-group.xml
>>>>>>>> file in the ofbiz 9_04 code base. Hence I did not bother to create an
>>>>>>>> entity-group.xml file
>>>>>>>> My schema name is lronline, following are the entries I had in
>>>>>>>> entity-engine.xml
>>>>>>>> <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="localderby"/>
>>>>>>>> <group-map group-name="org.ofbiz.olap"
>>>>>>>> datasource-name="localderbyolap"/>
>>>>>>>> <group-map group-name="org.ofbiz"
>>>>>>>> datasource-name="mysql"/>
>>>>>>>> </delegator>
>>>>>>>>
>>>>>>>> <datasource name="mysql"
>>>>>>>>
>>>>>>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>>>>>>>> field-type-name="mysql"
>>>>>>>> check-on-start="true"
>>>>>>>> add-missing-on-start="true"
>>>>>>>> check-pks-on-start="false"
>>>>>>>> use-foreign-keys="true"
>>>>>>>> join-style="ansi-no-parenthesis"
>>>>>>>> alias-view-columns="false"
>>>>>>>> drop-fk-use-foreign-key-keyword="true"
>>>>>>>> table-type="InnoDB"
>>>>>>>> character-set="latin1"
>>>>>>>> collate="latin1_general_cs">
>>>>>>>> <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="com.mysql.jdbc.Driver"
>>>>>>>> jdbc-uri="jdbc:mysql://
>>>>>>>> 127.0.0.1/lronlineonedb?autoReconnect=true"
>>>>>>>> jdbc-username="root"
>>>>>>>> jdbc-password=""
>>>>>>>> isolation-level="ReadCommitted"
>>>>>>>> pool-minsize="2"
>>>>>>>> pool-maxsize="250"/>
>>>>>>>> <!--<jndi-jdbc jndi-server-name="localjndi"
>>>>>>>> jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/>
>>>>>>>> -->
>>>>>>>> </datasource>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Kapil Garg
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
>
