Thanks On 7/15/05, Duncan Mills <[EMAIL PROTECTED]> wrote: > 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] > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
