| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| SQL Queries through MQ |
« View previous topic :: View next topic » |
| Author |
Message
|
| saxofun |
 Posted: Tue Jul 30, 2002 4:19 am Post subject: SQL Queries through MQ |
 |
|
Newbie
Joined: 30 Jul 2002
Posts: 5
|
Hello together
I want to send SQL-Queries (transaction safe) within
a MQ-Message to another server behind a firewall
because it's the only way to bypass the firewall.
Is there a mechanism in MQ (Version 5.1) to do this
on a clever way ?
thanks in advance 
Marc |
|
| Back to top |
|
 |
| mrlinux |
| Posted: Tue Jul 30, 2002 6:29 am Post subject: |
|
|
Grand Master
Joined: 14 Feb 2002
Posts: 1261
Location: Detroit,MI USA
|
You can pass what ever data you want in a message, you will need to
write apps to send/recv and do the queries.
_________________
Jeff
IBM Certified Developer MQSeries
IBM Certified Specialist MQSeries
IBM Certified Solutions Expert MQSeries |
|
| Back to top |
|
|
| bduncan |
| Posted: Tue Jul 30, 2002 7:51 am Post subject: |
|
|
Padawan
Joined: 11 Apr 2001
Posts: 1554
Location: Silicon Valley
|
Yes, in the past, we've simply sent the SQL query as the content of the message, and a very small program can get the message, form the SQL statement, execute it, and send the reply back via another message. Of course if you want to make it bulletproof, use XA, which means that you get the message off the queue, do the database update, and put the reply message, all within a single unit of work. And if there's any problem along the way, everything can be rolled back together.
_________________
Brandon Duncan
IBM Certified MQSeries Specialist
MQSeries.net forum moderator |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
