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
