Re: polling, triggers, java, Oracle, C++

HI everyone,

Thanks for your suggestions.

I knew that polling was a bad method. That's why I threw the question out to you all. How to do it with an interupt instead?

As I mentioned, we are using a specific product's (Novation) API, which acts on the database. The company actually wrote their own language like C to make it work! Most of their product's tables have NO primary keys! It is a very unstable product which consumes much of my time to administer it.

The java programmers used the polling method in a java applet to call this API every minute. If selects are not logged, then, there is a lot of other activity going on in this API's background. The API is not well documented.

I hope I can convince the programmers to look at Oracle or other methods more. So far, they are in love with their favorite tools and methods.

Ciao,

Argosy

In article <8ilg7j$n44$1_at_nnrp1.deja.com>,   argosy22_at_my-deja.com wrote:
> HI all,
>
> This is a good interdisciplined question involving
> Oracle 734, C++, and Java on Unix.
>
> Our developers are creating a new process for the web.
> They are using polling methods on the datbase.
>
> There are java processes that poll the database.
> Sometimes, they use the API of another product, which
> also polls the database. There are also c++ processes
> running on NT clients, which poll the database.
>
> The idea is that customers will use the web interface,
> and insert a record into the database. The polling
> then checks for new records.
>
> The problem is that we are running the database in archive
> mode. So every select is not only logged, the logs are
> later archived when they fill up. On our dev server last
> week, we got 240 megs of archive files in less than 2
> hours! I killed the processes.
>
> What I'm wondering is:
> - how can we use an interrupt method instead of a polling method?
>
> My initial thoughts (coming from an Oracle background) is
> to use an Oracle trigger. On INSERT ....
>
> One question was, how to call an executable java file (or even a
> ProC program) on the Unix side from the PLSQL in the trigger?
> Is it possible in 734? I don't think that it is. How about with 8?
>
> The developer's initial reaction was that the triggers lock
> the table, and other processes then have to wait for the first
> process to finish, and it didn't work well enough. Does this
> make sense?
>
> Another idea was to use the UTL_FILE package to output something
> to file. If we have to use polling, the java process could then
> poll for the file, and then engage.
>
> What about other tools from Oracle?
>
> Just some initial thoughts. Does anyone have any experience, or
> better ideas that they could share?
>
> Thanks a lot.
>
> Argosy
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jun 22 2000 - 00:00:00 CDT