Stack Overflow
Stack Overflow

Questions tagged [cdc]

CDC may refer to the Communication Device Class (or USB CDC). Also may refer to Change Data Capture in Microsoft SQL Server, PostgreSQL, IBM (IDR), and Informix. Also may refer to Connected Device Configuration in Java ME.

CDC acronym may refer to: the Communication Device Class (or USB CDC); or to Change Data Capture in Microsoft SQL Server, PostgreSQL, IBM (IDR) or Informix databases; or to Connected Device Configuration in Java ME.

USB communications device class (or USB CDC) is a composite Universal Serial Bus device class. It provides a single device class, but there may be more than one interface implemented such as a custom control interface, data interface, audio, or mass storage related interfaces.

The communications device class is primarily used for modems. However it also supports ISDN and fax machines. It also supports plain telephony applications for performing regular voice calls.

More details on USB CDC in Wikipedia.

577 questions
61
votes
1 answer

Android USB host read from device

I'm trying to get some data out of a USB device connected to my Android phone that is on host mode. I'm able to send data to it, but reading fails. I've looked at several examples and tried all I could but I don't have any experience in USB…
Solenoid
  • 2,351
  • 5
  • 29
  • 48
48
votes
3 answers

Kafka Connect JDBC vs Debezium CDC

What are the differences between JDBC Connector and Debezium SQL Server CDC Connector (or any other relational database connector) and when should I choose one over another, searching for a solution to sync between two relational databases? Not…
Ofek Hod
  • 3,544
  • 2
  • 15
  • 26
23
votes
4 answers

An insufficient number of arguments were supplied for the procedure or function cdc.fn_cdc_get_all_changes_

Seemingly valid code for querying the latest tracked changes in the table Fields: DECLARE @Begin_LSN BINARY(10), @End_LSN BINARY(10) SET @Begin_LSN = sys.fn_cdc_get_min_lsn('Fields') SET @End_LSN = sys.fn_cdc_get_max_lsn() SELECT * FROM…
Alexander Galkin
  • 12,086
  • 12
  • 63
  • 115
18
votes
4 answers

What does LSN mean in SQL Server?

What is the meaning of Log Sequence Number? I know that it is of type binary and 10bytes long and it corresponds to the time the transaction happen in DB. But is this a high precision date-time value that is stored in some efficient binary format or…
Faiz
  • 5,331
  • 10
  • 45
  • 57
12
votes
2 answers

What is the difference between Oracle Streams and Change Data Capture?

There are several similar Oracle technologies - Oracle Streams, Oracle Change Data Capture and Database Change Notification. What are the differences between these? Are they related to Oracle Advanced Queueing?
Petr Sturc
11
votes
2 answers

What USB class does Serial COM Port use?

What is the name of the USB class which handles communication with USB devices which appear as COM ports in Window's device manager? For linux (at least for Fedora 17 and Ubuntu 12.04) these ports appear as ACM (Abstract Control Model,…
Daniel
  • 8,655
  • 5
  • 60
  • 87
11
votes
5 answers

How can I get an HDC object from a CDC object?

I have an object, dc, of type CDC and I'd like to get an HDC object. I read the MSDN documentation here, but don't really understand it. Can someone provide me with a brief example/explanation on how to do this?
samoz
  • 56,849
  • 55
  • 141
  • 195
10
votes
3 answers

How do I reconstruct a historical view?

I am currently exploring Change Data Capture as an option to store temporal databases. It is great because it stores only the deltas and seems like it may solve my problem. When I enabled CDC, a bunch of tables appeared under System Tables. When…
Legend
  • 113,822
  • 119
  • 272
  • 400
9
votes
6 answers

SQL Server 2008 Change Data Capture, who made the change?

I asked a question on SOF a week or so ago about auditing SQL data changes. The usual stuff about using triggers came up, there was also the mention of CDC in SQL Server 2008. I've been trying it out today and so far so good, the one thing I can't…
MrEdmundo
  • 5,105
  • 13
  • 46
  • 58
9
votes
3 answers

the best way to track data changes in oracle

as the title i am talking about, what's the best way to track data changes in oracle? i just want to know which row being updated/deleted/inserted? at first i think about the trigger, but i need to write more triggers on each table and then record…
GBK
  • 375
  • 2
  • 4
  • 11
9
votes
2 answers

How to activate Change Data Capture (CDC) on newly added columns of underlying table without disabling CDC

I have a requirement where I want to enable CDC on newly added columns of table, but I cannot disable CDC and enable it again. Is there any way I can achieve this? I found a solution where I can copy old CDC table values into a temp table, then…
Mohan
  • 95
  • 1
  • 1
  • 7
9
votes
1 answer

CDC is enabled, but cdc.dbo_CT table is not being populated

I have enabled CDC using the following steps: exec sys.sp_cdc_enable_db; exec sys.sp_cdc_enable_table @source_schema = N'dbo', @source_name = N'table_name', @role_name = N'CDC_Access', @supports_net_changes = 1; I can see that a CT table has been…
FooBar
  • 384
  • 2
  • 4
  • 14
9
votes
3 answers

Scalar function fn_cdc_get_min_lsn() constantly returns '0x00000000000000000000' for valid table names?

I have Change Data Capture (CDC) activated on my MS SQL 2008 database and use the following code to add a new tabel to the data capture: EXEC sys.sp_cdc_enable_table @source_schema ='ordering', @source_name ='Fields', @role_name =…
Alexander Galkin
  • 12,086
  • 12
  • 63
  • 115
8
votes
2 answers

What is the maximum speed of the STM32 USB CDC?

I'm using an STM32L151 to communicate with a PC using USB CDC. I used the STM32 HAL libraries to create my project. I found that the USB sends data in 1 ms intervals, and each time 64 bytes are being sent. So, is the maximum speed of the USB CDC 64…
Mohammad
  • 79
  • 1
  • 2
  • 3
8
votes
4 answers

How to work with WinUSB?

This is a follow-up to my previous question, Need to write driver for USB peripheral device? Background I'm working on designing a USB peripheral using an STM32 microcontroller (bare metal / no OS). The device will occasionally be connected to a…
cp.engr
  • 2,291
  • 4
  • 28
  • 42
1
2 3
…
38 39