wso2dss - WSO2 DSS Query error using car -


i created dataservice using wso2 dss version 3.5.0. when install dataservice using car doesn't work, if install simple dbs file works. writing query in single line works using car.

i' can't remember exception, parameter coupling, think there parsing issue when dataservice packaged in car.

this query:

    select aff.id_notifica,       att.codice_concessionario cod_adr,       aff.tipo_atto,       case          when urg.fascia not null urg.fascia         when pic.fascia not null pic.fascia         else '0'       end priorita,             trunc(fff.dttm_sped_rice) data_affido,       aff.cod_ambito,       aff.id_commessa,       aff.numero_atto,       aff.codice_fiscale,       aff.destinatario,       ren.codice_attivita,       ren.codice_soggetto_autorizzato,       ren.data_attivita,       case          when ren.codice_attivita in ('080','081','082','083','084','085')         ren079.data_deposito         else ren.data_deposito       end data_deposito,       case         when ren.codice_attivita in ('080','081','082','083','084','085')         ren079.data_affissione         else ren.data_affissione       end data_affissione,       case         when ren.codice_attivita in ('080','081','082','083','084','085')         ren079.data_invio_raccomandata         else ren.data_invio_raccomandata       end data_invio_raccomandata,       case         when ren.codice_attivita in ('080','081','082','083','084','085')         ren079.numero_raccomandata         else ren.numero_raccomandata         end numero_raccomandata,       ren.codice_messo  myschema.table1 aff join eqspdi.table2 att on to_number(att.codice_ambito) = to_number(aff.cod_ambito)     join eqspdi.table3 fff on fff.id_file_flusso_in=aff.id_file_flusso     left join (       select *       myschema.table4 rr       rr.id_rendicontazione in (           select max(id_rendicontazione)           myschema.table4           id_notifica=rr.id_notifica           , numero_atto = :numeroatto       )     ) ren on ren.id_notifica=aff.id_notifica     left join myschema.table4 ren079        on ren079.id_notifica=ren.id_notifica , ren079.codice_attivita='079' , ren079.esito_ren_ris='ok'     left join (       select *       myschema.table5 pa       pa.id_picchi_affido in (         select max(id_picchi_affido)         myschema.table5         group cod_ambito, id_commessa       )     ) pic on pic.cod_ambito=aff.cod_ambito , pic.id_commessa=aff.id_commessa     left join (       select *       myschema.table6 urg       urg.id_atti_urgenti in (         select max(id_atti_urgenti)         myschema.table6         group id_notifica       )     ) urg on urg.id_notifica=aff.id_notifica  aff.numero_atto = :numeroatto


Comments

Post a Comment

Popular posts from this blog

Sort a complex associative array in PHP -

this question has answer here: php sort array subarray value 5 answers i have associative array in php like: $newarray1 = array ( [producta] => array ( [link] => http://sanjosespartan.com/blog/products/agile-java-development/ [visitcount] => 4 ) [productd] => array ( [link] => http://sanjosespartan.com/blog/products/intro-to-go/ [visitcount] => 1 ) [productg] => array ( [link] => http://sanjosespartan.com/blog/products/node-js-for-developers/ [visitcount] => 1 ) [productb] => array ( [link] => http://sanjosespartan.com/blog/products/beginning-mysql/ [visitcount] => 1 ) [productc] => array ( [link] => http://sanjosespartan.com/blog/products/computer-networks/ [visitcount] => 1 ) ...
Read more

vb.net - How to ignore if a cell is empty nothing -

how use roscolor() ignore value (like empty cell) ? color row if value upper 5 when there nothing in cell, want ignore roscolor() apply, how? public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val integer val = quotedatagridview1.rows(i).cells(3).value if val = vbempty quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white elseif val < 5 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.red elseif val > 5 , val < 10 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.lightyellow end if next end sub you can check empty value following public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val = quotedatagridview1.rows(i).cells(3).value if isdbnull(val) or val nothing quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white ...
Read more

recursion - Can every recursive algorithm be improved with dynamic programming? -

i first year undergraduate csc student looking competitive programming. recursion involves defining , solving sub problems. understand, top down dynamic programming (dp) involves memoizing solutions sub problems reduce time complexity of algorithm. can top down dp used improve efficiency of every recursive algorithm overlapping sub problems? dp fail work , how can identify this? the short answer is: yes. however, there constraints. obvious 1 recursive calls must overlap. i.e. during execution of algorithm, recursive function must called multiple times same parameters. lets truncate recursion tree memoization. can use memoization reduce number of calls. however, reduction of calls comes price. need store results somewhere. next obvious constraint need have enough memory. comes not-so obvious constraint. memory access requires time. first need find result stored , maybe copy location. in cases, might faster let recursion calculate result instead of loading somewher...
Read more