Re: [OT] Java as a Daemon
Good Afternoon Richard Agreed - a cron oracle dbms_job task would definitely fit the bill 10g is promoting their new Scheduler program which replaced dbms_job task..take a look at http://www.databasejournal.com/features/oracle/article.php/3413371 Sidebar : You could also look at Ant which has also added the ability to run SQL scripts take a look at http://ant.apache.org/manual/ In any case Let me know how you make out, Martin- - Original Message - From: "Richard Reyes" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" Sent: Thursday, July 14, 2005 10:00 PM Subject: Re: [OT] Java as a Daemon Hi Guys, Thanks for all the input. I'll suggest the oracle dbms_job approach seems reasonable. My last option would be to create a cron job. Richard On 7/14/05, Martin Gainty <[EMAIL PROTECTED]> wrote: Jesse For specific packages I would look at dbms_streams_tablespace_adm I would look at Oracle's Moving Data Faster/Pulling Tablespaces article available at http://www.oracle.com/technology/oramag/oracle/04-sep/o54data.html And of course consult the folks at Oracle if you have a support contract! In any case let us know how you make out, Maritn- Original Message - From: "Duncan Mills" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" Sent: Thursday, July 14, 2005 4:41 AM Subject: Re: [OT] Java as a Daemon > 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]
Re: [OT] Java as a Daemon
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]
Re: [OT] Java as a Daemon
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]
Re: [OT] Java as a Daemon
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]
Re: [OT] Java as a Daemon
Hi Guys, Thanks for all the input. I'll suggest the oracle dbms_job approach seems reasonable. My last option would be to create a cron job. Richard On 7/14/05, Martin Gainty <[EMAIL PROTECTED]> wrote: > Jesse > > For specific packages I would look at dbms_streams_tablespace_adm > I would look at Oracle's Moving Data Faster/Pulling Tablespaces article > available at > http://www.oracle.com/technology/oramag/oracle/04-sep/o54data.html > And of course consult the folks at Oracle if you have a support contract! > > In any case let us know how you make out, > Maritn- > Original Message - > From: "Duncan Mills" <[EMAIL PROTECTED]> > To: "Struts Users Mailing List" > Sent: Thursday, July 14, 2005 4:41 AM > Subject: Re: [OT] Java as a Daemon > > > > 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]
Re: [OT] Java as a Daemon
Jesse For specific packages I would look at dbms_streams_tablespace_adm I would look at Oracle's Moving Data Faster/Pulling Tablespaces article available at http://www.oracle.com/technology/oramag/oracle/04-sep/o54data.html And of course consult the folks at Oracle if you have a support contract! In any case let us know how you make out, Maritn- Original Message - From: "Duncan Mills" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" Sent: Thursday, July 14, 2005 4:41 AM Subject: Re: [OT] Java as a Daemon 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]
Re: [OT] Java as a Daemon
Hi, Just adding my 2 cents. Go with Duncan because: 1) He works for Oracle, so he _must_ know what he's saying :) 2) His approach works nice here in my job. Oracle's replication features work good. If you are a bad luck guy that doesn't have a DBA in your team (yeah, it is possible) you can try using a db link so your code doesn't need to make two database connections. Let Oracle handle the connection to the other database :) HTH, Daniel Silva. On 7/14/05, David Whipple <[EMAIL PROTECTED]> wrote: > We use the cron approach as well. Using a simple mechanism and having > separate JVMs has proven very good for maintenance, etc. > > Dave > > > > > Larry Meadors > <[EMAIL PROTECTED] > ail.com> To >Struts Users Mailing List > 07/13/2005 11:49 , Richard > PMReyes <[EMAIL PROTECTED]> > cc > > Please respond to Subject >"Struts Users Re: [OT] Java as a Daemon >Mailing List" > <[EMAIL PROTECTED] > he.org> > > > > > > > > I would probably go the route of the .sh file. > > At the risk of starting a big flame war, cron is solid as a rock, and > all of the memory used by your app will be freed up when the JVM > exits. Why make it more complex by adding quartz or tomcat to the mix > if you do not have to. > > Simple is *almost* always better. > > Larry > > > On 7/13/05, Richard Reyes <[EMAIL PROTECTED]> wrote: > > 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] > > > > - > 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]
Re: [OT] Java as a Daemon
We use the cron approach as well. Using a simple mechanism and having separate JVMs has proven very good for maintenance, etc. Dave Larry Meadors <[EMAIL PROTECTED] ail.com> To Struts Users Mailing List 07/13/2005 11:49 , Richard PMReyes <[EMAIL PROTECTED]> cc Please respond to Subject "Struts Users Re: [OT] Java as a Daemon Mailing List" <[EMAIL PROTECTED] he.org> I would probably go the route of the .sh file. At the risk of starting a big flame war, cron is solid as a rock, and all of the memory used by your app will be freed up when the JVM exits. Why make it more complex by adding quartz or tomcat to the mix if you do not have to. Simple is *almost* always better. Larry On 7/13/05, Richard Reyes <[EMAIL PROTECTED]> wrote: > 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] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] Java as a Daemon
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]
RE: [OT] Java as a Daemon
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]
Re: [OT] Java as a Daemon
thanks On 7/14/05, Leon Rosenberg <[EMAIL PROTECTED]> wrote: > I'm with Larry. Cron rocks. The only problem you should have in mind: if > your job needs more then the time between the jobs, you've lost. > We had actually this problem, and it killed the db, because (2 years > after initially written) the script lasted more then 24 hours, and after > a week 5 instances of it runned, blocking each other and producing a > load of 10 on the machine. > > So simply add a check "am I already running" to your code, and it will > be fine :-) > > regards > Leon > > On Wed, 2005-07-13 at 21:49 -0600, Larry Meadors wrote: > > I would probably go the route of the .sh file. > > > > At the risk of starting a big flame war, cron is solid as a rock, and > > all of the memory used by your app will be freed up when the JVM > > exits. Why make it more complex by adding quartz or tomcat to the mix > > if you do not have to. > > > > Simple is *almost* always better. > > > > Larry > > > > > > On 7/13/05, Richard Reyes <[EMAIL PROTECTED]> wrote: > > > 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] > > > > > > > > - > 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]
Re: [OT] Java as a Daemon
I'm with Larry. Cron rocks. The only problem you should have in mind: if your job needs more then the time between the jobs, you've lost. We had actually this problem, and it killed the db, because (2 years after initially written) the script lasted more then 24 hours, and after a week 5 instances of it runned, blocking each other and producing a load of 10 on the machine. So simply add a check "am I already running" to your code, and it will be fine :-) regards Leon On Wed, 2005-07-13 at 21:49 -0600, Larry Meadors wrote: > I would probably go the route of the .sh file. > > At the risk of starting a big flame war, cron is solid as a rock, and > all of the memory used by your app will be freed up when the JVM > exits. Why make it more complex by adding quartz or tomcat to the mix > if you do not have to. > > Simple is *almost* always better. > > Larry > > > On 7/13/05, Richard Reyes <[EMAIL PROTECTED]> wrote: > > 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] > > - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [OT] Java as a Daemon
I would probably go the route of the .sh file. At the risk of starting a big flame war, cron is solid as a rock, and all of the memory used by your app will be freed up when the JVM exits. Why make it more complex by adding quartz or tomcat to the mix if you do not have to. Simple is *almost* always better. Larry On 7/13/05, Richard Reyes <[EMAIL PROTECTED]> wrote: > 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]
Re: [OT] Java as a Daemon
Hi David, We are using Netsuit business suite, I am not sure If I can update any DAO. But I think I can run it on the same or separate webserver ( Tomcat ?? ). I think Quartz can be helpful, Ill check if its okay from the top. Thanks Richard On 7/14/05, David G. Friedman <[EMAIL PROTECTED]> wrote: > Richard, > > Can you run it in your webapp container? You could then update an object in > application scope with the id's of what records have changed. You could > even change your DAO to perform that step for you. Then you could have the > quartz scheduler running to periodically update things without needing to > run any additional code, crontab, atq, etc. All of this from inside your > Struts webapp. FYI, Quartz is at http://www.opensymphony.com/quartz and no, > I have no affiliation with them. LOL. > > Regards, > David > > -Original Message- > From: Richard Reyes > 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]
RE: [OT] Java as a Daemon
Richard, Can you run it in your webapp container? You could then update an object in application scope with the id's of what records have changed. You could even change your DAO to perform that step for you. Then you could have the quartz scheduler running to periodically update things without needing to run any additional code, crontab, atq, etc. All of this from inside your Struts webapp. FYI, Quartz is at http://www.opensymphony.com/quartz and no, I have no affiliation with them. LOL. Regards, David -Original Message- From: Richard Reyes 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]
[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]