Stack Overflow
Stack Overflow

Questions tagged [query-notifications]

52 questions
25
votes
3 answers

I want my database (SQL) to notify or push updates to client application

I was developing this application on VB.net 2010 and SQL 2008. I wanted the clients to be notified for updates on the db, and the application used to check the db for changes in the specified minute using a timer, which really is not efficient. I…
mike.dev
  • 251
  • 1
  • 3
  • 4
13
votes
2 answers

Problem setting SUBSCRIBE QUERY NOTIFICATIONS

I'm currently implementing a cache mechanisem for our site. I want to use the SQL Cache dependancy feature. I am running the following command in management studio and it's not working. GRANT SUBSCRIBE QUERY NOTIFICATIONS TO…
Elad Lachmi
  • 10,406
  • 13
  • 71
  • 133
10
votes
2 answers

SqlDependency.OnChange firing but SqlDataReader is not returning with data

When I execute a query with a datetime column filter WHERE [Order].CreatedOn >= @CreatedOn using a SqlDependency, the change on data source fires the SqlDependency.OnChange event but the SqlDataReader associated with the SqlCommand doesn't return…
Khadim Ali
  • 2,548
  • 3
  • 33
  • 61
6
votes
1 answer

SqlDependency/Query notification - SQL Server reboot

I have an application running on a server which has a SqlDependency / query notification - monitoring changes on a table on a different server. It works fine until we reboot/restart SQL Server. When SQL Server is rebooted due to some maintenance and…
itsfighter
  • 167
  • 4
  • 15
5
votes
2 answers

Monitor data changes in SQL Azure

Is there a way to to get notifications when SQL Azure data changes or when new data is inserted? I would like to send notifications to an ASP.NET web application and push notifications to a Windows Phone. I know that the SqlDependency class and…
duncanportelli
  • 3,161
  • 8
  • 38
  • 59
5
votes
2 answers

On a very slow query, how do I indicate percentage of progress

I'm using ZEOS components to connect to an (ancient) MDB database. I'm doing a query that reads in lots of data to bridge into a different database. Is there a way to indicate progress as a percentage? procedure…
Johan
  • 74,508
  • 24
  • 191
  • 319
5
votes
1 answer

Is there a scalable alternative to SQL Server Query Notifications for raising events in an application from SQL Server?

SQL Server Query Notifications is a great tool, but it doesn't seem built to scale very well. Every application that wants/needs notifications has to keep an open connection to the database for the duration of the time it wants notifications…
richard
  • 12,263
  • 23
  • 95
  • 151
5
votes
1 answer

SQL Server Query Notifications in Java

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?
dodjavola
  • 177
  • 1
  • 12
5
votes
3 answers

Service Broker messages start to get hung up after about a day

I have an application that is using the Service Broker is SQL 2008. About once a day the database's performance starts take a noticeable hit and I have determined that this is because of the Service Broker. If I hard reset all broker connections…
lehn0058
  • 19,977
  • 15
  • 69
  • 109
5
votes
1 answer

How to push the data from database to application?

I want to push the data from database to application instead of application pull the data. I have installed ms sql server and apache tomcat server. I have my application in apache tomcat, here I made connection to database. Now I want database send…
niren
  • 2,693
  • 8
  • 34
  • 58
4
votes
0 answers

Does SQLAlchemy support Query Notifications of SQL Server?

Does SQLAlchemy support Query Notifications of SQL Server? If not, what is the closest one could get? I can imagine I could probably get SQLAlchemy directly submit Trasact SQL queries to set up the query notifications, but is there any more generic…
Mahdi
  • 1,778
  • 1
  • 21
  • 35
4
votes
2 answers

SqlDependency.OnChange is not firing with filter on datetime column

I am having issue using this SQL statement in SqlDependency. It simply not activating the SqlDependency.OnChange event, however returning the results as expected on SQL Server Query window. SELECT [Order].OrderId FROM [dbo].[Order] WHERE…
Khadim Ali
  • 2,548
  • 3
  • 33
  • 61
4
votes
1 answer

Run stored procedure on query notification without SqlDependency

Greeting everyone! In SqlDependency you can easy subscribe to data change using Query Notification mechanism. (or by setting odbc attributes) SqlDependency dependency = new SqlDependency( new SqlCommand("SELECT [ID], [Name] FROM…
alex7z
  • 113
  • 8
3
votes
0 answers

Oracle 11g CQN. Two different ROWID's for one record update

I have subscribed for Oracle CQN messages (with python cx_oracle) from one table on update. I am updating only one row: UPDATE my_table SET REMARKS = 'TEST2' WHERE my_table_primary_key = 123456; After commit I am receiving 2 messages for same…
Aleksandr Beliavski
  • 131
  • 1
  • 9
2
votes
0 answers

Oracle Database Continuous Query Notification in a multiple cluster environment

We want to implement Oracle Database Continuous Query Notification in a multiple cluster environment . But what we desire is that the DB change notification should be sent to only one instance of the application , because as of now it sending the…
Manas Pratim Chamuah
  • 1,527
  • 2
  • 15
  • 33
1
2 3 4