Message from SQL server to activemq.

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Message from SQL server to activemq.

niren
Working of Application Currently: I have written a trigger for a table in SQL server to trigger a external java application(which is in tomcat server) through http request whenever there is insertion in that table. I used xp_cmdshell inside trigger like

Exec xp_cmdshell 'sqlps -command "$http=New-Object system.Net.WebClient;
$http.uploadString(\"http://127.0.0.1:8080/MessageProducer\",\"param1=somevalue ^& param2=thriu\")"'

The java application is written to take the queryString and produce message in activemq. Finally I get message in activemq whenever there is insertion in SQL server.

Working of Application I want:  SQL server is capable of send message whenever there is update/insert in SQL server, so why should I use java application as intermediate between SQL server and activemq. Is there a way to send message from SQL server to activemq? How can I configure SQL server to push message to activemq?
Reply | Threaded
Open this post in threaded view
|

RE: Message from SQL server to activemq.

Thomas, Ishmael L
You use a Java application as an immediacy if your business logic requires CRUD (create, read, update, and delete) between the end user and one or more data sources (databases etc). Business logic is written and expressed as Java applications. If you're using a combination of JEE JMS (ActiveMQ) with JEE JTA/JPA, then most likely your Java application was developed as JAX-WS (SOAP) or JAX-RS (RESTful). Oracle through its Advanced Queuing and Streams features is an example of a SQL compliant RDBMS that uses a message exchange pattern (MEP) directly a with ActiveMQ without a Java application being an immediacy. I believe you can accomplish similar results as Oracle with the Microsoft SQLServer Service Integration (SSIS) feature for MS SQL Servers.  

From: niren [[hidden email]]
Sent: Monday, September 16, 2013 5:01 AM
To: [hidden email]
Subject: Message from SQL server to activemq.

*Working of Application Currently:* I have written a trigger for a table in
SQL server to trigger a external java application(which is in tomcat server)
through http request whenever there is insertion in that table. I used
xp_cmdshell inside trigger like

Exec xp_cmdshell 'sqlps -command "$http=New-Object system.Net.WebClient;
$http.uploadString(\"http://127.0.0.1:8080/MessageProducer\",\"param1=somevalue
^& param2=thriu\")"'

The java application is written to take the queryString and produce message
in activemq. Finally I get message in activemq whenever there is insertion
in SQL server.

*Working of Application I want: * SQL server is capable of send message
whenever there is update/insert in SQL server, so why should I use java
application as intermediate between SQL server and activemq. Is there a way
to send message from SQL server to activemq? How can I configure SQL server
to push message to activemq?



--
View this message in context: http://activemq.2283324.n4.nabble.com/Message-from-SQL-server-to-activemq-tp4671518.html
Sent from the ActiveMQ - User mailing list archive at Nabble.com.