OFBiz › OFBiz - User

I have an error preparing a report with JasperReport

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

8 messages Options

Rafael Rondon

I have an error preparing a report with JasperReport

All,

I am using OFBIz, and I perform in JasperReport reports, but I get the
following error after you add the libraries and compile the program
"JasperReportsPdfViewHandler.java"

HTTP Status 500 -
------------------------------

*type* Exception report

*message*

*description* *The server encountered an internal error () that prevented it
from fulfilling this request.*

*exception*

javax.servlet.ServletException: Servlet.init() for servlet
ControlServlet threw exception
....

*root cause*

java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/JRDataSource
.....

*note* *The full stack trace of the root cause is available in the Apache
Tomcat/6.0.16 logs.*
------------------------------
Apache Tomcat/6.0.16

Please help me or tell me which designer is best to report them, and if
there is a license that is compatible with Apache 2 is that it can be
distributed with the system. Try BIRT with but is very complicated to put
into operation and the worst is to add the program within OFBIz.

Greetings,

--
Rafael Rondón Montás
Software Developer
Dominican Republic
Cel:. 809-862-2839
email: [hidden email]

Rafael Rondon

Fwd: I have an error preparing a report with JasperReport

Try to prove that brings the two examples in this ordermgr in controller.xml
and presents this error:

java.lang.NullPointerException

And fire this request: https: / / localhost:
8443/ordermgr/control/orderreportjasper.pdf

---------- Forwarded message ----------
From: Rafael Rondon <[hidden email]>
Date: Tue, Jan 20, 2009 at 10:11 PM
Subject: I have an error preparing a report with JasperReport
To: [hidden email]

All,

I am using OFBIz, and I perform in JasperReport reports, but I get the
following error after you add the libraries and compile the program
"JasperReportsPdfViewHandler.java"

HTTP Status 500 -
------------------------------

*type* Exception report

*message*

*description* *The server encountered an internal error () that prevented it
from fulfilling this request.*

*exception*

javax.servlet.ServletException: Servlet.init() for servlet
ControlServlet threw exception

....

*root cause*

java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/JRDataSource
.....

*note* *The full stack trace of the root cause is available in the Apache
Tomcat/6.0.16 logs.*
------------------------------
Apache Tomcat/6.0.16

Please help me or tell me which designer is best to report them, and if
there is a license that is compatible with Apache 2 is that it can be
distributed with the system. Try BIRT with but is very complicated to put
into operation and the worst is to add the program within OFBIz.

Greetings,

--
Rafael Rondón Montás
Software Developer
Dominican Republic
Cel:. 809-862-2839
email: [hidden email]

--
Rafael Rondón Montás
Software Developer
Dominican Republic
Cel:. 809-862-2839
email: [hidden email]

BJ Freeman

Re: Fwd: I have an error preparing a report with JasperReport

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It is best you understand Ofbiz and how it works before attempting a
Jasper report.
The code for jasper reports has been removed since we went to Apache,
since the libraries are not Apache compatible.
you can read the
OPTIONAL_LIBRARIES
in the root of ofbiz.
to get familiar with ofbiz I suggest you start here
http://docs.ofbiz.org/display/OFBIZ/OFBiz+Beginner%27s+Development+Guide+Using+Practice+Application

Rafael Rondon sent the following on 1/20/2009 6:46 PM:

