JAVA中的SQL Server查询通知 [英] SQL Server Query Notifications in JAVA
问题描述
我一直在网上搜索一段时间,但到目前为止还没有运气。是否可以在JAVA中实现这一点 http:// www .codeproject.com /用品/ 144344 /查询,使用-的SqlDependency和-SqlCach通知,?是否支持JDBC for SQL Server 2012?
I've been searching online for a while, but with no luck so far. Is it possible to implement this in JAVA http://www.codeproject.com/Articles/144344/Query-Notification-using-SqlDependency-and-SqlCach? Is it supported by JDBC for SQL Server 2012?
提前致谢!
推荐答案
你想听SQL服务器通知。您可以配置MSSql Server以通知代理。有 Apache ActiveMQ 作为开源解决方案。因此,您需要将MSSql Server连接到您的代理并使用JMS实现来监听&从代理检索java中的通知。
You want to listen to SQL server notifications. You can configure MSSql Server to notify a Broker. There is Apache ActiveMQ as an open source solution. So you need to connect MSSql Server to your broker and use JMS implementation to listen & retrieve notifications in java from the broker.
现在的问题是:是否可以将MSSql Server连接到任何代理?我会搜索并回复你。
The question now is : is it possible to connect MSSql Server to any broker ? I will search for that and comeback to you.
这篇关于JAVA中的SQL Server查询通知的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!