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

Comments embedded
<argosy22_at_my-deja.com> wrote in message news:8ilg7j$n44$1_at_nnrp1.deja.com...
> 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.

This is nonsense, selects are not logged

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,

This is nonsense too. It is the insert that locks 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.

Please try at least to master the Oracle concepts before you start using it in an interdisciplinary context.
Most likely you are now creating an interdisciplinary mess. I have seen a few projects where pl/sql,c++,java, and visual basic have been employed, and the qualification mess applies to all of them.

Regards,

Sybrand Bakker, Oracle DBA Received on Mon Jun 19 2000 - 00:00:00 CDT