> Try to prove that brings the two examples in this ordermgr in controller.xml
> and presents this error:
>
> java.lang.NullPointerException
>
> And fire this request: https: / / localhost:
> 8443/ordermgr/control/orderreportjasper.pdf
>
>
>
> ---------- Forwarded message ----------
> From: Rafael Rondon <[hidden email]>
> Date: Tue, Jan 20, 2009 at 10:11 PM
> Subject: I have an error preparing a report with JasperReport
> To: [hidden email]
>
>
> All,
>
> I am using OFBIz, and I perform in JasperReport reports, but I get the
> following error after you add the libraries and compile the program
> "JasperReportsPdfViewHandler.java"
>
> HTTP Status 500 -
> ------------------------------
>
> *type* Exception report
>
> *message*
>
> *description* *The server encountered an internal error () that prevented it
> from fulfilling this request.*
>
> *exception*
>
> javax.servlet.ServletException: Servlet.init() for servlet
> ControlServlet threw exception
>
> ....
>
>
> *root cause*
>
> java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/JRDataSource
> .....
>
> *note* *The full stack trace of the root cause is available in the Apache
> Tomcat/6.0.16 logs.*
> ------------------------------
> Apache Tomcat/6.0.16
>
>
>
>
> Please help me or tell me which designer is best to report them, and if
> there is a license that is compatible with Apache 2 is that it can be
> distributed with the system. Try BIRT with but is very complicated to put
> into operation and the worst is to add the program within OFBIz.
>
>
>
> Greetings,
>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJdtnkrP3NbaWWqE4RAuj5AKC6X9PfyWjnbLe3C2gAxG8l0SGpPQCeM+eW
CnVn269PJgZWOtEV+lFC5bQ=
=XPMS
-----END PGP SIGNATURE-----

Rafael Rondon

Re: Fwd: I have an error preparing a report with JasperReport

BJ thank you very much for your help, and I will study hard you sent me the
link, but in fact I buy, and finished reading the book "Apache OFBIz
Development - The Beginner's Tutorial." And I began to implement the
accounting module. In fact I was able to enter new accounts and to create
the period, the beginning balance checking, closed the first period, I
recorded the transactions and posting them. But I do not have many reports
in OFBIz and those who have can only be viewed on screen, besides that they
have no filters, formats and / or the needs required.

I would greatly appreciate if you could give me a light where to start and
what tools are best to make the reports and that both are integrated with
OFBIz, much better than no license problem. I do not know what to believe
that Pentaho has MPL v1.1 license and is compatible with the Apache 2
license, but I do not know where to get information to integrate with OFBIz.

Greetings,

On Wed, Jan 21, 2009 at 4:16 AM, BJ Freeman <[hidden email]> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> It is best you understand Ofbiz and how it works before attempting a
> Jasper report.
> The code for jasper reports has been removed since we went to Apache,
> since the libraries are not Apache compatible.
> you can read the
> OPTIONAL_LIBRARIES
> in the root of ofbiz.
> to get familiar with ofbiz I suggest you start here
>
> http://docs.ofbiz.org/display/OFBIZ/OFBiz+Beginner%27s+Development+Guide+Using+Practice+Application
>
> Rafael Rondon sent the following on 1/20/2009 6:46 PM:
> > Try to prove that brings the two examples in this ordermgr in
> controller.xml
> > and presents this error:
> >
> > java.lang.NullPointerException
> >
> > And fire this request: https: / / localhost:
> > 8443/ordermgr/control/orderreportjasper.pdf
> >
> >
> >
> > ---------- Forwarded message ----------
> > From: Rafael Rondon <[hidden email]>
> > Date: Tue, Jan 20, 2009 at 10:11 PM
> > Subject: I have an error preparing a report with JasperReport
> > To: [hidden email]
> >
> >
> > All,
> >
> > I am using OFBIz, and I perform in JasperReport reports, but I get the
> > following error after you add the libraries and compile the program
> > "JasperReportsPdfViewHandler.java"
> >
> > HTTP Status 500 -
> > ------------------------------
> >
> > *type* Exception report
> >
> > *message*
> >
> > *description* *The server encountered an internal error () that prevented
> it
> > from fulfilling this request.*
> >
> > *exception*
> >
> > javax.servlet.ServletException: Servlet.init() for servlet
> > ControlServlet threw exception
> >
> > ....
> >
> >
> > *root cause*
> >
> > java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/JRDataSource
> > .....
> >
> > *note* *The full stack trace of the root cause is available in the Apache
> > Tomcat/6.0.16 logs.*
> > ------------------------------
> > Apache Tomcat/6.0.16
> >
> >
> >
> >
> > Please help me or tell me which designer is best to report them, and if
> > there is a license that is compatible with Apache 2 is that it can be
> > distributed with the system. Try BIRT with but is very complicated to put
> > into operation and the worst is to add the program within OFBIz.
> >
> >
> >
> > Greetings,
> >
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (MingW32)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>
> iD8DBQFJdtnkrP3NbaWWqE4RAuj5AKC6X9PfyWjnbLe3C2gAxG8l0SGpPQCeM+eW
> CnVn269PJgZWOtEV+lFC5bQ=
> =XPMS
> -----END PGP SIGNATURE-----
>

