Probably the most appropriate way to communicate back would be HTTP, but you would have to be careful not to induce loops, and make sure it's not brittle.
Jade
On 9/12/06, Tom Jackson <[EMAIL PROTECTED]> wrote:
I wrote an OpenACS module, which worked on Oracle and pg called cronjob.
Once per minute it queried a table, ran the sql (if any) and then ran the tcl
script (if any), and sent an email report (if there was an email address).
Btw, getting a database handle doesn't require opening a connection, database
connections are already established. Getting the handle is fast, releasing
them should be automatic.
But if the task is really a database task, why not run it inside the database,
but I'm not sure how schedule database tasks in pg. Oracle 10g I believe has
a nice facility for scheduling tasks, and obviously triggers can fire so you
don't have to poll anything.
tom jackson
On Tuesday 12 September 2006 08:41, Titi Ala'ilima wrote:
> Hi all,
>
> What I'd love would be a way to have an nsd thread listen for a certain
> db event and fire Tcl as a result. Anyone know how to accomplish this
> other than polling? I'd hate to have to grab a handle, query, and then
> release a handle. In a pinch I know I could have the db make an HTTP
> request. But ideally there would be a persistent connection open and
> the db (in this case Oracle, but I'd like to figure out a way that would
> work with postgres, too) would report when Tcl needs to be fired. Seems
> like nsproxy may be useful for this.
>
> -Titi
>
>
>
>
> --
> AOLserver - http://www.aolserver.com/
>
> To Remove yourself from this list, simply send an email to
> <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the
> email message. You can leave the Subject: field of your email blank.
--
AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to < [EMAIL PROTECTED]> with the
body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
--
Jade Rubick
Senior Developer
United eWay Volunteer Solutions
[EMAIL PROTECTED]
tel (503)285-4963
fax (707)671-1333
www.UNITEDeWAY.org
-- AOLserver - http://www.aolserver.com/
To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.