Null value when using XML Data Source

2004 IR Help · August 24, 2006

By: cyunntan - cyunntan

2005-10-31 02:35

Hi All,

Im using XMLDataSource datasource connection to generate my report. I've got the below XML

<A>

</Payment>

</Payment>

</A>

FieldName: BrchCde

Field class type : java.lamg.String

Field Name: RcptNo

Field class type : java.lamg.String

Select expression : /A/Payment

But ..im getting null value for the two columns when i execute the report to generate PDF..

Anyone could provide me with an explaination ? Im stuck ..

Thank you..

regards,

cyunn

By: Vincenzo Amoruso - vinciamo

RE: Null value when using XML Data Source

2005-10-31 04:40

I think that the Xml file should be :

<A>

<BrchCde>aaaaaaa</BrchCde>

<RcptNo>aaaaaaaa</RcptNo>

</Payment>

<BrchCde>bbbbb</BrchCde>

<RcptNo>bbbbbbbbbb</RcptNo>

</Payment>

</A>

query :

/A/Payment

Is you are using IReport take a look in samplesdatasource sub directory

Regards

Vincenzo

By: cyunntan - cyunntan

RE: Null value when using XML Data Source

2005-10-31 07:16

Hi Vincenzo,

Yea.It's my mistake when posting the question. Actually, i've got the XML source correctly .It's just that i don't seem to get the value of BrchCde and RcptNo from my XML source. It only shows null , null on my PDF..

Im trying Jasper by refering to the XMLDataSource Sample ..

Any idea what have gone wrong ? It looks simple..but im having quite a hard time here ..

Hope to hear from you all soon..

Thank you

Regards,

cyunn

By: Vincenzo Amoruso - vinciamo

RE: Null value when using XML Data Source

2005-10-31 07:53

Hi cyunn!

Only one question, are you tryng to create a report with the two details, first for item rows and second for payment rows, both in the same jrxml?

is it true?

In this case is better to create a subreport for payment rows.

Regards

Vincenzo!

By: Lucian Chirita - lucianc

RE: Null value when using XML Data Source

2005-10-31 08:25

JRXmlDataSource uses field descriptions as relative XPaths. Did you set the field descriptions?

HTH,

Lucian

By: cyunntan - cyunntan

RE: Null value when using XML Data Source

2005-10-31 18:20

Hi Lucian,

Yea. I've set the field name exactly as the field description.

FieldName : BrchCde

FieldDescriptioin : BrchCde

FieldName : RcptNo

FieldDescription : RcptNo

Both are java.langs.String type.

Anything loopholes that i might have miss out ?

Thank you Lucian for your response. :)

Hi Vincenzo,

Im planning to display the list of payment. It is straightforward. As my example XML says, I wish to display two records of payment made , where each records will have 2 attributes i.e BrchCde and RcptNo

Eg:

List of Payment :

BrchCde 1 RcptNo 001

BrchCde 2 RcptNo 002

Something simple. Coz' im in the stage of trying out . If I can't solve this, meaning i can't proceed :(

Im new to JP.So, i don't know if i have miss out any steps while creating a report. Thus, i shall briefly explain what i have done.

1.Get 1 sample of simple XML datasource

2.Design 2 Fields. Set the text field for each with

the value $F{BrchCde} and $F{RcptNo}

3.Set the parameter field for each text field under

Field Tab.One is BrchCde and another is

RcptNo. Same value for fieldName and

fieldDescription.

4.Set the XML file datasouce to point to my

XML.

Name : Payment

XML File : C:/Test.xml

Select expression : /A/Payment/

5.Compile and execute my report in PDF format.

Then i got null for BrchCde and null for RcptNo as the result ..

Anything that i've miss out ? By the way, what is to be filled in for the Name section in my Step4? Is it my XML name? Test? Or the highest node in my XML source or simply anything?

Thank you Vincenzo for your response too. :)

Please advise me...Looking forward to hear from SourceForge fellows..:)

Regards,

cyunn

By: Lucian Chirita - lucianc

RE: Null value when using XML Data Source

2005-11-01 00:01

Could you post your report jrxml and the input xml? If we see the whole thing, we should spot the problem..

Regards,

Lucian

By: cyunntan - cyunntan

