Stack Overflow
Stack Overflow

Questions tagged [query-notifications]

52 questions
1
vote
0 answers

How can I use Query notification and what are the requirement?

I want to use Query notification in our app to get the notification from database for updated data, so that app fire the query to get updated data instead of monitoring the database for every 5 sec. I am using ms sql server 2012 express edition, Is…
niren
  • 2,693
  • 8
  • 34
  • 58
1
vote
0 answers

Issue with CQN registration getting dropped implictly

Using custom C++ OCI wrappers, I can successful register a CQN C++ callback-based registration, but it appears that somehow the subscription is dropped right away, behind my back. I get no call back on simple DMLs. If I try to unregister that…
ddevienne
  • 1,802
  • 2
  • 17
  • 28
0
votes
0 answers

using existing registration for CQN

I did oracle CQN registration from Java application using JDBC driver with the following parameters Properties prop = new Properties(); prop.setProperty(OracleConnection.DCN_NOTIFY_ROWIDS, "true"); …
Bera
  • 673
  • 2
  • 12
  • 31
0
votes
1 answer

Python oracledb continous query notification not sending messages from database

I've been trying to use Continuous Query Notification (CQN) in python script to get notification from database about changes that were made to a specific table. I have followed tutorial from this link…
Filip
  • 3
  • 1
0
votes
1 answer

How can I broadcast SQL Event/Query Notification inside a WCF Service Application project hosted in IIS?

I need to implement a WCF Service Application project hosted in IIS, that can detect Database changes and broadcast to a WCF client (Windows Forms application). Inside WCF Service Application I see only an example of a WCF service. After searching…
Thanos
  • 23
  • 4
0
votes
0 answers

How to build correct query notification?

could someone please help me, I'm trying to set up alerts with the total amount of records for some tables that I want. In this example, I'm just trying to return COUNT as a result of one of the tables to say how many records don't have schedules…
sheetara
  • 1
0
votes
1 answer

Could Query Notiifications be used in C++ ? if yes then how, if not, may be there is an alternative

Could Query Notiifications be used in C++ ? if yes then how, if not, may be there is an alternative.. MSDN provides C# examples on how to use query notifications using sqlDependency, but I need to use such a feature for C++ applications. so what do…
Junior-Devil
  • 50
  • 7
0
votes
2 answers

Oracle (Continuous Query Notification) - way to get more data in a CQN notification?

We are using oracle CQN for change notifications for specific queries. This is working fine for all the inserts and updates. The problem is delete, On delete the notification is sent with ROWID amongst other details. We cannot use the ROWID to…
Vivek
  • 1,316
  • 1
  • 13
  • 23
0
votes
1 answer

Sql Dependency - Notification received before processing current request

I am currently using sql dependency notification to detect changes in a table and process them. I am having a problem where the notification gets called while its still in the middle of completing the first request which causes duplicate processing …
Vinod
  • 343
  • 1
  • 4
  • 14
0
votes
1 answer

How do I debug Query Notifications on SQL Server?

I am trying to get query notifications to work, but my application is not receiving any notifications. How do I debug Query Notifications? I am using the code availble here http://www.codeproject.com/KB/database/chatter.aspx. I can see that the…
Jan Aagaard
  • 10,940
  • 8
  • 45
  • 80
0
votes
1 answer

SQL Server Query Notifications - Needed permissions in Active Directory if we can't grant the database SA role to the user running the web site?

I've already configured the permissions in the DEV database for using query notifications in SQL Server 2005 with stored procedures. The issue is that it works with my user account when running the web site from my local machine, and it does not…
pabechevb
  • 106
  • 7
0
votes
0 answers

Service broker/Sqldependency errors

I am using service broker/Sqldependency to monitor table changes. Actual console application runs as windows service on a server different than the sql server. We stop and start the service everyday. Its working fine other than the two errors…
itsfighter
  • 167
  • 4
  • 15
0
votes
2 answers

Sqldependency Permission issue

I am getting the following error while staring the sqldependency Cannot find the specified user 'owner'. Cannot find the queue 'SqlQueryNotificationService-dfb11997-c69e-4e3b-a640-29cdf4c3e9fa', because it does not exist or you do not have…
itsfighter
  • 167
  • 4
  • 15
0
votes
1 answer

Error in Oracle.ManagedDataAccess.dll: Item has already been added. Key in dictionary: '4118' Key being added: '4118'?

I've been getting a strange error when debugging a web app using oracle query notification and ODP.Net The exception I'm getting is: Item has already been added. Key in dictionary: '4118' Key being added: '4118' The call stack is as follow: …
CWilson
  • 1
  • 1
0
votes
0 answers

SqlDependency.Stop() seems to not work as expected

I am developing an application with SQL Dependency feature. My problem is when I stop application (SqlDependency.Stop() method is executed) and I try to run stored procedure with ANSI_NULLS and QUOTED_IDENTIFIER set to OFF, I'm getting…
SzymonB
  • 133
  • 6
1 2
3
4