--
Rafael Rondón Montás
Software Developer
Dominican Republic
Cel:. 809-862-2839
email: [hidden email]

Vince Clark

Re: I have an error preparing a report with JasperReport

I'm going to hi-jack this thread and throw out a related question:

Has anyone integrated a reporting engine like Jasper or Pentaho and used the services and entity engine as the source of data rather than using jdbc and writing queries? For example, I know Jasper Server can use sources like java beans and web services.

----- Original Message -----
From: "Rafael Rondon" <[hidden email]>
To: [hidden email]
Sent: Wednesday, January 21, 2009 12:56:48 PM (GMT-0700) America/Denver
Subject: Re: Fwd: I have an error preparing a report with JasperReport

BJ thank you very much for your help, and I will study hard you sent me the
link, but in fact I buy, and finished reading the book "Apache OFBIz
Development - The Beginner's Tutorial." And I began to implement the
accounting module. In fact I was able to enter new accounts and to create
the period, the beginning balance checking, closed the first period, I
recorded the transactions and posting them. But I do not have many reports
in OFBIz and those who have can only be viewed on screen, besides that they
have no filters, formats and / or the needs required.

I would greatly appreciate if you could give me a light where to start and
what tools are best to make the reports and that both are integrated with
OFBIz, much better than no license problem. I do not know what to believe
that Pentaho has MPL v1.1 license and is compatible with the Apache 2
license, but I do not know where to get information to integrate with OFBIz.

Greetings,

On Wed, Jan 21, 2009 at 4:16 AM, BJ Freeman <[hidden email]> wrote:

--
Rafael Rondón Montás
Software Developer
Dominican Republic
Cel:. 809-862-2839
email: [hidden email]

BJ Freeman

Re: Fwd: I have an error preparing a report with JasperReport

In reply to this post by Rafael Rondon

