About cdc api and spatial datablade

Posted in 2014

JORGE INFANTE — Thu, 18 Dec 2014 10:16:11 — source: IIUG Forums & Mailing Lists

Hi, forum! I did working ok with cdc api on standard tables. But, I need to access with cdc api (cdc_startcapture) to tables with st_multilinestring columns or similar. When I did execute the cdc_startcapture, I'm receiving the message: CDC API 'cdc_startcapture' Failed at cdcapi.ec:1513. CDCAPI_RETVAL = -83718, CDC_ERRORCODE = UNKNOWN CDC Error Description is Unknown/Undocumented CDC API Error There is a method to do it? I know the st_multilinestring (and others spatial datatypes), is a special blob. If I can to access to binary change, I can work to decode it. What is the method to expand the knowledge of cdc_api to learn about non-standar data types? Thanks

↪ replying to JORGE INFANTE

JORGE INFANTE — Thu, 18 Dec 2014 10:38:27 — source: IIUG Forums & Mailing Lists

I did detect if I ommit the column with spatial data, the capture work. I'm thinking I can to include with a trigger the change of spatial data changing a standard column (varchar, smallint, etc), and, when I detect the change on this column I can to read by hand the spatial column. But, I don't know if this work in a very loaded database. I did see the spatial data contains a value <> zero on syscolumns.extended_id. Any ideas?

↪ replying to JORGE INFANTE

Madison Pruet — Thu, 18 Dec 2014 13:13:44 — source: IIUG Forums & Mailing Lists

For non-standard and large objects, you must use the data within the ro= w to get the non-standard/large object. Normally a primary key or unique in= dex would be used. From: "JORGE INFANTE" <joluinfante@gmail.com> To: ids@iiug.org Date: 12/18/2014 04:16 AM Subject: About cdc api and spatial datablade [34368] Sent by: ids-bounces@iiug.org Hi, forum! I did working ok with cdc api on standard tables. But, I need to access with cdc api (cdc_startcapture) to tables with st_multilinestring columns or similar. When I did execute the cdc_startcapture, I'm receiving the message: CDC API 'cdc_startcapture' Failed at cdcapi.ec:1513. CDCAPI_RETVAL =3D -83718, CDC_ERRORCODE =3D UNKNOWN CDC Error Description is Unknown/Undocumented CDC API Error There is a method to do it? I know the st_multilinestring (and others spatial datatypes), is a spec= ial blob. If I can to access to binary change, I can work to decode it. What is the method to expand the knowledge of cdc_api to learn about non-standar data types? Thanks ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

↪ replying to Madison Pruet

JORGE INFANTE — Thu, 18 Dec 2014 13:24:49 — source: IIUG Forums & Mailing Lists

Thanks. But, is it posible to detect the change without add a trigger to the table? I'm using cdc to avoid the unnecessary triggers in the tables. TIA jorge infante