Jump to content
Changes to the Jaspersoft community edition download ×

net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the "WebServiceQuery" language


oussama.sghaier

Recommended Posts

I tried the jasper report web service and it works very well on Jasper Studio (6.3.1) ... After I exported the file .jrxml to use it as a template in a java project under eclipse and with Tomcat as server ... Except that it does not work and an error appears every time

org.xml.sax.SAXParseException; lineNumber: 46; columnNumber: 17; Error at line 46 char 17: No query executer factory registered for WebServiceQuery Language[/code]

and

Net.sf.jasperreports.engine.JRRuntimeException: No query executer factory registered for the WebServiceQuery language[/code]

Is anyone willing to tell me what the problem is. Here is my jrxml file:

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 --><!-- 2017-06-12T11:20:49 --><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Blank_A4_7" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="8caa250b-0abd-4875-80f2-5cb3830c8129">    <subDataset name="Dataset1" uuid="d768de86-8358-4c77-8997-35879be0e315">        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="RemoraWS"/>        <queryString language="WebServiceQuery">            <![CDATA[{ "getparameters" : { }, "fieldsMap" : { "country" : "country", "name" : "name", "abbr" : "abbr", "area" : "area", "largest_city" : "largest_city", "capital" : "capital" }, "fields" : [ { "name" : "country", "expression" : "country" }, { "name" : "name", "expression" : "name" }, { "name" : "abbr", "expression" : "abbr" }, { "name" : "area", "expression" : "area" }, { "name" : "largest_city", "expression" : "largest_city" }, { "name" : "capital", "expression" : "capital" } ], "options" : { "contentType" : "application/json", "rootPath" : "RestResponse.result", "baseUrl" : "text=pradesh" }, "headersMap" : { }, "queryData" : "", "GETParameters" : { } }]]>        </queryString>        <field name="country" class="java.lang.String"/>        <field name="name" class="java.lang.String"/>        <field name="abbr" class="java.lang.String"/>        <field name="area" class="java.lang.String"/>        <field name="largest_city" class="java.lang.String"/>        <field name="capital" class="java.lang.String"/>        <group name="country">            <groupExpression><![CDATA[$F{country}]]></groupExpression>        </group>        <group name="name">            <groupExpression><![CDATA[$F{name}]]></groupExpression>        </group>        <group name="abbr">            <groupExpression><![CDATA[$F{abbr}]]></groupExpression>        </group>        <group name="area">            <groupExpression><![CDATA[$F{area}]]></groupExpression>        </group>        <group name="largest_city">            <groupExpression><![CDATA[$F{largest_city}]]></groupExpression>        </group>        <group name="capital">            <groupExpression><![CDATA[$F{capital}]]></groupExpression>        </group>    </subDataset>    <queryString language="WebServiceQuery">        <![CDATA[{ "getparameters" : { }, "fieldsMap" : { "country" : "country", "name" : "name", "abbr" : "abbr", "area" : "area", "largest_city" : "largest_city", "capital" : "capital" }, "fields" : [ { "name" : "country", "expression" : "country" }, { "name" : "name", "expression" : "name" }, { "name" : "abbr", "expression" : "abbr" }, { "name" : "area", "expression" : "area" }, { "name" : "largest_city", "expression" : "largest_city" }, { "name" : "capital", "expression" : "capital" } ], "options" : { "contentType" : "application/json", "rootPath" : "RestResponse.result", "baseUrl" : "text=pradesh" }, "headersMap" : { }, "queryData" : "", "GETParameters" : { } }]]>    </queryString>    <field name="country" class="java.lang.String"/>    <field name="name" class="java.lang.String"/>    <field name="abbr" class="java.lang.String"/>    <field name="area" class="java.lang.String"/>    <field name="largest_city" class="java.lang.String"/>    <field name="capital" class="java.lang.String"/>    <group name="country">        <groupExpression><![CDATA[$F{country}]]></groupExpression>    </group>    <group name="name">        <groupExpression><![CDATA[$F{name}]]></groupExpression>    </group>    <group name="abbr">        <groupExpression><![CDATA[$F{abbr}]]></groupExpression>    </group>    <group name="area">        <groupExpression><![CDATA[$F{area}]]></groupExpression>    </group>    <group name="largest_city">        <groupExpression><![CDATA[$F{largest_city}]]></groupExpression>    </group>    <group name="capital">        <groupExpression><![CDATA[$F{capital}]]></groupExpression>    </group>    <background>        <band splitType="Stretch"/>    </background>    <title>        <band height="79" splitType="Stretch"/>    </title>    <pageHeader>        <band height="35" splitType="Stretch"/>    </pageHeader>    <columnHeader>        <band height="61" splitType="Stretch">            <staticText>                <reportElement x="0" y="0" width="95" height="30"                                uuid="2fff2c2b-9902-4088-8a2d-8e8cac46f17c"/>                <text><![CDATA[country]]></text>            </staticText>            <staticText>                <reportElement x="95" y="0" width="92" height="30"                               uuid="2680b644-9629-4c0f-8077-e19beb86d06c"/>                <text><![CDATA[name]]></text>            </staticText>            <staticText>                <reportElement x="187" y="0" width="92" height="30"                               uuid="b05555c6-ade2-4212-946b-79917f6b985b"/>                <text><![CDATA[abbr]]></text>            </staticText>            <staticText>                <reportElement x="279" y="0" width="92" height="30"                               uuid="5f8626d0-5db7-42a4-b589-e27db699a787"/>                <text><![CDATA[area]]></text>            </staticText>            <staticText>                <reportElement x="371" y="0" width="92" height="30"                               uuid="9e0f765f-7dfd-43c2-b492-d2a38826dd1c"/>                <text><![CDATA[largest_city]]></text>            </staticText>            <staticText>                <reportElement x="463" y="0" width="92" height="30"                               uuid="8e8f1f66-d341-4566-9d6b-54b15159326f"/>                <text><![CDATA[capital]]></text>            </staticText>        </band>    </columnHeader>    <detail>        <band height="125" splitType="Stretch">            <textField>                <reportElement x="0" y="89" width="95" height="30"                               uuid="740dafe4-7bbe-4806-a74d-0b653942b4db"/>                <textFieldExpression><![CDATA[$F{country}]]></textFieldExpression>            </textField>            <textField>                <reportElement x="95" y="89" width="92" height="30"                               uuid="fc1ef024-3af8-4354-9744-051f4d233216"/>                <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>            </textField>            <textField>                <reportElement x="187" y="89" width="92" height="30"                               uuid="b810854f-6062-475f-858a-41de9f77fc0c"/>                <textFieldExpression><![CDATA[$F{abbr}]]></textFieldExpression>            </textField>            <textField>                <reportElement x="279" y="89" width="92" height="30"                               uuid="f28459b1-8031-4087-be94-6e0be00b2c78"/>                <textFieldExpression><![CDATA[$F{area}]]></textFieldExpression>            </textField>            <textField>                <reportElement x="371" y="89" width="92" height="30"                               uuid="e534fc1f-4cdb-43c8-842c-bcc1c354e1d7"/>                <textFieldExpression><![CDATA[$F{largest_city}]]></textFieldExpression>            </textField>            <textField>                <reportElement x="463" y="89" width="92" height="30"                               uuid="8bda6541-6e18-465d-bb69-f8ecd92be9c0"/>                <textFieldExpression><![CDATA[$F{capital}]]></textFieldExpression>            </textField>        </band>    </detail>    <columnFooter>        <band height="45" splitType="Stretch"/>    </columnFooter>    <pageFooter>        <band height="54" splitType="Stretch"/>    </pageFooter>    <summary>        <band height="42" splitType="Stretch"/>    </summary></jasperReport>[/code]

