Re: Aq and wls 8
- From: Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx>
- To: nigel.cl.thomas@xxxxxxxxxxxxxx
- Date: Mon, 8 Feb 2010 17:33:48 +0700
Nigel,
in the oracle aq there is queue buffer, I think the commit mechanism
differ than ordinary tables.... CMIIW
I think also more Efficient if mdb in during dequeue jms and insert to
table can be batched, BUt developer said it too many effort....
On Monday, February 8, 2010, Nigel Thomas
<nigel.cl.thomas@xxxxxxxxxxxxxx> wrote:
> Ujang
>
> On 8 February 2010 00:25, Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx> wrote:
>
>
> can we use aq, from bea juSt post messages to aq, and let plsql
> dequeue to batch insert to auditing table per 200 trx or per 5 sec
> whichever the first
>
>
> Sending a message on AQ involves posting changes into a queue table, which
> will be committed at the same time as the "real" transaction. That's not
> going to help any, is it? Plus, you will also need something running (a queue
> receiver, message driven bean or whatever) to dequeue the messages.
>
> As you say you are using BEA (WebLogic I presume) you could try using it's
> built-in WebLogic JMS to send the audit transactions - then set up message
> driven beans or worker jobs to dequeue the messages and post the audit trail
> in batches as you like. That way, the audit data only hits the Oracle
> database once, asynchronously to the real transactions.
>
> Of course, you will either need to send the audit messages as part of an XA
> transaction (and have the extra cost of 2-phase commit) or keep things simple
> (don't coordinate Oracle and JMS) and accept a small risk that a transaction
> may succeed but the audit message be lost (or vice versa) in the event of a
> system failure.
>
>
> HTH
>
> Nigel
>
>
>
>
--
thanks and regards
ujang | oracle dba | mysql dba
jakarta - indonesia
--
//www.freelists.org/webpage/oracle-l
Other related posts:
