Read value from a complex XML structure using SQL Server -

-

i trying read value in sql server query out of xml structure column of datatype ntext.

this xml structure want extract value read!!!:

<printerprocessdef xmlns:xsi="http://www.w3.org/2001/xmlschema-instance" xmlns:xsd="http://www.w3.org/2001/xmlschema" xmlns="http://dev.docuware.com/settings/workflow/processdef" id="3e62848d-040e-4f4c-a893-ed85a7b2878a" type="printerprocess" configid="c43792ed-1934-454b-a40f-5f4dfec933b0" enabled="true" pcid="2837f136-028d-47ed-abdc-4103bedce1d2" timestamp="2016-08-08t09:44:38.532415">   <configs>     <config xmlns:q1="http://dev.docuware.com/settings/workflow/processconfig" xsi:type="q1:printerprocessconfig" id="c43792ed-1934-454b-a40f-5f4dfec933b0" />     <config xmlns:q2="http://dev.docuware.com/settings/workflow/processconfig" xsi:type="q2:recognizeactconfig" id="b89a6fc2-5573-4034-978a-752c6c0de4cf">       <q2:header defaultrecognitiontechnology="ocr" defaultocrsettingsguid="00000000-0000-0000-0000-000000000000">       </q2:header>       <q2:body>         <q2:anchordefs />         <q2:zonedefs />         <q2:tabledefs />         <q2:facelayouts>         </q2:facelayouts>         <q2:facesamples>         </q2:facesamples>         <q2:sampledocument>           <metadata xmlns="http://dev.docuware.com/settings/common" filename="test - editor" mimetype="application/pdf" pagecount="1" sourceappname="c:\windows\system32\notepad.exe" documenttitle="test - editor" pdfcreator="docuware printer" />           <data xmlns="http://dev.docuware.com/settings/common">!!!value read!!!</data>         </q2:sampledocument>       </q2:body>       <q2:allpagesrequired>false</q2:allpagesrequired>     </config>     <config xmlns:q3="http://dev.docuware.com/settings/workflow/processconfig" xsi:type="q3:recognizeactconfig" id="db5b195d-79e4-4804-bd38-f4fc7e8d5a8d">     </config>     <config xmlns:q4="http://dev.docuware.com/settings/workflow/processconfig" xsi:type="q4:addoverlayactconfig" id="023aab08-c6e3-4f08-9d26-0175d1564ef2">       <q4:overlays />     </config>     <config xmlns:q5="http://dev.docuware.com/settings/workflow/processconfig" xsi:type="q5:printactconfig" id="4a4ec06a-8652-4777-84d2-53cb862b3328">     </config>     <config xmlns:q6="http://dev.docuware.com/settings/workflow/processconfig" xsi:type="q6:signactconfig" id="8c030961-e68e-4c2f-83f1-cac20f51d4d6">     </config>     <config xmlns:q7="http://dev.docuware.com/settings/workflow/processconfig" xsi:type="q7:emailactconfig" id="5dbd144b-5c33-407a-b638-e062f9045fb4">     </config>     <config xmlns:q8="http://dev.docuware.com/settings/workflow/processconfig" xsi:type="q8:indexactconfig" id="f2a70e07-d76e-4e82-9313-7c665df4c311">     </config>     <config xmlns:q10="http://dev.docuware.com/settings/workflow/processconfig" xsi:type="q10:storeactconfig" id="ff8aec66-608e-4dde-a4b6-de65ada39bb0">     </config>     <config xmlns:q11="http://dev.docuware.com/settings/workflow/processconfig" xsi:type="q11:notifyuseractconfig" id="7ffb0437-6b8c-4f5f-8f40-434f4a6d609a" />   </configs>   <activities>   </activities> </printerprocessdef>

and sql query used:

select      cast([table].[settings] xml)         .value('declare namespace q2="http://dev.docuware.com/settings/workflow/processconfig";         (/printerprocessdef/configs/config[@xsi:type="q2:recognizeactconfig"]/q2:body/q2:sampledocument/data/text())[1]',         'varchar(max)')      [db].[dbo].[table]

all returned null , not hoped-for value read!!!.

what should query working?

i tried different versions without namespace declaration , others null.

all elements have namespaces defined. need declare , specify them according definitions

select cast([table].[settings] xml).value(    'declare namespace top="http://dev.docuware.com/settings/workflow/processdef";     declare namespace q2="http://dev.docuware.com/settings/workflow/processconfig";     declare namespace nd="http://dev.docuware.com/settings/common";     (/top:printerprocessdef/top:configs/top:config[@xsi:type="q2:recognizeactconfig"]/q2:body/q2:sampledocument/nd:data)[1]',           'varchar(max)') [db].[dbo].[table]

Comments

Post a Comment

Popular posts from this blog

Spring Boot + JPA + Hibernate: Unable to locate persister -

-
i trying work entity inside request method of spring boot application. entity in project , pom.xml has dependencies it. why error message?: org.hibernate.unknownentitytypeexception: unable locate persister: com.ric.bill.model.bs.par package com.ric.web; import java.util.concurrent.atomic.atomiclong; import javax.persistence.entitymanager; import javax.persistence.persistencecontext; import net.sf.ehcache.cachemanager; import net.sf.ehcache.management.cache; import net.sf.ehcache.management.cachestatistics; import org.hibernate.stat.statistics; import org.springframework.beans.factory.annotation.autowired; import org.springframework.boot.autoconfigure.domain.entityscan; import org.springframework.cache.annotation.enablecaching; import org.springframework.transaction.annotation.enabletransactionmanagement; import org.springframework.transaction.annotation.propagation; import org.springframework.transaction.annotation.transactional; import org.springframework.web.bind.annotati
Read more

go - Golang: panic: runtime error: invalid memory address or nil pointer dereference using bufio.Scanner -

-
i implementing go program uses bufio.scanner , bufio.writer have packaged code follows package main import ( "fmt" "player/command" "strings" ) func main() { //enter code here. read input stdin. print output stdout commands.scanner.scan() { //scan new line , send comand variable check command exist or not input := strings.split(strings.trim(commands.scanner.text(), " "), " ") command := input[0] if command == "" { fmt.printf("$ %s:", commands.pwd) continue } if !commands.commands[command] { commands.throwerror("cannot recognize input.") } else { commands.execute(command, input[1:], nil) } fmt.printf("$ %s:", commands.pwd) } } i using init.go file in main package follows package main import ( "flag" "player/sourc
Read more

c - double free or corruption (fasttop) -

-
this code reads null terminated string file (file containing null terminated strings & should provide index wanted string). error: *** error in `./main': double free or corruption (fasttop): 0x090a4a80 *** aborted code: char *tmp_realloc=null; char *sstring=null; int i=1; /*set file pointer point string*/ fseek(fh,index,seek_set); sstring=(char*)malloc(sizeof(char)); if(sstring == null) return null; tmp_realloc=sstring; while( (*(sstring+i-1)=(char)fgetc((file*)fh)) != 0x0 ) { /*reallocate more memory*/ tmp_realloc=(char*)realloc((char*)sstring,++i); /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strcpy((char*)tmp_realloc,(char*)sstring); free(sstring); sstring=tmp_realloc; } } could tell me pointer causing issue (& reason) ? remove part /*if not same address copy old new & set old point new*/ if(tmp_realloc != sstring){ strc
Read more