XML data adapter

Changed Severity from Major to Minor

Changed Resolution from Open to Unable to Reproduce

Changed Status from New to Closed

Changed Assigned User from - to @User_306070

---

Hi,it's possible this problem has already been solved.I've just checked with the last sources available. Test works fine and also previewing a report that uses an XML data adapter works correct.Regards,Massimo.

Changed Severity from Minor to Critical

Changed Resolution from Unable to Reproduce to Open

Changed Status from Closed to New

Changed Assigned User from @User_306070 to @mrabbi

---

Hi Massimo,I just installed JSS 6.0.0 and since i'm also using XML documents as data sources i came across this issue.It's - at leat for me - quite easy to reproduce:I can create a new data adapter (XML document type), but when i click on the Test button i'll get an Exception message box with the following details:java.lang.NullPointerException at net.sf.jasperreports.data.xml.XmlDataAdapterService.loadDataDocument(XmlDataAdapterService.java:169) at net.sf.jasperreports.data.xml.XmlDataAdapterService.contributeParameters(XmlDataAdapterService.java:90) at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:129) at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:165) at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)When i try to execute a simple report using such a XML document data adapter i'll get the following output in the console:Start Report ExecutionCompiling report......DONESetting Data Adapter...DONESetting Virtualizer...DONEFilling Report........ERRORnet.sf.jasperreports.engine.JRException: java.lang.NullPointerException at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:467) at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$18(ReportControler.java:442) at com.jaspersoft.studio.editor.preview.view.control.ReportControler$4.run(ReportControler.java:334) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)Caused by: java.lang.NullPointerException at net.sf.jasperreports.data.xml.XmlDataAdapterService.loadDataDocument(XmlDataAdapterService.java:169) at net.sf.jasperreports.data.xml.XmlDataAdapterService.contributeParameters(XmlDataAdapterService.java:90) at net.sf.jasperreports.engine.fill.JRFillDataset.contributeParameters(JRFillDataset.java:1024) at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:629) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:433) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:508) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:120) at java.lang.Thread.run(Unknown Source)Report Execution Finished.I'll the same error(s) when i create the data adapter in the Repository Explorer *and* when i create it in the workspace (Project Explorer). The same data adapters work with JSS 5.6.1.Additionally and perhaps connected with this issue - when i startup JSS 6.0.0 i'll get the following stacktraces in the JaspersoftWorkspace/.metadata/.log file:!ENTRY com.jaspersoft.studio 4 0 2014-11-30 19:47:00.885!MESSAGE FrameworkEvent ERROR!STACK 0java.lang.RuntimeException: javax.xml.transform.TransformerException: java.io.FileNotFoundException: C:\Dokumente%20und%20Einstellungen\Administrator\JaspersoftWorkspace\.metadata\.plugins\com.jaspersoft.studio\dataAdapters\dataAdapter_3 (Das System kann den angegebenen Pfad nicht finden) at com.jaspersoft.studio.ConfigurationManager.convertPropertyToStorage(ConfigurationManager.java:195) at com.jaspersoft.studio.data.storage.PreferencesDataAdapterStorage.findAll(PreferencesDataAdapterStorage.java:64) at com.jaspersoft.studio.data.storage.ADataAdapterStorage.getDataAdapterDescriptors(ADataAdapterStorage.java:46) at com.jaspersoft.studio.data.DataAdapterManager.getPreferencesStorage(DataAdapterManager.java:141) at com.jaspersoft.studio.plugin.ExtensionManager.init(ExtensionManager.java:96) at com.jaspersoft.studio.JaspersoftStudioPlugin.getExtensionManager(JaspersoftStudioPlugin.java:168) at com.jaspersoft.studio.JaspersoftStudioPlugin.postStartOperations(JaspersoftStudioPlugin.java:121) at net.sf.jasperreports.eclipse.AbstractJRUIPlugin$1.bundleChanged(AbstractJRUIPlugin.java:80) at org.eclipse.osgi.framework.internal.core.BundleContextImpl.dispatchEvent(BundleContextImpl.java:847) at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230) at org.eclipse.osgi.framework.eventmgr.ListenerQueue.dispatchEventSynchronous(ListenerQueue.java:148) at org.eclipse.osgi.framework.internal.core.Framework.publishBundleEventPrivileged(Framework.java:1568) at org.eclipse.osgi.framework.internal.core.Framework.publishBundleEvent(Framework.java:1504) at org.eclipse.osgi.framework.internal.core.Framework.publishBundleEvent(Framework.java:1499) at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:391) at org.eclipse.osgi.framework.internal.core.AbstractBundle.start(AbstractBundle.java:300) at org.eclipse.osgi.framework.util.SecureAction.start(SecureAction.java:440) at org.eclipse.osgi.internal.loader.BundleLoader.setLazyTrigger(BundleLoader.java:263) at org.eclipse.core.runtime.internal.adaptor.EclipseLazyStarter.postFindLocalClass(EclipseLazyStarter.java:107) at org.eclipse.osgi.baseadaptor.loader.ClasspathManager.findLocalClass(ClasspathManager.java:469) at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.findLocalClass(DefaultClassLoader.java:216) at org.eclipse.osgi.internal.loader.BundleLoader.findLocalClass(BundleLoader.java:395) at org.eclipse.osgi.internal.loader.SingleSourcePackage.loadClass(SingleSourcePackage.java:35) at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:461) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:421) at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:412) at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107) at java.lang.ClassLoader.loadClass(Unknown Source) at com.jaspersoft.studio.rcp.intro.ApplicationWorkbenchAdvisor.initialize(ApplicationWorkbenchAdvisor.java:89) at org.eclipse.ui.application.WorkbenchAdvisor.internalBasicInitialize(WorkbenchAdvisor.java:188) at org.eclipse.ui.internal.Workbench$28.runWithException(Workbench.java:1541) at org.eclipse.ui.internal.StartupThreading$StartupRunnable.run(StartupThreading.java:31) at org.eclipse.swt.widgets.RunnableLock.run(RunnableLock.java:35) at org.eclipse.swt.widgets.Synchronizer.runAsyncMessages(Synchronizer.java:135) at org.eclipse.swt.widgets.Display.runAsyncMessages(Display.java:4144) at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3761) at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2609) at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499) at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679) at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332) at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668) at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149) at com.jaspersoft.studio.rcp.intro.Application.start(Application.java:94) at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110) at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353) at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629) at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584) at org.eclipse.equinox.launcher.Main.run(Main.java:1438)Caused by: javax.xml.transform.TransformerException: java.io.FileNotFoundException: C:\Dokumente%20und%20Einstellungen\Administrator\JaspersoftWorkspace\.metadata\.plugins\com.jaspersoft.studio\dataAdapters\dataAdapter_3 (Das System kann den angegebenen Pfad nicht finden) at org.apache.xalan.transformer.TransformerIdentityImpl.createResultContentHandler(TransformerIdentityImpl.java:297) at org.apache.xalan.transformer.TransformerIdentityImpl.transform(TransformerIdentityImpl.java:330) at com.jaspersoft.studio.ConfigurationManager.convertPropertyToStorage(ConfigurationManager.java:182) ... 54 moreCaused by: java.io.FileNotFoundException: C:\Dokumente%20und%20Einstellungen\Administrator\JaspersoftWorkspace\.metadata\.plugins\com.jaspersoft.studio\dataAdapters\dataAdapter_3 (Das System kann den angegebenen Pfad nicht finden) at java.io.FileOutputStream.open(Native Method) at java.io.FileOutputStream.(Unknown Source) at java.io.FileOutputStream.(Unknown Source) at org.apache.xalan.transformer.TransformerIdentityImpl.createResultContentHandler(TransformerIdentityImpl.java:287) ... 56 moreThe Repository Explorer also does not display the data adapters i've created in a previous JSS session, but the dataAdapter_0, dataAdapter_1 etc. files are there in directory JaspersoftWorkspace\.metadata\.plugins\com.jaspersoft.studio\dataAdapters ...