> BJ thank you very much for your help, and I will study hard you sent me the
> link, but in fact I buy, and finished reading the book "Apache OFBIz
> Development - The Beginner's Tutorial." And I began to implement the
> accounting module. In fact I was able to enter new accounts and to create
> the period, the beginning balance checking, closed the first period, I
> recorded the transactions and posting them. But I do not have many reports
> in OFBIz and those who have can only be viewed on screen, besides that they
> have no filters, formats and / or the needs required.
>
> I would greatly appreciate if you could give me a light where to start and
> what tools are best to make the reports and that both are integrated with
> OFBIz, much better than no license problem. I do not know what to believe
> that Pentaho has MPL v1.1 license and is compatible with the Apache 2
> license, but I do not know where to get information to integrate with OFBIz.
>
> Greetings,
>
>
>
> On Wed, Jan 21, 2009 at 4:16 AM, BJ Freeman <[hidden email]> wrote:
>
> It is best you understand Ofbiz and how it works before attempting a
> Jasper report.
> The code for jasper reports has been removed since we went to Apache,
> since the libraries are not Apache compatible.
> you can read the
> OPTIONAL_LIBRARIES
> in the root of ofbiz.
> to get familiar with ofbiz I suggest you start here
>
> http://docs.ofbiz.org/display/OFBIZ/OFBiz+Beginner%27s+Development+Guide+Using+Practice+Application
>
> Rafael Rondon sent the following on 1/20/2009 6:46 PM:
>>>> Try to prove that brings the two examples in this ordermgr in
> controller.xml
>>>> and presents this error:
>>>>
>>>> java.lang.NullPointerException
>>>>
>>>> And fire this request: https: / / localhost:
>>>> 8443/ordermgr/control/orderreportjasper.pdf
>>>>
>>>>
>>>>
>>>> ---------- Forwarded message ----------
>>>> From: Rafael Rondon <[hidden email]>
>>>> Date: Tue, Jan 20, 2009 at 10:11 PM
>>>> Subject: I have an error preparing a report with JasperReport
>>>> To: [hidden email]
>>>>
>>>>
>>>> All,
>>>>
>>>> I am using OFBIz, and I perform in JasperReport reports, but I get the
>>>> following error after you add the libraries and compile the program
>>>> "JasperReportsPdfViewHandler.java"
>>>>
>>>> HTTP Status 500 -
>>>> ------------------------------
>>>>
>>>> *type* Exception report
>>>>
>>>> *message*
>>>>
>>>> *description* *The server encountered an internal error () that prevented
> it
>>>> from fulfilling this request.*
>>>>
>>>> *exception*
>>>>
>>>> javax.servlet.ServletException: Servlet.init() for servlet
>>>> ControlServlet threw exception
>>>>
>>>> ....
>>>>
>>>>
>>>> *root cause*
>>>>
>>>> java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/JRDataSource
>>>> .....
>>>>
>>>> *note* *The full stack trace of the root cause is available in the Apache
>>>> Tomcat/6.0.16 logs.*
>>>> ------------------------------
>>>> Apache Tomcat/6.0.16
>>>>
>>>>
>>>>
>>>>
>>>> Please help me or tell me which designer is best to report them, and if
>>>> there is a license that is compatible with Apache 2 is that it can be
>>>> distributed with the system. Try BIRT with but is very complicated to put
>>>> into operation and the worst is to add the program within OFBIz.
>>>>
>>>>
>>>>
>>>> Greetings,
>>>>
>>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJd6hxrP3NbaWWqE4RAtShAKCngeCwxv4KRt4+z+PNnhloMGd73wCgskFO
+JSQK5djRc4Fc//QLrhdGNY=
=q9wc
-----END PGP SIGNATURE-----

BJ Freeman

Re: I have an error preparing a report with JasperReport

In reply to this post by Vince Clark

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

if you go back to the ver 3.0 it has a working example
also same reference OPTIONAL_LIBRARIES

Vince M. Clark sent the following on 1/21/2009 12:50 PM:

