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
