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 [thirupat...@infratab.in] Sent: Monday, September 16, 2013 5:01 AM To: users@activemq.apache.org 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.
