Re: How to connect with a Java JMS server from Oracle ?

Steve Howard wrote:
> Francesco wrote:
> > Solution 1 #
> > I have read about Oracle Advanced Queue system but does it require
> > Oracle Application Server ?
> > In our project we are using another middleware (Bea Weblogic), so we
> > need to use its jms server.
>
> No, you do not need the app serve for AQ.

I confirm, Streams AQ is shipped as part of the Oracle database; in addition there is a database-resident JMS layer on top of AQ.

>
> > Solution 2 #
> >
> > I thought I could write a plain Java class that sends/receives jms
> > messages and load it into Oracle, anyway Jms Api aren't part of the
> > standard JDK but they need to be added to Oracle classpath somehow
> > ....? (how ? )
> >
>
> If by "load it into Oracle" you mean inside the database JVM, you can
> use loadjava to load any third party java classes in to the Oracle JVM
> in the database. These are then accessible from java classes you write
> that are wrapped by PL/SQL objects. You can find doco on this at
> tahiti.oracle.com
>

I describe an example of messaging across tiers JMS over AQ triggering Message-Dirven Bean in the middle-tier in chapter 17 of my book (look for section 17.3.4). Even though this example uses Oracle AS OC4J as J2EE container, you can easily applu the example to any J2EE container.

Kuassi
http://db360.blogspot.com/2006/08/oracle-database-programming-using-java_01.html Received on Tue Nov 28 2006 - 11:09:50 CST