problem with stored procedures in 3.0

[leocsantiago]

Hi,

I was using ireport 2.0.4 and i could do my reports without problems.

Now that I just updated to 3.0, if I try to open an old report, I can't compile it anymore.

I need to call stored procedures and the db is Oracle.

In 2.0.4 it was ok, but in 3.0 i get the message:

"net.sf.jasperreports.engine.JRRuntimeException:net.sf.jasperreports.engine.JRException: Class org.jasperforge.jaspersoft.demo.PlSqlQueryExecuterFactory not found."

 

any ideas ?

 

thx,

Leo

[bklawans]

I'd guess that the jar containing the oracle stored procedure query executer didn't get copied into the lib directory of iReport 3.0.

 

-Barry

[kenta25]

I've the same error but... there's only to build the  "oraclestoredprocedure" project and copy the build/class folder to the ireport folder, isn't? I haven't seen any .jar...    my error?

what I've to put into the classpath? (I've only added a new plsql query executers)

[kenta25]

Today I have builded a .jar with the PlSqlQueryExecuter.class and the PlSqlQueryExecuterFactory.class

I've added a jar into the iReport classpath but I've still the following problem...

Do you know what that means?

Code:

Message:    net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Class org.jasperforge.jaspersoft.demo.PlSqlQueryExecuterFactory not found.Level:    SEVEREStack Trace:net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Class org.jasperforge.jaspersoft.demo.PlSqlQueryExecuterFactory not found.    net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:243)    net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:226)    net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:214)    com.jaspersoft.ireport.designer.JrxmlLoader.reloadJasperDesign(JrxmlLoader.java:73)    com.jaspersoft.ireport.designer.JrxmlVisualView.run(JrxmlVisualView.java:499)    org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)    org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)Error at line 5 char 16: net.sf.jasperreports.engine.JRException: Class org.jasperforge.jaspersoft.demo.PlSqlQueryExecuterFactory not found.    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:187)    com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.endElement(AbstractSAXParser.java:633)    com.sun.org.apache.xerces.internal.impl.xs.XMLSchemaValidator.endElement(XMLSchemaValidator.java:818)    com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanEndElement(XMLNSDocumentScannerImpl.java:719)    com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.dispatch(XMLDocumentFragmentScannerImpl.java:1685)    com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:368)    com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:834)    com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:764)    com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:148)    com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1242)    org.apache.commons.digester.Digester.parse(Digester.java:1647)    net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:239)    net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:226)    net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:214)    com.jaspersoft.ireport.designer.JrxmlLoader.reloadJasperDesign(JrxmlLoader.java:73)    com.jaspersoft.ireport.designer.JrxmlVisualView.run(JrxmlVisualView.java:499)    org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)    org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986)

[kenta25]

anything has another idea?

For me it's really important to solve the problem because I use often plsql...