> I'm going to hi-jack this thread and throw out a related question:
>
> Has anyone integrated a reporting engine like Jasper or Pentaho and used the services and entity engine as the source of data rather than using jdbc and writing queries? For example, I know Jasper Server can use sources like java beans and web services.
>
> ----- Original Message -----
> From: "Rafael Rondon" <[hidden email]>
> To: [hidden email]
> Sent: Wednesday, January 21, 2009 12:56:48 PM (GMT-0700) America/Denver
> Subject: Re: Fwd: I have an error preparing a report with JasperReport
>
> BJ thank you very much for your help, and I will study hard you sent me the
> link, but in fact I buy, and finished reading the book "Apache OFBIz
> Development - The Beginner's Tutorial." And I began to implement the
> accounting module. In fact I was able to enter new accounts and to create
> the period, the beginning balance checking, closed the first period, I
> recorded the transactions and posting them. But I do not have many reports
> in OFBIz and those who have can only be viewed on screen, besides that they
> have no filters, formats and / or the needs required.
>
> I would greatly appreciate if you could give me a light where to start and
> what tools are best to make the reports and that both are integrated with
> OFBIz, much better than no license problem. I do not know what to believe
> that Pentaho has MPL v1.1 license and is compatible with the Apache 2
> license, but I do not know where to get information to integrate with OFBIz.
>
> Greetings,
>
>
>
> On Wed, Jan 21, 2009 at 4:16 AM, BJ Freeman <[hidden email]> wrote:
>
> It is best you understand Ofbiz and how it works before attempting a
> Jasper report.
> The code for jasper reports has been removed since we went to Apache,
> since the libraries are not Apache compatible.
> you can read the
> OPTIONAL_LIBRARIES
> in the root of ofbiz.
> to get familiar with ofbiz I suggest you start here
>
> http://docs.ofbiz.org/display/OFBIZ/OFBiz+Beginner%27s+Development+Guide+Using+Practice+Application
>
> Rafael Rondon sent the following on 1/20/2009 6:46 PM:
>>>> Try to prove that brings the two examples in this ordermgr in
> controller.xml
>>>> and presents this error:
>>>>
>>>> java.lang.NullPointerException
>>>>
>>>> And fire this request: https: / / localhost:
>>>> 8443/ordermgr/control/orderreportjasper.pdf
>>>>
>>>>
>>>>
>>>> ---------- Forwarded message ----------
>>>> From: Rafael Rondon <[hidden email]>
>>>> Date: Tue, Jan 20, 2009 at 10:11 PM
>>>> Subject: I have an error preparing a report with JasperReport
>>>> To: [hidden email]
>>>>
>>>>
>>>> All,
>>>>
>>>> I am using OFBIz, and I perform in JasperReport reports, but I get the
>>>> following error after you add the libraries and compile the program
>>>> "JasperReportsPdfViewHandler.java"
>>>>
>>>> HTTP Status 500 -
>>>> ------------------------------
>>>>
>>>> *type* Exception report
>>>>
>>>> *message*
>>>>
>>>> *description* *The server encountered an internal error () that prevented
> it
>>>> from fulfilling this request.*
>>>>
>>>> *exception*
>>>>
>>>> javax.servlet.ServletException: Servlet.init() for servlet
>>>> ControlServlet threw exception
>>>>
>>>> ....
>>>>
>>>>
>>>> *root cause*
>>>>
>>>> java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/JRDataSource
>>>> .....
>>>>
>>>> *note* *The full stack trace of the root cause is available in the Apache
>>>> Tomcat/6.0.16 logs.*
>>>> ------------------------------
>>>> Apache Tomcat/6.0.16
>>>>
>>>>
>>>>
>>>>
>>>> Please help me or tell me which designer is best to report them, and if
>>>> there is a license that is compatible with Apache 2 is that it can be
>>>> distributed with the system. Try BIRT with but is very complicated to put
>>>> into operation and the worst is to add the program within OFBIz.
>>>>
>>>>
>>>>
>>>> Greetings,
>>>>
>>

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJd6lFrP3NbaWWqE4RAgLOAJ4h1WENkzoEoTQRvka9Bmsv6WtpJgCgj2Ko
8u5v1WLw9EbTH/aZ2pnHG6c=
=QL3x
-----END PGP SIGNATURE-----

David E Jones-3

Re: I have an error preparing a report with JasperReport

In reply to this post by Vince Clark

There are actually a few classes already in OFBiz that do this. They
aren't enabled by default because of library licensing problems, so
see the OPTIONAL_LIBRARIES file (as BJ mentioned).

There are 4 classes for this in OFBiz, they are in the
"org.ofbiz.webapp.view" package and are named
"JasperReports*ViewHandler.java".

-David

On Jan 21, 2009, at 1:50 PM, Vince M. Clark wrote:

