Ofcourse we need to add mysql drivers. My question was is it a special one for ofbiz?
Kapil Garg > Date: Sat, 30 Oct 2010 07:52:55 -0700 > From: [email protected] > To: [email protected] > Subject: Re: Issues Creating Entities in Ofbiz from existing Schema > > sorry yes you need to load the mysql drivers into the > framework/entity\lib\jdbc > > ========================= > 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 > > > BJ Freeman sent the following on 10/30/2010 7:47 AM: > > OTTB means you have not modified anything on which ever version you use. > > by default the DB that will be created is derby. > > for your experimentation, for inducing the entities this sufficient and > > less confusing. > > > > once you have done the > > ./ant run-install > > then will have demo data in the derby DB and will not get any start up > > errors. > > > > add your data source you created "mysql". > > then go to the induce link and it should work, using > > mysql as the data source > > > > ========================= > > 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/30/2010 7:32 AM: > >> > >> When your say OTTB ( as in Out of the box) are you referring to any > >> trunk version number for ofbiz? > >> Also in your instruction below are you saying to add the datasource > >> after running ant run-install? I believe that run-install would run > >> DBUtil code so wont be need to declare datasources before running ant > >> run-install? > >> > >> Regardless I am not able to connect to the DB. IS there a special jar > >> file for mysql driver for ofbiz? > >> > >> > >> Kapil Garg > >> > >> > >> > >> > >> > >>> Date: Sat, 30 Oct 2010 07:27:57 -0700 > >>> From: [email protected] > >>> To: [email protected] > >>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema > >>> > >>> all my instructions are based on > >>> 1) OTTB ofbiz > >>> 2) ./ant run-install was completed successfully > >>> > >>> then you add your datasource. > >>> > >>> ========================= > >>> 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/30/2010 6:56 AM: > >>>> > >>>> I already tried that it gives Null pointer exception. I created an > >>>> empty database Ofbiz with ofbiz/ofbiz as credentials and used the > >>>> normal localmysql that came in original file, it still gives > >>>> NullPointer Exception. For some reason at startup the DBUTIL is not > >>>> getting the connnectionURL paparmeter read from the > >>>> entity-engine-xml file and hence it gives NullPounter on this paramter. > >>>> > >>>> Is this somehting that is fixed in other release. I tried this on > >>>> 10.4 as well and got same NullpointerException and in debug the > >>>> connection URL is not getting read from the xml file. What else > >>>> could be wrong? Any other suggestions. I am willing to try > >>>> everything to get this working. Worst Case I would be hardcoding but > >>>> then it would create problem with localderby as it needs to be read. > >>>> Can localderby be copied to mysql? > >>>> > >>>> > >>>> Kapil Garg > >>>> > >>>> > >>>> > >>>> > >>>> > >>>>> Date: Sat, 30 Oct 2010 06:27:18 -0700 > >>>>> From: [email protected] > >>>>> To: [email protected] > >>>>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema > >>>>> > >>>>> I would suggest you return the entityengine.xml back to its original > >>>>> configuration, add your mysql datasource as the only modification > >>>>> to the > >>>>> file and try it again. > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> ========================= > >>>>> 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/30/2010 4:30 AM: > >>>>> > >>>>>> > >>>>>> Hello Santosh > >>>>>> The IllegalArgument exception went away after I put in a tenatant > >>>>>> group name for localderby as show below. However Now I am getting > >>>>>> Null Pointer Exception > >>>>>> GenericDAO.induceModelFromDB() calls > >>>>>> DatabaseUtil.induceModelFromDB(). In > >>>>>> DatabaseUtil.induceModelFromDB() method, there is a line of code > >>>>>> this.getTableNames() which is comming out tobe null? ANy idea > >>>>>> why?Also the DBUTIL class is getting NULL value for connectionURL > >>>>>> paramter and the dirveName parameter is also coming out to be null. > >>>>>> Why is that? Hence th Nullpointer. I would imagine that this is > >>>>>> read from the helperName=localMysql which is howing correctly in > >>>>>> debug variable list. AM I missing anything here? > >>>>>> > >>>>>> Coudl you advise further as you seem to know about this? > >>>>>> > >>>>>> > >>>>>> Kapil Garg > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>>> Date: Sat, 30 Oct 2010 09:51:54 +0530 > >>>>>>> Subject: Re: Issues Creating Entities in Ofbiz from existing Schema > >>>>>>> From: [email protected] > >>>>>>> To: [email protected] > >>>>>>> > >>>>>>> *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 > >>>>>>>>>>>>>>> > >>>>>>>>>>>>>>> > >>>>>>>>>>>>>>> > >>>>>>>>>>>>>>> > >>>>>>>>>>>>>>> > >>>>>>>>>>>>>> > >>>>>>>>>>>>>> > >>>>>>>>>>>>> > >>>>>>>>>>>> > >>>>>>>>>>>> > >>>>>>>>>>> > >>>>>>>>>> > >>>>>>>>>> > >>>>>>>>> > >>>>>>>> > >>>>>>>> > >>>>>> > >>>> > >>> > >> > > > > >
