Yes as Daniel mentioned you can access the objects in a remote database
using a database link. Select * from [EMAIL PROTECTED] kind of thing. The
two databases can also take part in a co-ordinated transaction if needs
be as well.
Duncan
Richard Reyes wrote:
Hi Duncan,
Will there be a way that the source DB access the target directly?
Because right now these DB's are accessed via web services Im thinking
if the source DB can directly connect to the target DB.
Also these procedural package, can they send notification emails?
On 7/14/05, Duncan Mills <[EMAIL PROTECTED]> wrote:
Indeed the Oracle Database itself has a DBMS_JOB procedural package
which acts just like Cron in the database - so that provides another way
to tackle the problem - On the other hand the Oracle database also has
a whole set of replication features which are designed for syncing data
between databases instances in realtime if necessary - have a serious
look at these built-in functions of the database infrastructure before
you build something new to do the same job.
Duncan
Jesse Alexander (KBSA 21) wrote:
Hi
(Warning: not an Oracle insider...)
If I remember correctly Oracle allows Java to used for PL/SQL-scripts.
Maybe you could have a Java-class that is called whenever you make an
update that needs to be "communicated". And then somehow make the update
in the second Oracle-db.
just my 2cents
Alexander
-----Original Message-----
From: Richard Reyes [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 14, 2005 3:53 AM
To: Struts Users Mailing List
Subject: [OT] Java as a Daemon
Hello Guys,
I need your suggestions. I have a task to create an application to
sync records between 2 Oracle 10g database. Not the whole records of
the database though, just the now and then transactional updates.
Access to the db's would be both via web services. I think I have an
option to do this like
- a simple java application executed via .sh file
- a java application running as a daemon on a unix box
But I really am not sure which better path I should take. Any
suggestions would be very much appreciated.
Thanks
Richard
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Regards
Duncan Mills
Senior Principal Product Manager
Oracle Application Development Tools
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