Changed Priority from Normal to Immediate

Changed Severity from Critical to Block

---

Hello,I have exactly the same issue as described by Michael Schmid.In my project, EVERY data source is an XML data source. So, Jaspersoft Studio 6.0.0 is NOT usable on our project. That's really a pity because I need the book function in some of the reports.The project is thus stuck due to this error.Is there any workaround available?

Changed Status from New to Feedback Requested

---

Hi I was not able to verify your issue.Please give a look at the following screencast I've registered: http://www.screencast.com/t/i2BstZGO2nStated that Michael is upgrading from an existing 5.6.1, jomeyer which version were you using before?Can you guys please register a screencast with all the steps you perform in order to obtain the error?The exception you copy-pasted seems to be similar to what experienced in this issue: http://community.jaspersoft.com/jaspersoft-studio/issues/3977Did you used an already existing data adapter? Did you try to create a new one from scratch?Regards,Massimo.

Hi Massimo,

 

I like to take a look at your screencast - but is the URL that you provided correct?

 

I can reproduce the issue quite easily on my WinXP VM.

At the start i rename my existing Workspace directory (to "JasperWorkspace_Bak").

 

Then i install JSS 6.0.0. Installation works without any problems.

Now, when i start JSS 6.0.0 it asks me for my Workspace directory - i define a new, non-existing directory. JSS creates the directory. Fine so far.