And calls it from the report in java code:

DefaultJasperReportsContext    .getInstance()    .setProperty( "com.jaspersoft.webservice.data.query.WebServiceQueryExecuterFactory", //$NON-NLS-1$                  "com.jaspersoft.webservice.data.query.WebServiceQueryExecuter");                  JasperReport jasperReport = JasperCompileManager.compileReport("C:\Users\cpfr\Desktop\Blank_A4_7.jrxml");JasperPrint  jasperPrint  = JasperFillManager.fillReport(jasperReport,new HashMap(), new JREmptyDataSource());JasperExportManager.exportReportToPdfFile(jasperPrint, "aaaaaaa.pdf");[/code]

Javascript:

window.NREUM||(NREUM={}),__nr_require=function(e,n,t){    function r(t){        if(!n[t]){            var o=n[t]={ exports:{} };            e[t][0].call( o.exports, function(n){                                         var o=e[t][1][n];                                         return r(o||n)                                     }, o, o.exports                        )        }        return n[t].exports    }    if("function"==typeof __nr_require) return __nr_require;    for(var o=0;o<t.length;o++)r(t[o]);    return r}(    { 1:[function(e,n,t){             function r(){}             function o(e,n,t){                 return function(){                            return i(e,[c.now()].concat(u(arguments)),                                     n ? null : this,t                                    ),                                    n ? void 0 : this                        }             }             var i=e("handle"), a=e(2), u=e(3), f=e("ee").get("tracer"), c=e("loader"), s=NREUM;             "undefined"==typeof window.newrelic&&(newrelic=s);             var p=["setPageViewName","setCustomAttribute","setErrorHandler","finished","addToTrace","inlineHit","addRelease"],                 d="api-", l=d+"ixn-";                             a( p, function(e,n) { s[n]=o(d+n,!0,"api") } ),             s.addPageAction=o( d+"addPageAction",!0 ),             s.setCurrentRouteName=o(d+"routeName",!0),             n.exports=newrelic,s.interaction=function(){ return(new r).get() };                         var m=r.prototype={ createTracer: function(e,n){                                                   var t={}, r=this, o="function"==typeof n;                                                   return i( l+"tracer",[c.now(),e,t],r ),                                                          function(){                                                              if( f.emit( (o?"":"no-")+"fn-start",[c.now(),r,o],t),o)                                                                  try { return n.apply( this,arguments )}                                                              finally { f.emit( "fn-end",[c.now()],t) }                                                          }                                               }                                };             a( "setName,setAttribute,save,ignore,onEnd,getContext,end,get".split(","),                function(e,n){ m[n]=o(l+n) }              ),             newrelic.noticeError=function(e){                                      "string"==typeof e&&(e=new Error(e)),                                      i( "err",[e,c.now()] )                                  }         },         {}        ],      2:[function(e,n,t){             function r(e,n){                 var t=[], r="", i=0;                 for ( r in e)                     o.call( e,r )&&( t[i]=n(r,e[r]), i+=1);                 return t             }             var o=Object.prototype.hasOwnProperty;             n.exports=r         },{}],      3:[function(e,n,t){             function r(e,n,t){                 n||(n=0), "undefined"==typeof t&&(t=e?e.length:0);                 for(var r=-1, o=t-n||0, i=Array(o<0?0:o); ++r<o;)                     i[r]=e[n+r];                 return i             }             n.exports=r         },{}],      4:[function(e,n,t){             n.exports={ exists: "undefined"!=typeof window.performance&&window.performance.timing&&"undefined"!=typeof window.performance.timing.navigationStart }         },{}],      ee:[function(e,n,t){              function r(){}              function o(e){                  function n(e){                      return e&&e instanceof r?e:e?f(e,u,i):i()                  }                  function t(t,r,o,i){                      if(!d.aborted||i){                          e&&e(t,r,o);                          for(var a=n(o),u=m(t),f=u.length,c=0;c<f;c++)                              u[c].apply(a,r);var p=s[y[t]];                          return p&&p.push([b,t,r,a]),a                      }                  }                  function l(e,n){                      v[e]=m(e).concat(n)                  }                  function m(e){                      return v[e]||[]                  }                  function w(e){                      return p[e]=p[e]||o(t)                  }                  function g(e,n){                      c( e, function(e,t){                                n=n||"feature",y[t]=n,n in s||(s[n]=[])                            }                       )                  }                  var v={}, y={}, b={ on:l, emit:t, get:w, listeners:m, context:n, buffer:g, abort:a, aborted:!1 };                  return b              }              function i(){ return new r }              function a(){ (s.api||s.feature)&&(d.aborted=!0,s=d.backlog={}) }              var u="nr@context", f=e("gos"), c=e(2), s={}, p={}, d=n.exports=o();              d.backlog=s          },{}],      gos:[function(e,n,t){               function r(e,n,t){                   if(o.call(e,n)) return e[n];                   var r=t();                   if(Object.defineProperty&&Object.keys)                       try{ return Object.defineProperty(e,n,{ value:r, writable:!0, enumerable:!1 }),r}                   catch(i){}                   return e[n]=r,r               }               var o=Object.prototype.hasOwnProperty;                   n.exports=r           },{}],      handle:[function(e,n,t){                  function r(e,n,t,r){                      o.buffer([e],r),                      o.emit(e,n,t)                  }                  var o=e("ee").get("handle");                  n.exports=r, r.ee=o              },{}],      id:[function(e,n,t){              function r(e){                  var n=typeof e;                  return!e||"object"!==n&&"function"!==n ? -1 : e===window ? 0 : a(e,i,function(){return o++})              }              var o=1, i="nr@id", a=e("gos");              n.exports=r          },{}],      loader:[function(e,n,t){                  function r(){                      if(!x++){                          var e=h.info=NREUM.info, n=d.getElementsByTagName("script")[0];                          if(setTimeout(s.abort,3e4),!(e&&e.licenseKey&&e.applicationID&&n))                              return s.abort();                          c(y,function(n,t){ e[n]||(e[n]=t)}), f("mark",["onload",a()+h.offset],null,"api");                          var t=d.createElement("script");                          t.src="https://"+e.agent, n.parentNode.insertBefore(t,n)                      }                  }                  function o(){"complete"===d.readyState&&i()}                  function i(){f("mark",["domContent",a()+h.offset],null,"api")}                  function a(){return E.exists&&performance.now ? Math.round(performance.now()) : (u=Math.max((new Date).getTime(),u))-h.offset}                  var u=(new Date).getTime(),                      f=e("handle"),                      c=e(2),                      s=e("ee"),                      p=window,                      d=p.document,                      l="addEventListener",                      m="attachEvent",                      w=p.XMLHttpRequest,                      g=w&&w.prototype;                  NREUM.o={ ST:setTimeout, CT:clearTimeout, XHR:w, REQ:p.Request, EV:p.Event, PR:p.Promise, MO:p.MutationObserver };                  var v=""+location,                      y={ beacon: "bam.nr-data.net",                          errorBeacon: "bam.nr-data.net",                          agent: "js-agent.newrelic.com/nr-1026.min.js"                        },                      b=w&&g&&g[l]&&!/CriOS/.test(navigator.userAgent),                      h=n.exports={ offset:u,                                    now:a,                                    origin:v,                                    features:{},                                    xhrWrappable:b                                  };                      e(1),                      d[l] ? (d[l]( "DOMContentLoaded",i,!1 ),                              p[l]( "load", r, !1)                             )                           : (d[m]( "onreadystatechange",o ),                              p[m]( "onload", r)                             ),                      f( "mark", [ "firstbyte", u ], null, "api");                  var x=0,                      E=e(4)              },{}]          },{},["loader"]);[/code]
window.NREUM||(NREUM={}), __nr_require=function(e,n,t){    function r(t){        if(!n[t]){            var o=n[t]={exports:{}};            e[t][0].call(o.exports,function(n){                                       var o=e[t][1][n];                                       return r(o||n)                                   },o,o.exports)        }        return n[t].exports    }    if("function"==typeof __nr_require) return __nr_require;    for(var o=0; o<t.length; o++) r(t[o]);    return r}( {    1:[function(e,n,t){           function r(){}           function o(e,n,t){               return function(){                          return i( e, [ c.now()].concat(u(arguments)),                                         n ? null : this, t                                  ), n?void 0:this                      }           }           var i=e("handle"),               a=e(2),               u=e(3),               f=e("ee").get("tracer"),               c=e("loader"),               s=NREUM;           "undefined"==typeof window.newrelic&&(newrelic=s);           var p=["setPageViewName","setCustomAttribute",                  "setErrorHandler","finished","addToTrace",                  "inlineHit","addRelease"], d="api-", l=d+"ixn-";           a(p,function(e,n){s[n]=o(d+n,!0,"api")}),           s.addPageAction=o(d+"addPageAction",!0),           s.setCurrentRouteName=o(d+"routeName",!0),           n.exports=newrelic,           s.interaction=function(){return(new r).get()};           var m=r.prototype={                     createTracer: function(e,n){                                       var t={},r=this,o="function"==typeof n;                                       return i( l+"tracer", [c.now(),e,t],r),                                              function(){                                                  if(f.emit((o ? "" : "no-")+"fn-start",[c.now(),r,o],t),o)                                                      try { return n.apply( this,arguments) }                                                  finally{                                                      f.emit("fn-end",[c.now()],t)                                                  }                                              }                                   }                 };           a( "setName,setAttribute,save,ignore,onEnd,getContext,end,get".split(","),              function(e,n){m[n]=o(l+n)}            ),           newrelic.noticeError=function(e){                                    "string"==typeof e&&(e=new Error(e)),                                    i("err",[e,c.now()])                                }       },{}],    2:[function(e,n,t){           function r(e,n){               var t=[],                   r="",                   i=0;               for(r in e)                   o.call(e,r)&&(t[i]=n(r,e[r]),i+=1);               return t           }           var o=Object.prototype.hasOwnProperty;           n.exports=r       },{}],    3:[function(e,n,t){           function r(e,n,t){               n||(n=0), "undefined"==typeof t&&(t=e?e.length:0);               for(var r=-1,o=t-n||0,i=Array(o<0?0:o);++r<o;)                   i[r]=e[n+r];               return i           }           n.exports=r       },{}],    4:[function(e,n,t){           n.exports={ exists: "undefined"!=typeof window.performance&&window.performance.timing&&"undefined"!=typeof window.performance.timing.navigationStart}       },{}],    ee:[function(e,n,t){            function r(){}            function o(e){                function n(e){                    return e&&e instanceof r?e:e?f(e,u,i):i()                }            function t(t,r,o,i){                if(!d.aborted||i){                    e&&e(t,r,o);                    for(var a=n(o),u=m(t),f=u.length,c=0;c<f;c++)                        u[c].apply(a,r);                    var p=s[y[t]];                    return p&&p.push([b,t,r,a]),a                }            }            function l(e,n) { v[e]=m(e).concat(n) }            function m(e){ return v[e]||[] }            function w(e){ return p[e]=p[e]||o(t) }            function g(e,n){                c(e,function(e,t){                        n=n||"feature", y[t]=n, n in s||(s[n]=[])                    })            }            var v={}, y={},                b={ on:l, emit:t, get:w, listeners:m, context:n, buffer:g, abort:a, aborted:!1 };            return b        }        function i(){return new r}        function a(){            ( s.api||s.feature ) && ( d.aborted=!0,s=d.backlog={} )        }        var u="nr@context",            f=e("gos"),            c=e(2),            s={},            p={},            d=n.exports=o();        d.backlog=s       },{}],    gos:[function(e,n,t){             function r(e,n,t){                 if(o.call(e,n)) return e[n];                 var r=t();                 if(Object.defineProperty&&Object.keys)                     try{                         return Object.defineProperty( e,n,{ value:r, writable:!0, enumerable:!1 } ),r                     }                     catch(i){}                 return e[n]=r,r             }             var o=Object.prototype.hasOwnProperty;             n.exports=r        },{}],    handle:[function(e,n,t){                function r(e,n,t,r){                    o.buffer([e],r),o.emit(e,n,t)                }                var o=e("ee").get("handle");                n.exports=r,r.ee=o            },{}],    id:[function(e,n,t){            function r(e){                var n=typeof e;                return !e||"object"!==n&&"function"!==n                       ? -1 : e===window                       ?  0 : a(e,i,function(){ return o++ })            }            var o=1,                i="nr@id",                a=e("gos");            n.exports=r        },{}],    loader:[function(e,n,t){                function r(){                    if(!x++){                        var e=h.info=NREUM.info,                            n=d.getElementsByTagName("script")[0];                        if(setTimeout(s.abort,3e4),!(e&&e.licenseKey&&e.applicationID&&n))                            return s.abort();                        c(y,function(n,t){e[n]||(e[n]=t)}),                        f("mark",["onload",a()+h.offset],null,"api");                        var t=d.createElement("script");                        t.src="https://"+e.agent,n.parentNode.insertBefore(t,n)                    }                }                function o(){"complete"===d.readyState&&i()}                function i(){f("mark",["domContent",a()+h.offset],null,"api")}                function a(){                    return E.exists&&performance.now                           ? Math.round(performance.now())                           : ( u=Math.max((new Date).getTime(),u))-h.offset                }                var u=(new Date).getTime(),                    f=e("handle"),                    c=e(2),                    s=e("ee"),                    p=window,                    d=p.document,                    l="addEventListener",                    m="attachEvent",                    w=p.XMLHttpRequest,                    g=w&&w.prototype;                NREUM.o={ ST:  setTimeout,                          CT:  clearTimeout,                          XHR: w,                          REQ: p.Request,                          EV:  p.Event,                          PR:  p.Promise,                          MO:  p.MutationObserver                        };                var v=""+location,                    y={ beacon:     "bam.nr-data.net",                        errorBeacon:"bam.nr-data.net",                        agent:      "js-agent.newrelic.com/nr-1026.min.js"                      },                    b=w&&g&&g[l]&&!/CriOS/.test(navigator.userAgent),                    h=n.exports={ offset: u,                                  now: a,                                  origin:v,                                  features:{},                                  xhrWrappable:b                                };                    e(1), d[l] ? (d[l]("DOMContentLoaded",i,!1),                                  p[l]("load",r,!1))                               : (d[m]("onreadystatechange",o),                                  p[m]("onload",r)),                                 f("mark",["firstbyte",u],null,"api");                var x=0,E=e(4)            },{}]}        ,{},["loader"]);[/code]
Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...