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 > >>> > >>> > >>> > >>> > >> > > >