> I'm going to hi-jack this thread and throw out a related question:
>
> Has anyone integrated a reporting engine like Jasper or Pentaho and
> used the services and entity engine as the source of data rather
> than using jdbc and writing queries? For example, I know Jasper
> Server can use sources like java beans and web services.
>
> ----- Original Message -----
> From: "Rafael Rondon" <[hidden email]>
> To: [hidden email]
> Sent: Wednesday, January 21, 2009 12:56:48 PM (GMT-0700) America/
> Denver
> Subject: Re: Fwd: I have an error preparing a report with JasperReport
>
> BJ thank you very much for your help, and I will study hard you sent
> me the
> link, but in fact I buy, and finished reading the book "Apache OFBIz
> Development - The Beginner's Tutorial." And I began to implement the
> accounting module. In fact I was able to enter new accounts and to
> create
> the period, the beginning balance checking, closed the first period, I
> recorded the transactions and posting them. But I do not have many
> reports
> in OFBIz and those who have can only be viewed on screen, besides
> that they
> have no filters, formats and / or the needs required.
>
> I would greatly appreciate if you could give me a light where to
> start and
> what tools are best to make the reports and that both are integrated
> with
> OFBIz, much better than no license problem. I do not know what to
> believe
> that Pentaho has MPL v1.1 license and is compatible with the Apache 2
> license, but I do not know where to get information to integrate
> with OFBIz.
>
> Greetings,
>
>
>
> On Wed, Jan 21, 2009 at 4:16 AM, BJ Freeman <[hidden email]>
> wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> It is best you understand Ofbiz and how it works before attempting a
>> Jasper report.
>> The code for jasper reports has been removed since we went to Apache,
>> since the libraries are not Apache compatible.
>> you can read the
>> OPTIONAL_LIBRARIES
>> in the root of ofbiz.
>> to get familiar with ofbiz I suggest you start here
>>
>> http://docs.ofbiz.org/display/OFBIZ/OFBiz+Beginner%27s+Development+Guide+Using+Practice+Application
>>
>> Rafael Rondon sent the following on 1/20/2009 6:46 PM:
>>> Try to prove that brings the two examples in this ordermgr in
>> controller.xml
>>> and presents this error:
>>>
>>> java.lang.NullPointerException
>>>
>>> And fire this request: https: / / localhost:
>>> 8443/ordermgr/control/orderreportjasper.pdf
>>>
>>>
>>>
>>> ---------- Forwarded message ----------
>>> From: Rafael Rondon <[hidden email]>
>>> Date: Tue, Jan 20, 2009 at 10:11 PM
>>> Subject: I have an error preparing a report with JasperReport
>>> To: [hidden email]
>>>
>>>
>>> All,
>>>
>>> I am using OFBIz, and I perform in JasperReport reports, but I get
>>> the
>>> following error after you add the libraries and compile the program
>>> "JasperReportsPdfViewHandler.java"
>>>
>>> HTTP Status 500 -
>>> ------------------------------
>>>
>>> *type* Exception report
>>>
>>> *message*
>>>
>>> *description* *The server encountered an internal error () that
>>> prevented
>> it
>>> from fulfilling this request.*
>>>
>>> *exception*
>>>
>>> javax.servlet.ServletException: Servlet.init() for servlet
>>> ControlServlet threw exception
>>>
>>> ....
>>>
>>>
>>> *root cause*
>>>
>>> java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/
>>> JRDataSource
>>> .....
>>>
>>> *note* *The full stack trace of the root cause is available in the
>>> Apache
>>> Tomcat/6.0.16 logs.*
>>> ------------------------------
>>> Apache Tomcat/6.0.16
>>>
>>>
>>>
>>>
>>> Please help me or tell me which designer is best to report them,
>>> and if
>>> there is a license that is compatible with Apache 2 is that it can
>>> be
>>> distributed with the system. Try BIRT with but is very complicated
>>> to put
>>> into operation and the worst is to add the program within OFBIz.
>>>
>>>
>>>
>>> Greetings,
>>>
>> -----BEGIN PGP SIGNATURE-----
>> Version: GnuPG v1.4.6 (MingW32)
>> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
>>
>> iD8DBQFJdtnkrP3NbaWWqE4RAuj5AKC6X9PfyWjnbLe3C2gAxG8l0SGpPQCeM+eW
>> CnVn269PJgZWOtEV+lFC5bQ=
>> =XPMS
>> -----END PGP SIGNATURE-----
>>
>
>
>
> --
> Rafael Rondón Montás
> Software Developer
> Dominican Republic
> Cel:. 809-862-2839
> email: [hidden email]