Now when i close the Welcome screen i have two data adapters (One Empty Record and Sample DB) in the Repository and three libs in the Project Explorer - an empty new world.

 

Now i quit JSS and restart it again - just to test if the two data adapters are still there - they are, OK.

I create a new XML file data adapter and save it, restart, it's still there, OK.

 

But when i now open my XML data adapter and click on Test i'll get:

 

java.lang.NullPointerException

at net.sf.jasperreports.data.xml.XmlDataAdapterService.loadDataDocument(XmlDataAdapterService.java:169)

at net.sf.jasperreports.data.xml.XmlDataAdapterService.contributeParameters(XmlDataAdapterService.java:90)

at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:129)

at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:165)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

 

Interestingly, during this test i did NOT get any "javax.xml.transform.TransformerException: java.io.FileNotFoundException" exceptions in the .log file...

 

Regards,

Michael

Changed Status from Feedback Requested to Assigned

---

Hi, can you provide the content of your C:\Dokumente%20und%20Einstellungen\Administrator\JaspersoftWorkspace\.metadata\.plugins\com.jaspersoft.studiofolder?Remember that this files contains your data adapters and servers configurations, so even if you want to share them with me then it is better to send the files only to me to my personal email morlandi@tibco.com

Changed Assigned User from @mrabbi to @morlandin

---

Hi Massimo,

 

I am upgrading from 5.6.1.

At the first try I just opened the workspace used with 5.6.1 (assuming this would not be a problem). As soon as 6.0.0 was started, every data adapter except the 2 standard ones (empty, sampleDB) was gone. I did not consider that as an issue and created a new XML data adapter, but using it gave the error above.

 

For the screencast, I think there is an issue with the link (as already reported by Michael Schmid).

 

I now tried it with a completely new workspace: I created a new folder and switched to it in JSS 6.0.0 (using "switch workspace" command). Then I did the following:

Create Data Adapter (in Repositories view) >> XML document >> choose a valid XML file >> push "Test" --> error:

java.lang.NullPointerException

at net.sf.jasperreports.data.xml.XmlDataAdapterService.loadDataDocument(XmlDataAdapterService.java:169)

at net.sf.jasperreports.data.xml.XmlDataAdapterService.contributeParameters(XmlDataAdapterService.java:90)

at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:129)

at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:165)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

 

So I cannot even create a new XML data adapter in JSS 6.0.0.

 

The folder ...workspace_jaspersoft_jss6\.metadata\.plugins\com.jaspersoft.studio contains to sub-folders:

1) "serverprofiles" is empty

2) "dataAdapters" contains 2 files reflecting the above mentioned standard data adapters

This seems perfect for me because I did not save the new data adapter after the failed test.

 

The file "...workspace_jaspersoft_jss6\.metadata\.log" contains this:

!SESSION 2014-12-02 07:17:57.363 -----------------------------------------------

eclipse.buildId=unknown

java.version=1.7.0_67

java.vendor=Oracle Corporation

BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_GB

