0

I have an application using MySQL 5.5 db in a windows machine and a JVM running on a linux machine. I want to send JMS messages to the JVM from mysql when a value is inserted in one of the tables. I have seen that we can configure openjms with mysql but, how to we use it to call the JMS APIs ?

Patruni Srikanth
  • 741
  • 1
  • 7
  • 14

1 Answers1

1

Openjms requires a substrate for holding messages - this is where mysql comes into the picture - MySQL has no functionality to call java / create messages. Although it would in principe be possible to insert directly into the message queue using mysql this is a really bad idea.

You need to implement some code (most likely in Java) to capture the event and create a message.

symcbean
  • 47,736
  • 6
  • 59
  • 94
  • Is the case only with Openjms ? What about using ActiveMQ with Mysql? Even then how do we insert a message into the queue ? Using a procedure or something ? – Patruni Srikanth Aug 01 '12 at 08:03