you should not assign the datasource as your default.
you should not change any of the code having to do with decelerators for
this step.
=========================
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
Santosh Singh sent the following on 10/29/2010 9:21 PM:
*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
