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]
