View Single Post
  #5 (permalink)  
Old July 9th, 2007, 13:50
chrisplough's Avatar
chrisplough chrisplough is offline
Site Moderator
 
Join Date: Jun 2006
Location: West Chester, PA
Posts: 864
Blog Entries: 7
Groans: 0
Groaned at 1 Time in 1 Post
Thanks: 55
Thanked 213 Times in 126 Posts
Rep Power: 10
chrisplough has a spectacular aura aboutchrisplough has a spectacular aura aboutchrisplough has a spectacular aura about
Send a message via AIM to chrisplough
Re: intg_queue Empty after OTM installation

Hello

I haven't seen OAQ exposed over the Internet before - usually the integration engine or ESB (Enterprise Service Bus) is exposed and then does the translation of documents into the OTM or OAQ format and posts internally to the OAQ queue -- so I'd recommend looking into your security and translation needs to ensure this model best fits.

That being said, usually OAQ connects in using the Oracle OCI or JDBC drivers. For instance, when configuring Mule (an open-source ESB) to connect to OAQ, you define your connection as follows:
Code:
<mule-configuration id="TestConfiguration" version="1.0"> 
<connector name="oracleJmsConnector" 
className="org.mule.providers.oracle.jms.OracleJmsConnector"> 
<properties> 
<property name="url" value="jdbc:oracle:oci:@myhost" /> 
<property name="username" value="scott" /> 
<property name="password" value="tiger" /> 
</properties> 
</connector> 
<transformers> 
<transformer name="StringToXMLMessage" 
className="org.mule.providers.oracle.jms.transformers.StringToXMLMessage" 
returnClass="oracle.jms.AdtMessage" /> 
<transformer name="XMLMessageToString" 
className="org.mule.providers.oracle.jms.transformers.XMLMessageToString" 
returnClass="java.lang.String" /> 
</transformers> 
<global-endpoints> 
<endpoint name="XmlQueue" address="oaq://XML_QUEUE" transformers="StringToXMLMessage" /> 
</global-endpoints> 
<model name="Test Model"> 
<mule-descriptor name="XML-Driven UMO" implementation="com.foo.MyUMO"> 
<inbound-router> 
<endpoint address="oaq://XML_QUEUE" transformers="XMLMessageToString"> 
<properties> 
<property name="payloadFactory" value="oracle.xdb.XMLTypeFactory" /> 
</properties> 
</endpoint> 
</inbound-router> 
</mule-descriptor> 
</model> 
</mule-configuration>
or - you can use a one-line connection string like:
Code:
oaq://XML_QUEUE?url=jdbc:oracle:oci:scott/tiger@myhost
The connection is then made using the default db port.

(as a side note, some additional information for anyone using Mule can be found here:
Oracle AQ Integration - Mule - Mule--Open Source ESB (Enterprise Service Bus) and Integration Platform)

Thanks!
--Chris
__________________
Chris Plough
MavenWire

www.MavenWire.com