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]