RE: Null value when using XML Data Source

2005-11-01 02:05

Hi Lucian,

Ok. I'll post them.

This is my payment.jrxml

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

<!DOCTYPE jasperReport PUBLIC "//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="payment"

columnCount="1"

printOrder="Vertical"

orientation="Portrait"

pageWidth="595"

pageHeight="842"

columnWidth="535"

columnSpacing="0"

leftMargin="30"

rightMargin="30"

topMargin="20"

bottomMargin="20"

whenNoDataType="NoPages"

isTitleNewPage="false"

isSummaryNewPage="false">

</field>

</field>

</band>

</background>

<title>

<reportElement

mode="Opaque"

x="6"

y="2"

width="527"

height="43"

forecolor="#000000"

backcolor="#FFCC33"

key="staticText-1"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

</band>

</title>

</band>

</pageHeader>

<reportElement

mode="Opaque"

x="21"

y="4"

width="78"

height="22"

forecolor="#000000"

backcolor="#CC9900"

key="staticText-2"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

<reportElement

mode="Opaque"

x="120"

y="5"

width="78"

height="23"

forecolor="#000000"

backcolor="#CC9900"

key="staticText-3"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</staticText>

</band>

</columnHeader>

<reportElement

mode="Opaque"

x="19"

y="8"

width="80"

height="22"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField-1"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

<reportElement

mode="Opaque"

x="122"

y="10"

width="100"

height="19"

forecolor="#000000"

backcolor="#FFFFFF"

key="textField-2"

stretchType="NoStretch"

positionType="FixRelativeToTop"

isPrintRepeatedValues="true"

isRemoveLineWhenBlank="false"

isPrintInFirstWholeBand="false"

isPrintWhenDetailOverflows="false"/>

</textElement>

</textField>

</band>

</detail>

</band>

</columnFooter>

</band>

</pageFooter>

</band>

</lastPageFooter>

</band>

</summary>

</jasperReport>

************************

While this is my input XML: Text2.xml

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

<NODE1>

<NODE2>

</NODE2>

<NODE2>

</NODE2>

</NODE1>

Please advice me ...Thank you so much..

Regards,

cyunn

By: cyunntan - cyunntan

RE: Null value when using XML Data Source

2005-11-01 02:14

Sorry ..there is some mistake for my input XML..

This should be the one ..

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

<NODE1>

<NODE2>

</NODE2>

<NODE2>

</NODE2>

</NODE1>

Thank You

Regards,

cyunn

By: Lucian Chirita - lucianc

RE: Null value when using XML Data Source

2005-11-01 02:35

Weird, it works fine for me using new JRXmlDataSource("c:\tmp\xml.xml", "/NODE1/NODE2")

What JR version are you using?

By: cyunntan - cyunntan

RE: Null value when using XML Data Source

2005-11-01 17:33

Hi Lucian,

Im using JP version 0.4.1.

Still im getting null values.

Im using the java class provided in the XMLDataSource sample to compile my jrxml and modify the parameter accordingly to fit my input XML.

JRXmlDataSource(new BufferedInputStream(new FileInputStream("Text2.xml")), "/Node1/Node2"));

Any idea ? Thank You for your advice ..

Regards,

cyunn

By: Lucian Chirita - lucianc

RE: Null value when using XML Data Source

2005-11-02 00:03

XPath is case sensitive, you need /NODE1/NODE2.

HTH,

Lucian

By: cyunntan - cyunntan

RE: Null value when using XML Data Source

2005-11-11 00:00

Hi Lucian,

I've been trying out on your advice this past few days. Take note on the case sensitive part as well. Still im getting null values. Anyway,i'll try to redesign my report once again, maybe i just overlook something. Or you've any solutions ?

By the way, when i try to launch ireport 0.4.1 at other PC with j2sdk1.4.2_05 , i was unable to launch it.

Im getting this kind of error message :

Exception in thread "main" java.lang.UnsupportedClassVersionError: it/businesslo

gic/ireport/gui/MainFrame (Unsupported major.minor version 48.0)

at java.lang.ClassLoader.defineClass0(Native Method)

at java.lang.ClassLoader.defineClass(Unknown Source)

Any idea ?

Thank you for your advice .

Regards,

cyunn

