INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Since using forums in my early days 10 years ago in CompuServe, one had to log back on and sometimes wait days for a response. Now I get a response e-mailed to me which I can click a link and go right back to exactly where My post was..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > EAI Distributed/Component Programming > IBM: MQSeries Forum

Building MQ -> Oracle adaptor ?

Read More Threads Like This One

Exie (Programmer)

6 Mar 06 7:08

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 (Programmer)

9 Mar 06 4:42

That's pretty much what you need to do.

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

jeevansharma (TechnicalUser)

25 Apr 06 13:40

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 (IS/IT--Management)

11 Jun 06 19:43

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 (Vendor)

12 Jun 06 14:24

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!

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To IBM: MQSeries