Handling of External data - Error

[pankaj]

Hi All,

Please help us in Handling of External data in ofbiz.

I followed the steps given in below link

https://cwiki.apache.org/OFBIZ/handling-of-external-data.html

Consider System A (Windows Machine) and System B (Linux Machine).
Ofbiz 10.04 is running in System A and want to access MySql database present in System B.

As an example in System B there is table by name Account.
We get entry in entity model as entityName=Account when we follow the steps given in above link.
 
The issue is when we build it, an exception is raised as db.ACCOUNT does not exist.

And also I cannot change the table name in System B, as application at System B is making use of it.

I believe there is case sensitive issue.

Please suggest how to resolve the same.

With Regards,
Pankaj

[Pierre Smits]

Pankaj,

As opposed to having the rdbms on derby, where changes to the entity model
in OFBiz are effected immediately in the rdbms when you do a
rebuild/redeploy, this is not happening in rdbms' like MySQL and PostgreSQL.

There you have to make sure that the changes in the entity model are
created with their respective admin tooling beforehand.

Regards,

Pierre

2012/5/22 pankaj <[hidden email]>

> Hi All,
>
> Please help us in Handling of External data in ofbiz.
>
> I followed the steps given in below link
>
> https://cwiki.apache.org/OFBIZ/handling-of-external-data.html
>
> Consider System A (Windows Machine) and System B (Linux Machine).
> Ofbiz 10.04 is running in System A and want to access MySql database
> present
> in System B.
>
> As an example in System B there is table by name Account.
> We get entry in entity model as entityName=Account when we follow the steps
> given in above link.
>
> The issue is when we build it, an exception is raised as db.ACCOUNT does
> not
> exist.
>
> And also I cannot change the table name in System B, as application at
> System B is making use of it.
>
> I believe there is case sensitive issue.
>
> Please suggest how to resolve the same.
>
> With Regards,
> Pankaj
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Handling-of-External-data-Error-tp4632261.html
> Sent from the OFBiz - Dev mailing list archive at Nabble.com.
>

[Christian Geisert]

Pierre Smits schrieb:
> Pankaj,
>
> As opposed to having the rdbms on derby, where changes to the entity model
> in OFBiz are effected immediately in the rdbms when you do a
> rebuild/redeploy, this is not happening in rdbms' like MySQL and PostgreSQL.
>
> There you have to make sure that the changes in the entity model are
> created with their respective admin tooling beforehand.

Wrong, it's not a question of the databse but settings in
entityengine.xml (like check-on-start="true" add-missing-on-start="true")

Christian

[Pierre Smits]

Christian,

Your statement is either untrue or incomplete, as in entityengine.xml in
folder framework/entity/config shows the following for MySQL:

<datasource name="localmysql"

            helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"

            field-type-name="mysql"

            check-on-start="true"

            add-missing-on-start="true"
As it is for derby as the rdbms.

Pierre

2012/5/22 Christian Geisert <[hidden email]>

> Pierre Smits schrieb:
> > Pankaj,
> >
> > As opposed to having the rdbms on derby, where changes to the entity
> model
> > in OFBiz are effected immediately in the rdbms when you do a
> > rebuild/redeploy, this is not happening in rdbms' like MySQL and
> PostgreSQL.
> >
> > There you have to make sure that the changes in the entity model are
> > created with their respective admin tooling beforehand.
>
> Wrong, it's not a question of the databse but settings in
> entityengine.xml (like check-on-start="true" add-missing-on-start="true")
>
> Christian
>
>

[charalinga]

Dear All,


         How to create tables in small letters with MySql as database, using ofbiz

Any configuration in EntityEngine.xml



Charalinga