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

[Brett Palmer]

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 <zenith_das at yahoo.com> 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
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users
>
>