By: Lucian Chirita - lucianc

RE: Null value when using XML Data Source

2005-11-17 03:44

Hi

I'm out of ideas. The files you posted worked for me.

You could get the Jasper sources and debug it to see what goes wrong.

Regarding the iReport issue, try posting on the iReport forum/mailing list.

Regards,

Lucian

By: nishant - nkaushik

RE: Null value when using XML Data Source

2006-03-28 06:43

Hi!

Did you ever solve this problem??? i am facing a similar problem... mentioned below... ur help will be appretiated

Did you ever solve this problem?

I am trying to access the xml file and display the details in a pdf,i keep getting this error

Caused by: java.lang.LinkageError: Class org/w3c/dom/traversal/NodeIterator violates loader constraints: definition mismatch between parent and child loaders

if i have the description tag for the field....if i remove the description tag then the pdf is generated but i get all null values inside the report.........

this is the code i use to parse and compile the file

else if(request.getParameter("GetFromXMLSourceFormSubmit") != null){

Map params = new HashMap();

try

{

System.out.println("111111111");

//Document document = JRXmlUtils.parse(new File("C:/WINDOWS/Profiles/nkaushik/IBM/rationalsdp6.0/workspace/Source/JasperReportsSampleWar/WebContent/WEB-INF/classes/northwind.xml"));

JRXmlDataSource xmlDataSource= new JRXmlDataSource(new File("C:/WINDOWS/Profiles/nkaushik/IBM/rationalsdp6.0/workspace/Source/JasperReportsSampleWar/WebContent/WEB-INF/classes/northwind.xml"),"/Northwind/Customers");

//JRXmlDataSource xmlDataSource= new JRXmlDataSource(document,"/Northwind/Customers");

JasperReport jasperReport = JasperCompileManager.compileReport("C:/WINDOWS/Profiles/nkaushik/IBM/rationalsdp6.0/workspace/Source/JasperReportsSampleWar/WebContent/WEB-INF/classes/Customers.jrxml");

//Document document = JRXmlUtils.parse(new File("C:/WINDOWS/Profiles/nkaushik/IBM/rationalsdp6.0/workspace/Source/JasperReportsSampleWar/WebContent/WEB-INF/classes/northwind.xml"));

System.out.println("22222222222222");

//params.put(JRXPathQueryExecuterFactory.PARAMETER_XML_DATA_DOCUMENT, document);

System.out.println("333333333333333");

//JasperRunManager.runReportToPdfFile("C:/WINDOWS/Profiles/nkaushik/IBM/rationalsdp6.0/workspace/Source/JasperReportsSampleWar/WebContent/WEB-INF/classes/Customers.jrxml", params);

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, params,xmlDataSource);

System.out.println("444444444444444");

JasperExportManager.exportReportToPdfFile(jasperPrint,"c:/reportFromXML.pdf");

System.out.println("5555555555555555");

JasperExportManager.exportReportToHtmlFile(jasperPrint,"c:/reportFromXML.html");

System.out.println("66666666666666666666");

}

catch (JRException e)

i cant get pass beyond the message333333333... if description tag is there

plz advice

Nishant

By: Nicky15 - nicky15

RE: Null value when using XML Data Source

2006-06-01 15:54

Have you populated your HashMap variable 'params'?

Please let me know how you have done it. I get error on the JRXmlUtils line.

Thanks.

genx · September 26, 2007

Hi,

Can you check if you have xerces somewhere in your classpath? I have the same linkage problem and I am trying to confirm if the 2 are connected.

Thanks

genx · September 26, 2007

Sorry I just noticed that this was a really old post..

jjatzkowski · October 8, 2007

inspite this is an old post I just have had the same problem. The reason for my problem was that there are two implementations of an XML datasource.

see http://ireport.sourceforge.net/cap7.html

Using the new one from jasperreports works as expected.

Post edited by: jjatzkowski, at: 2007/10/08 04:35

sabry_lk · January 15, 2008

thank you very much!!!

was struggling for 2days with this prob

Sign In

Null value when using XML Data Source

Recommended Posts

2004 IR Help

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

genx

Link to comment

Share on other sites

genx

Link to comment

Share on other sites

jjatzkowski

Link to comment

Share on other sites

sabry_lk

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore