If you're using CMP then you'll likely have to depend on the container to
provide a mechanism for failing over to the second database (not sure if any
current vendors provide this capacity). If, on the other hand, you're using
BMP then you could simply set up two connection pools (one for each database
server.) In your persistence code, ask for a connection from the first pool.
If it fails, grab a connection from the second pool and try again.
I have no idea if there are any database side mechanisms for failing the
connection over to a secondary. Anyone on the list have any knowledge of
this sort of thing?
Rick MacConnell
CarrierPoint.com
-----Original Message-----
From: Ronseaux Cyril [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 04, 2000 1:39 PM
Subject: Accessing Replicated DataBase from EJBs.
I would like to have 2 Database (one replicates the other one, like Oracle
RDBMS allows to do), and I would like to have EJB entities (CMP) using those
DB. As each DB is on a separate computer with different IP, I fear it won't
be possible, as the EJB container will ask me ONE DB connection, which means
one IP...
Anyone tried such thing ?
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
