0004428: "No query executer factory class registered" when opening report
Description
When opening a report with a custom language, iReport does not locate the language correct, issuing the error below. If I enter in the report XML and change the language to SQL, then open the query editor and change the language to sql-mm again, everything works correctly.
-------------
Error loading the report template
Message:
net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: No query executer factory class registered for sql-mm queries.
Level:
SEVERE
Stack Trace:
net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: No query executer factory class registered for sql-mm queries.
net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:239)
net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:222)
net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:210)
com.jaspersoft.ireport.designer.JrxmlLoader.reloadJasperDesign(JrxmlLoader.java:87)
com.jaspersoft.ireport.designer.JrxmlVisualView.run(JrxmlVisualView.java:505)
org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
Error at line 202 char 100: net.sf.jasperreports.engine.JRException: No query executer factory class registered for sql-mm queries.
org.apache.commons.digester.Digester.createSAXException(Digester.java:2919)
org.apache.commons.digester.Digester.createSAXException(Digester.java:2945)
org.apache.commons.digester.Digester.endElement(Digester.java:1133)
net.sf.jasperreports.engine.xml.JRXmlDigester.endElement(JRXmlDigester.java:183)
org.apache.xerces.parsers.AbstractSAXParser.endElement(Unknown Source)
org.apache.xerces.impl.xs.XMLSchemaValidator.endElement(Unknown Source)
org.apache.xerces.impl.dtd.XMLNSDTDValidator.endNamespaceScope(Unknown Source)
org.apache.xerces.impl.dtd.XMLDTDValidator.handleEndElement(Unknown Source)
org.apache.xerces.impl.dtd.XMLDTDValidator.endElement(Unknown Source)
org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanEndElement(Unknown Source)
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(Unknown Source)
org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
org.apache.xerces.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
org.apache.commons.digester.Digester.parse(Digester.java:1647)
net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:235)
net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:222)
net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:210)
com.jaspersoft.ireport.designer.JrxmlLoader.reloadJasperDesign(JrxmlLoader.java:87)
com.jaspersoft.ireport.designer.JrxmlVisualView.run(JrxmlVisualView.java:505)
org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)
-------------
Users voting for this issue (Vote Balance = 1, # Voters = 1)
Relationships
Relationships
Notes
(0008291)
bruce_martin
11/17/2009 21:30
I had a similar/same issue with my own "language" that I define in version 3.6.1. Everything worked in earlier versions of IReports
I could define a report, and save it. The reload would fail.
Also in the report Wizard, everything would work ok up until the finish
Button.
I got around the problem by adding
new Class1()
new class2()
....
new classn()
define_language_to_IReports;
where class1 .. classn are the classes used by my "language"
--------------------------------------------------
I found the problem was a bit different with different versions of Java.
I would guess JasperReports is using a different ClassPath / ClassLoader to that used by IReports
(0008330)
giulio
11/24/2009 14:59
The problem has been fixed. If you get the error, just define the language query executer in Tools->Options->iReport->Query Executers.
You can use the class of an existing language if you don't have one yet.
This was not working well in 3.6.1.
Notes
Issue History
Date Modified
Username
Field
Change
11/17/2009 10:39
asfernandes
New Issue
11/17/2009 10:39
asfernandes
Status
new => assigned
11/17/2009 10:39
asfernandes
Assigned To
=> giulio
11/17/2009 21:18
bruce_martin
Vote Added:
11/17/2009 21:30
bruce_martin
Note Added: 0008291
11/24/2009 14:59
giulio
Note Added: 0008330
11/24/2009 14:59
giulio
Status
assigned => closed
11/24/2009 14:59
giulio
Resolution
open => fixed
11/24/2009 14:59
giulio
version
=> 3.6.1
11/24/2009 14:59
giulio
Fixed in Version
=> 3.6.2
11/24/2009 14:59
giulio
Target Version
=> 3.6.2
Issue History
JasperForge Quotes
"JasperServer is SaaS-enabled, with support for multi-tenant deployments – where multiple organizations, tenants, can share the same server – completely protected from each other."