Jin,
I am glad that this should work for me :)
I am missing something ... as you can see MDB are new to me ...so few more questions..
Why would I need multiple consumers on each node for the same transaction?
How am I ensuring that only one message on one node is consumed?
How all nodes of the cluster are being notified if I use point to point?

robert



-----Original Message-----
From: Jin Chun [mailto:ByungChun@(protected)]
Sent: Wednesday, December 17, 2003 12:38 PM
To: J2EEPATTERNS-INTEREST@(protected)
Subject: Re: How to notify j2ee server from Oracle?


Hi Robert,
 I think you have an easy solution :-). You can have multiple consumers
on each jboss node receiving from the oracle AQ queues (point to point
queues
through their jms api's), this will ensure that only one consumer will
consume each message. Unless you have some other kind of requirement
(such as message ordering, resequencing, etc), this should work for you.

Jin

Jin Chun


Vice President: Sr. Systems Architect


State Street ? Global Link | www.statestreet.com | www.globallink.com


617.664.1695 | byungchun@(protected)


SCJA SCJP OCP-DBA








Confidentiality Notice: The information contained in the email is intended
for the confidential use of the above-named recipient(s). If the reader of
this message is not the intended recipient or person responsible for
delivering it to the intended recipient, you are hereby notified that you
have received this communication in error, and that any review,
dissemination, distribution, or copying of this communication is strictly
prohibited. If you have received this in error, please notify the sender
immediately and destroy this message.


|---------+------------------------------------>
|      |       "Augustyn, Robert non   |
|      |       Unisys"            |
|      |       <robert.augustyn@(protected)|
|      |       OM>               |
|      |       Sent by: An interest list|
|      |       for Sun Java Center J2EE |
|      |       Pattern Catalog       |
|      |       <J2EEPATTERNS-INTEREST@(protected)|
|      |       VA.SUN.COM>         |
|      |                        |
|      |                        |
|      |       12/17/2003 11:56 AM    |
|      |       Please respond to An   |
|      |       interest list for Sun   |
|      |       Java Center J2EE Pattern |
|      |       Catalog            |
|      |                        |
|---------+------------------------------------>
>---------------------------------------------------------------------------------------------------------------------------------------------|
|                                                                                              |
|     To:     J2EEPATTERNS-INTEREST@(protected)                                                            |
|     cc:                                                                                       |
|     Subject: Re: How to notify j2ee server from Oracle?                                                       |
>---------------------------------------------------------------------------------------------------------------------------------------------|




Jin,
It looks like you open more doors for me ... and more questions :)
If I use point to point this would not work too well with cluster since if
the node I am pointing to goes down I am out of luck. If I use
publish/subscribe then which node should consume? I would have to code
around it.
We are using 9iAS and Jboss.
Thanks a lot.
robert

-----Original Message-----
From: Jin Chun [mailto:ByungChun@(protected)]
Sent: Wednesday, December 17, 2003 11:39 AM
To: J2EEPATTERNS-INTEREST@(protected)
Subject: Re: How to notify j2ee server from Oracle?


Hi Robert,
 I guess it depends :-). Depending on your needs, you can either use
competing consumers over point to point queues, or
pub/sub broadcasting. If you are in a j2ee 1.3 environment, you can easily
set up MDB's to consume the event messages.
Otherwise, you will have to bootstrap the consumers on your own (Service
Activators either in a startup servlet or as a custom
service, etc.).

The easiest is probably using point to point queues to process the events,
then you will only consume the event once, depending
also on your needs for message expiration, etc. Which appserver and
available jms providers are you using?

Jin

Jin Chun


Vice President: Sr. Systems Architect


State Street ? Global Link | www.statestreet.com | www.globallink.com


617.664.1695 | byungchun@(protected)


SCJA SCJP OCP-DBA








Confidentiality Notice: The information contained in the email is intended
for the confidential use of the above-named recipient(s). If the reader of
this message is not the intended recipient or person responsible for
delivering it to the intended recipient, you are hereby notified that you
have received this communication in error, and that any review,
dissemination, distribution, or copying of this communication is strictly
prohibited. If you have received this in error, please notify the sender
immediately and destroy this message.


|---------+------------------------------------>
|      |       "Augustyn, Robert non   |
|      |       Unisys"            |
|      |       <robert.augustyn@(protected)|
|      |       OM>               |
|      |       Sent by: An interest list|
|      |       for Sun Java Center J2EE |
|      |       Pattern Catalog       |
|      |       <J2EEPATTERNS-INTEREST@(protected)|
|      |       VA.SUN.COM>         |
|      |                        |
|      |                        |
|      |       12/17/2003 11:19 AM    |
|      |       Please respond to An   |
|      |       interest list for Sun   |
|      |       Java Center J2EE Pattern |
|      |       Catalog            |
|      |                        |
|---------+------------------------------------>
>
---------------------------------------------------------------------------------------------------------------------------------------------|

|
|
|     To:     J2EEPATTERNS-INTEREST@(protected)
|
|     cc:
|
|     Subject: Re: How to notify j2ee server from Oracle?
|
>
---------------------------------------------------------------------------------------------------------------------------------------------|