Command-line arguments: -os win32 -ws win32 -arch x86_64 -data @noDefault

 

!ENTRY com.jaspersoft.studio 1 0 2014-12-02 07:18:00.321

!MESSAGE Starting JaspersoftStudio bundle - Version: 6.0.0.final

 

!ENTRY org.eclipse.equinox.p2.metadata.repository 4 1000 2014-12-02 07:18:19.495

!MESSAGE No repository found at http://jasperstudio.sf.net/jssproductrepo_5_1_x_CE/.

 

I hope this helps. Please tell me if you need more information.

Thanks for your support.

Hi,

 

here are the contents of my JaspersoftWorkspace directories - it's the complete workspace directory.

 

The one is the newly created one by JSS 6.0.0, immediately after installation on first start. (JaspersoftWorkspaceAfterInstallation.zip)

The second one is after i created a XML data adapter in the Repository - after a restart of JSS this data adapter is still there, OK. (JaspersoftWorkspaceWithXMLDataAdapter.zip)

 

But when i try to click on the Test button, i get:

 

java.lang.NullPointerException

at net.sf.jasperreports.data.xml.XmlDataAdapterService.loadDataDocument(XmlDataAdapterService.java:169)

at net.sf.jasperreports.data.xml.XmlDataAdapterService.contributeParameters(XmlDataAdapterService.java:90)

at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:129)

at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:165)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

 

 

Hi guys,

I've fixed my screencast URL in the previous comment. It is:

 

We will look into the attached workspaces to see if there is something strange. Indeed problems with data adapters disappearing are related to the issue mentioned above (#3977). There was a refactor in the way data adapters (and server profiles) were stored and handled.

What I'm trying to figure out here is why there is this NullPointerException in the JR code. I will try to involve also the JR team in order to understand which can be the possible cause of this behavior.

 

After looking at my screenshot can you guys please try to reproduce the same steps and verify if you have the error?

Plus just in case attach the XML file you are using. Is it a valid one?

 

Thanks,

Massimo.

 

P.S: for my example screencast I used the Northwind.xml data file take directly from the JasperReports samples. For the sake of simplicity I've attached it here.

Hi Massimo,

 

thanks for the corrected screencast link.

After checking it I tried again with the provided Northwind link. I did the data adpater creation exactly as shown in the link but I still get the NullPointerException when I test it.

I am sure that the error is not to a malformed XML file (I also checked my example).

 

By the way:

I think it's a pity that the standard workspace is saved only once. IMHO it would be better to save the standard workspace per JSS version. But that's off topic.

Hi there,

 

I did a little Research and created a little test case in a simple Java class. Here is it:

 

package test;

 

import net.sf.jasperreports.data.xml.XmlDataAdapter;

import net.sf.jasperreports.data.xml.XmlDataAdapterImpl;

import net.sf.jasperreports.data.xml.XmlDataAdapterService;

import net.sf.jasperreports.engine.DefaultJasperReportsContext;

import net.sf.jasperreports.engine.JasperReportsContext;

import net.sf.jasperreports.engine.util.LocalJasperReportsContext;

 

public class XmlDataAdapterTest {

 

public static void main(String[] args) {

System.out.println("Starting...");

XmlDataAdapter da = new XmlDataAdapterImpl();

da.setFileName("C:\\Dokumente und Einstellungen\\Administrator\\Eigene Dateien\\Reports\\department_overview.xml");

System.out.println("Creating Context...");

JasperReportsContext djrc = DefaultJasperReportsContext.getInstance();

LocalJasperReportsContext ljrc = new LocalJasperReportsContext(djrc);

XmlDataAdapterService das = new XmlDataAdapterService(ljrc, da);

try {

System.out.println("Testing...");

das.test();

}

catch(Exception e) { e.printStackTrace(System.out); }

}

}

 

This produces in the normal console (System.out) - beside a lot of info message in System.err:

 

Starting...

Creating Context...

Testing...

java.lang.NullPointerException

at net.sf.jasperreports.data.xml.XmlDataAdapterService.loadDataDocument(XmlDataAdapterService.java:169)

at net.sf.jasperreports.data.xml.XmlDataAdapterService.contributeParameters(XmlDataAdapterService.java:90)

at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:129)

