[OFBiz] Users - access another database

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

[OFBiz] Users - access another database

Hao Jiang-4
Hello

For some reasons I want the ofbiz access another system's database, I
know I can do some coding in java class, but is it possible to do it in
system layer?

Thanks

Hao


 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - access another database

Andrew Sykes
Hao,

You can define entities that correspond to the database tables.

By default OFBiz does normalization on the table names and column names,
but you can over-ride this using the table-name and col-name attribures
in your entitymodel.xml.

Kind Regards
--
Andrew Sykes <[hidden email]>
Sykes Development Ltd

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - access another database

Hao Jiang-4
Thanks Andrew,

More precisely my situation is:

I have this ofbiz system using postgresql as its own DB, for some
reasons my boss wants this ofbiz system be able to connect to another
existing database, which in other place, and is a postgresql too.

I think maybe in entityengine.xml I can do something like this
<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="localpostgres"/>
<group-map group-name="org.ofbiz.odbc"
datasource-name="localpostgres2"/>
 </delegator>

At first group the datasource-name="localpostgres" with DB connection
settings for ofbiz DB, and the second datasource-name="localpostgres2"
is a copy of first one but set to connect another DB

Then since the second DB and all the tables already existed, and I don't
want to destroy them, do I need entitymodel.xml and entitygroup.xml to
define them? and how can I retrieve and insert data into that second DB?

Thanks

Hao
On Thu, 2005-10-27 at 12:40 +0100, Andrew Sykes wrote:
> Hao,
>
> You can define entities that correspond to the database tables.
>
> By default OFBiz does normalization on the table names and column names,
> but you can over-ride this using the table-name and col-name attribures
> in your entitymodel.xml.
>
> Kind Regards


 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users