[OFBiz] Users - How to connect to oracle and PostgreSQL at a time

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

[OFBiz] Users - How to connect to oracle and PostgreSQL at a time

zenith Das
Is it possible to connect to oracle and PostgreSQL using thin driver at a time..
while fetching data from oracle and putting that to postgreSQL


Yahoo! FareChase - Search multiple travel sites in one click.
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: [OFBiz] Users - How to connect to oracle and PostgreSQL at a time

Brett
If your question is if ofbiz will let you connect to an oracle
database and postgres database simultaneously than the answer is yes.
You would configure the connections in the
entity/config/entityegine.xml file.  How you configure it depends on
what are trying to accomplish.  If are trying to identical entities
(tables) from one database to another then you probably want to create
two different entity delegators with their appropriate database
connection.  If the tables are not the same and don't have the same
table names then you could use a single entity delegator with two
different connection pools (configured in the group-map element of the
entity-config.xml file) and access the tables by entity name.

You would then have to program the data conversion from one database
to the other.


Brett

On 10/27/05, zenith Das <[hidden email]> wrote:

> Is it possible to connect to oracle and PostgreSQL using thin driver at a
> time..
> while fetching data from oracle and putting that to postgreSQL
>
>  ________________________________
>  Yahoo! FareChase - Search multiple travel sites in one click.
>
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
>
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users