Re: [OT] Java as a Daemon

2005-07-15 Thread Martin Gainty
ou 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 &g

Re: [OT] Java as a Daemon

2005-07-15 Thread Richard Reyes
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. >

Re: [OT] Java as a Daemon

2005-07-15 Thread Duncan Mills
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 th

Re: [OT] Java as a Daemon

2005-07-14 Thread Richard Reyes
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

Re: [OT] Java as a Daemon

2005-07-14 Thread Richard Reyes
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 Databa

Re: [OT] Java as a Daemon

2005-07-14 Thread Martin Gainty
pport 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 i

Re: [OT] Java as a Daemon

2005-07-14 Thread Daniel Henrique Ferreira e Silva
Struts Users Mailing List > 07/13/2005 11:49 , Richard > PMReyes <[EMAIL PROTECTED]> > cc > > Please respond to

Re: [OT] Java as a Daemon

2005-07-14 Thread David Whipple
quot;Struts Users Re: [OT] Java as a Daemon Mailing List" <[EMAIL PROTECTED]

Re: [OT] Java as a Daemon

2005-07-14 Thread Duncan Mills
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 da

RE: [OT] Java as a Daemon

2005-07-14 Thread Jesse Alexander (KBSA 21)
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 Al

Re: [OT] Java as a Daemon

2005-07-14 Thread Richard Reyes
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

Re: [OT] Java as a Daemon

2005-07-14 Thread Leon Rosenberg
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

Re: [OT] Java as a Daemon

2005-07-13 Thread Larry Meadors
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* alw

Re: [OT] Java as a Daemon

2005-07-13 Thread Richard Reyes
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]> wrot

RE: [OT] Java as a Daemon

2005-07-13 Thread David G. Friedman
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