ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From BJ Freeman <bjf...@free-man.net>
Subject Re: Issues Creating Entities in Ofbiz from existing Schema
Date Sat, 30 Oct 2010 14:52:55 GMT
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: bjfree@free-man.net
>>> To: user@ofbiz.apache.org
>>> 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: bjfree@free-man.net
>>>>> To: user@ofbiz.apache.org
>>>>> 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: santoshs.indore@gmail.com
>>>>>>> To: user@ofbiz.apache.org
>>>>>>>
>>>>>>> *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<bjfree@free-man.net>
>>>>>>> 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: bjfree@free-man.net
>>>>>>>>>> To: user@ofbiz.apache.org
>>>>>>>>>> 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: bjfree@free-man.net
>>>>>>>>>>>> To: user@ofbiz.apache.org
>>>>>>>>>>>> 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: bjfree@free-man.net
>>>>>>>>>>>>>> To: user@ofbiz.apache.org
>>>>>>>>>>>>>> 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
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>
>>>
>>
>
>


Mime
View raw message