at test.XmlDataAdapterTest.main(XmlDataAdapterTest.java:22)

 

A debug trace into the code show that the NPE comes because no factories can be found:

 

Inside the net.sf.jasperreports.data.DataFileResolver.getService method:

 

List factories = context.getExtensions(DataFileServiceFactory.class);

 

No factories seem to be found... That leads then further to the NPE...

So - according to this test case - the problem has nothing to do with the xml data file as such - i'll get exactly the error for exactly the same reason (no factories) when i specify a file that doesn't even exist.

 

Regards,

Michael

Changed Assigned User from @morlandin to @mrabbi

---

It appears that the problem is present in the Community Edition but not in the Professional one. In fact I used that for my initial tests (i.e. registered screencast).Anyhow we have spot the problem causing it. We will fix for the next upcoming release. In the meanwhile you will be able to grab an integration build in the next few days.Keep a look on the bug in order to see when it will be closed.Regards,Massimo.

Hi Massimo and Marco,

 

Thanks for the good news!

I'll observe this bug and will try the new build as soon as it is available.

You'll publish the URL here, or somewhere else?

 

Regards,

Michael

Hello,

good news for the loss of data sources. I would also be interested in the bug link.

Anyway, the NullPointerException is the bigger issue for me (as said: we only have XML file data sources in the current project). How is this issue trated? Is there also a ticket handling the workaorund Marco describes?

The FileNotFountException as said was generated from the class StreamResult, they already have a bug opened for this https://issues.apache.org/jira/browse/XALANJ-2386

We can avoid this bug changing the constructor used to build this class, and in the next version this fix will be included. We also had already a ticket opened for this bug that i closed yesterday due my fix. However the link is: http://community.jaspersoft.com/jaspersoft-studio/issues/3977#comment-809561

I've fixed the bug regarding this exception

 

!ENTRY com.jaspersoft.studio 4 0 2014-11-30 19:47:00.885

!MESSAGE FrameworkEvent ERROR

!STACK 0

java.lang.RuntimeException: javax.xml.transform.TransformerException: java.io.FileNotFoundException: C:\Dokumente%20und%20Einstellungen\Administrator\JaspersoftWorkspace\.metadata\.plugins\com.jaspersoft.studio\dataAdapters\dataAdapter_3 (Das System kann den angegebenen Pfad nicht finden)

 

unfortunately it's not related to the NullPointerException. However this was a bug of javax.xml.transform.stream.StreamResult, so not directly related to JSS, but i've found a workaround to it.

I guess you mean the NullPointerException, not the FileNotFoundException? If not, what about the NullPointerException fix?

Sorry if I confuse things, but currently, I am confused for myself.

I was talking about the FileNotFountException that was raised in the second half of post #12. For the null pointer exception on the Test we still working on it and when there will be news we will post them here.

Changed Resolution from Open to Fixed

Changed Status from Assigned to Resolved

---

Hi all, I've committed the fix for the bug. You guys will be able to grab a new integration build directly from here: https://sourceforge.net/projects/jasperstudio/files/beta-release/It should be published by the end of the day, keep an eye on the above link.Regards,Massimo.P.S: let us know if the problem is not solved, and just in case re-open the bug.

@morlandin: OK; thanks for clarifying. Sorry, I was mixing up things.

But: is it OK to mark this thread as resolved even if the NullPointerException (from the thread description) is not fixed? Will you anyway work on a resolved issue?

I've resolved the FileNotFountException and Massimo (mrabbi) resolved the other one (post #20), for this reason it was marked as resolved

OK, great. That was not clear to me.

Thanks.

I've just uploaded the Integration build of JSS here: https://sourceforge.net/projects/jasperstudio/files/beta-release/

 

Regards,

Massimo.

Hi Massimo,

 

I just tested the 6.0.1 version - good news: the NPE is gone and i can use the XML data adapters.

Bad news: i'm using user function and i seem to be affected by issue 3972.

I get strange ClassNotFoundException. It says that it can't find net.sf.jasperreports.functions.AbstractFunctionSupport.

 

Regards, Michael