Building MQ -> Oracle adaptor ?

[Exie]

Hi,

At work, I've been asked to build a J2EE Application. The app. part is fine, and we would like to use MQ to source data out of our Datawarehouse (Oracle).

Unfortunately, we dont have the Oracle AS (Application Server) which I think comes with an adaptor to do this, so it looks like I will have to write my own MQ adaptor to connect to Oracle.

Any tips/ideas where to start ?

So far, my best thinking is like so:

1. Pass an XML message from the app to my adaptor
(Specify a table/view, criteria and columns or something)
2. Unpack that,
3. Execute a query against the database (using JDBC ?)
4. Package the result set in a flat XML name/value structure
5. Pass XML back through MQ to my app.

Does that sound do-able ? Any better ideas about how to handle this on a $0 budget ?

 

[pmeekin]

That's pretty much what you need to do.

Presumably if you're using J2EE you'll be using the MQ JMS classes?

 

[jeevansharma]

Hey guys,

I am new to this forum. I like to ask a question about configuration of MQ v6. for remote administration and for veiwing queues.

i installed but I could not configured the mqexplorer. When I run getting started and created queue manager, but I could not run this queue manager. I also tried to add remote queue manager, but I could not do that. I can add but does not connect.

I read the document, which is not very clear. It talks about an special account. What is this ? Do I need to be in that group? Do I need to be local mqm group? what else?

Please suggest me

 

[aixmurderer]

Have a look at the MQ support pacs site, this may do the trick for you:

http://www-1.ibm.com/support/docview.wss?rs=171&uid=swg24000654&loc=en_US&cs=utf-8&lang=en

IBM Certified Confused - MQSeries
IBM Certified Flabbergasted - AIX 5 pSeries System Administration
MS Certified Windblows Rebooter

 

[BocaBurger]

Depending on what you need to do, you might want to look at IBM WebSphere TX. Check with your rep for eval copy.



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!