Jin,
How does that work when I have a clustered j2ee server?
How would AQ comunicate with cluster? Would I need an load balancer between
the two?
Thanks.
robert


-----Original Message-----
From: Jin Chun [mailto:ByungChun@(protected)]
Sent: Wednesday, December 17, 2003 10:13 AM
To: J2EEPATTERNS-INTEREST@(protected)
Subject: Re: How to notify j2ee server from Oracle?


Hi Robert,
  not off hand :-), but there should be plenty of examples/docs off of
the oracle otn site.
We aren't doing that specific thing where I am currently, but we have had
multiple jms providers integrated
into the same application server. Following the terminology from the
enterprise integration patterns site
(which is really good IMHO), you can either send the event using push (the
data with the event) or pull
(just the notification, and grab the data yourself).

Jin

Jin Chun


Vice President: Sr. Systems Architect


State Street ? Global Link | www.statestreet.com | www.globallink.com


617.664.1695 | byungchun@(protected)


SCJA SCJP OCP-DBA








Confidentiality Notice: The information contained in the email is intended
for the confidential use of the above-named recipient(s). If the reader of
this message is not the intended recipient or person responsible for
delivering it to the intended recipient, you are hereby notified that you
have received this communication in error, and that any review,
dissemination, distribution, or copying of this communication is strictly
prohibited. If you have received this in error, please notify the sender
immediately and destroy this message.


|---------+------------------------------------>
|      |       "Augustyn, Robert non   |
|      |       Unisys"            |
|      |       <robert.augustyn@(protected)|
|      |       OM>               |
|      |       Sent by: An interest list|
|      |       for Sun Java Center J2EE |
|      |       Pattern Catalog       |
|      |       <J2EEPATTERNS-INTEREST@(protected)|
|      |       VA.SUN.COM>         |
|      |                        |
|      |                        |
|      |       12/17/2003 12:34 AM    |
|      |       Please respond to An   |
|      |       interest list for Sun   |
|      |       Java Center J2EE Pattern |
|      |       Catalog            |
|      |                        |
|---------+------------------------------------>
>
---------------------------------------------------------------------------------------------------------------------------------------------|


|
|
|     To:     J2EEPATTERNS-INTEREST@(protected)
|
|     cc:
|
|     Subject: Re: How to notify j2ee server from Oracle?
|
>
---------------------------------------------------------------------------------------------------------------------------------------------|






Jin,
Yes I think that this will work, this is what I was thinking of doing :)
Do you have any links of actual implementations of this?
Thanks.
robert

-----Original Message-----
From: Jin Chun [mailto:ByungChun@(protected)]
Sent: Tuesday, December 16, 2003 2:47 PM
To: J2EEPATTERNS-INTEREST@(protected)
Subject: Re: How to notify j2ee server from Oracle?


JMHO, but you could always put a trigger on the table, and have the trigger
send
a notification event message off to oracle aq, then have your appserver
code binding
to aq through their jms apis, take the notification as an event message and
do the rest
of the processing.

Jin

Jin Chun


Vice President: Sr. Systems Architect


State Street ? Global Link | www.statestreet.com | www.globallink.com


617.664.1695 | byungchun@(protected)


SCJA SCJP OCP-DBA








Confidentiality Notice: The information contained in the email is intended
for the confidential use of the above-named recipient(s). If the reader of
this message is not the intended recipient or person responsible for
delivering it to the intended recipient, you are hereby notified that you
have received this communication in error, and that any review,
dissemination, distribution, or copying of this communication is strictly
prohibited. If you have received this in error, please notify the sender
immediately and destroy this message.


|---------+------------------------------------>
|      |       "Augustyn, Robert non   |
|      |       Unisys"            |
|      |       <robert.augustyn@(protected)|
|      |       OM>               |
|      |       Sent by: An interest list|
|      |       for Sun Java Center J2EE |
|      |       Pattern Catalog       |
|      |       <J2EEPATTERNS-INTEREST@(protected)|
|      |       VA.SUN.COM>         |
|      |                        |
|      |                        |
|      |       12/16/2003 02:33 PM    |
|      |       Please respond to An   |
|      |       interest list for Sun   |
|      |       Java Center J2EE Pattern |
|      |       Catalog            |
|      |                        |
|---------+------------------------------------>
>
---------------------------------------------------------------------------------------------------------------------------------------------|



|
|
|     To:     J2EEPATTERNS-INTEREST@(protected)
|
|     cc:
|
|     Subject: How to notify j2ee server from Oracle?
|
>
---------------------------------------------------------------------------------------------------------------------------------------------|







Hi,
Is there a pattern standard way of accomplishing that?
I am looking to notify j2ee server that insert or update happened on a
perticular table in Oracle.
Thanks for your input.
robert

====================================================================
Companion Site: http://www.corej2eepatterns.com J2EE BluePrints:
http://java.sun.com/blueprints/corej2eepatterns List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
listserv@(protected)



====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
listserv@(protected)

====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
listserv@(protected)




====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
listserv@(protected)

====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
listserv@(protected)




====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
listserv@(protected)

====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to
listserv@(protected)




====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)

====================================================================
Companion Site: http://www.corej2eepatterns.com
J2EE BluePrints: http://java.sun.com/blueprints/corej2eepatterns
List Archive: http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing: email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)