Using web service and use it as default data adapter error

Posted on May 1, 2020 at 9:42am

org.apache.http.client.HttpResponseException: 500 at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:79) at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:49) at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.addOrModifyResource(RestV2ConnectionJersey.java:631) at com.jaspersoft.studio.server.protocol.ProxyConnection.addOrModifyResource(ProxyConnection.java:345) at com.jaspersoft.studio.server.publish.Publish.publishResources(Publish.java:191) at com.jaspersoft.studio.server.publish.Publish.publish(Publish.java:67) at com.jaspersoft.studio.server.publish.wizard.Publish2ServerWizard$3.run(Publish2ServerWizard.java:309) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:122)

THIS IS THE JRXML

<?xml version="1.0" encoding="UTF-8"?>

<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="jhune" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="96693c27-4c15-4cb1-9b7e-e1696c6bcdac">
   <property name="net.sf.jasperreports.data.adapter" value="jhune.xml"/>
   <queryString language="WebServiceQuery">
       <![CDATA[{
"getparameters" : { },
"fields" : [ {
"name" : "age",
"expression" : "age"
}, {
"name" : "gender",
"expression" : "gender"
}, {
"name" : "name",
"expression" : "name"
} ],
"options" : {
"contentType" : "application/json",
"rootPath" : "employees",
"baseUrl" : "fire/"
},
"headersMap" : { },
"queryData" : "",
"GETParameters" : { }
}]]>
   </queryString>
   <field name="age" class="java.lang.String"/>
   <field name="gender" class="java.lang.String"/>
   <field name="name" class="java.lang.String"/>
   <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="11" y="0" width="100" height="30" uuid="3566e215-e020-4d6a-a696-fe25b5bd7d3b">
                   <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1bc692d8-3651-492f-a76d-eba81200200d"/>
               </reportElement>
               <text><![CDATA[gender]]></text>
           </staticText>
           <staticText>
               <reportElement x="203" y="0" width="100" height="30" uuid="c40de48f-23f2-4576-a2db-7feba824ac36">
                   <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c662481e-fa82-4ae0-a6d1-b2271f43e490"/>
               </reportElement>
               <text><![CDATA[name]]></text>
           </staticText>
           <staticText>
               <reportElement x="413" y="0" width="100" height="30" uuid="b9863f22-f58b-49f8-8a49-40ec5600ad6e">
                   <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="47145b20-27ad-4559-8bdc-9235c78ddd10"/>
               </reportElement>
               <text><![CDATA[age]]></text>
           </staticText>
       </band>
   </columnHeader>
   <detail>
       <band height="125" splitType="Stretch">
           <textField>
               <reportElement x="11" y="44" width="100" height="30" uuid="37885463-88a0-46a8-ac84-753132e0a08a">
                   <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1bc692d8-3651-492f-a76d-eba81200200d"/>
               </reportElement>
               <textFieldExpression><![CDATA[$F{gender}]]></textFieldExpression>
           </textField>
           <textField>
               <reportElement x="203" y="65" width="100" height="30" uuid="9af305a4-69cd-4d73-b6ad-1f24e9252fb9">
                   <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c662481e-fa82-4ae0-a6d1-b2271f43e490"/>
               </reportElement>
               <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
           </textField>
           <textField>
               <reportElement x="413" y="40" width="100" height="30" uuid="eaa81bfd-9a34-4959-adb4-a96b4f362f4b">
                   <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="47145b20-27ad-4559-8bdc-9235c78ddd10"/>
               </reportElement>
               <textFieldExpression><![CDATA[$F{age}]]></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>