Hitachi Vantara Pentaho Community Forums
Results 1 to 11 of 11

Thread: Running JasperReports in Pentaho

  1. #1
    Join Date
    Mar 2007

    Default Running JasperReports in Pentaho

    Hi All,

    I am trying to run a jasperreport (that has been tested and runs well in JasperServer) on Pentaho and it gives me the following error - I have the JDBC driver set and a valid mysql connection parameters set in the xaction.

    Does Jasperreports work in Pentaho 1.7 ?? Any pointers would be appreciated. Attached is the xaction file.

    Error: JasperReport.ERROR_0003 - JDBC driver not specified. (org.pentaho.plugin.jasperreports.JasperReportsComponent)
    Debug: Starting execute of //JasperEmployeeReport.xaction (org.pentaho.core.solution.SolutionEngine)
    Debug: Getting runtime context and data (org.pentaho.core.solution.SolutionEngine)
    Debug: Loading action sequence definition file (org.pentaho.core.solution.SolutionEngine)
    Debug: SolutionRepository.DEBUG_FILE_PATH - getFile path=c:\pentaho\bi-server\pentaho-solutions\JasperEmployeeReport.xaction (org.pentaho.repository.filebased.solution.SolutionRepository)
    Debug: audit: instanceId=dd20970e-72cf-11dd-87fd-6f7a6e227679, objectId=org.pentaho.core.runtime.RuntimeContext, messageType=action_sequence_start (org.pentaho.core.runtime.RuntimeContext)
    Debug: validateComponent validating component JasperReportsComponent (org.pentaho.core.runtime.RuntimeContext)
    Debug: Validating component for action JasperEmployeeReport.xaction (org.pentaho.plugin.jasperreports.JasperReportsComponent)
    Debug: imageUrl is "{0}"getImage?image= (org.pentaho.plugin.jasperreports.JasperReportsComponent)
    Debug: imageDir is "{0}"system/tmp (org.pentaho.plugin.jasperreports.JasperReportsComponent)
    Debug: removeEmptyRows is {0}true (org.pentaho.plugin.jasperreports.JasperReportsComponent)
    Error: JasperReport.ERROR_0003 - JDBC driver not specified. (org.pentaho.plugin.jasperreports.JasperReportsComponent)
    Error: RuntimeContext.ERROR_0006 - Action components do not validate: JasperEmployeeReport.xaction (org.pentaho.core.runtime.RuntimeContext)
    Error: SolutionEngine.ERROR_0006 - Action sequence validation failed (org.pentaho.core.solution.SolutionEngine
    Attached Files Attached Files

  2. #2
    Join Date
    Jul 2007


    Yes, it works. I use standard jndi and pass the connection in the .xaction
    Pedro Alves
    Meet us on ##pentaho, a FreeNode irc channel

  3. #3
    pstoellberger Guest


    I couldn't use JDBC for JasperReports... just JNDI
    I get the same error message like you for JDBC

  4. #4


    Sorry to up this old post but i have the same problem...

    Where do I have to configure the JNDI connection ? in which file ? Because when I create a .xaction file, I don't have jndi connection in the list.

    I use Pentaho 2.0.

    Thanks a lot !

  5. #5
    pstoellberger Guest


    you create the JNDI connection with administration-console :

    you can use that then in the xaction step that renders the jasper report

    btw, as far as i can remember - the jasperreport JAR's are quite outdated in biserver installation. try to search for jasper in this forum. i suggested some libs you should replace in another thread

  6. #6


    Ok thank you for your reply.

    I created my JNDI connection, and now i have another error...
    Erreur : RuntimeContext.ERROR_0012 - [fr_33] ActionDefinition for JasperReportsComponent did not execute successfully (
    I try to do what you did in this post :

    But it doesn't work anymore... can you telle me more about that ?
    For example, in tomcat/common/lib , there are jasper-compiler.jar, jasper-compiler-jdt.jar, jasper-runtime.jar... Do I have to replace these files ? I try to copy jasperreports-3.5.2.jar, jdt-compiler-3.1.1.jar from my directory of iReport to this directory but it doesn't work...
    Do I have to rename these files like the old ?

    I know that I have a lot of question but I would like it works.

    You, Do you succeed in ?


  7. #7
    pstoellberger Guest


    the correct directory where you need to replace the files is: biserver-ce\tomcat\webapps\pentaho\WEB-INF\lib

    e.g jasperreports-2.0.5.jar is in there... which is really old
    try to look for other jar's in your iReport lib directory which have a different version number than the one in web-inf/lib

  8. #8


    ok ok... I had already do that...

    I'm going to try to understand why it doesn't work...

    Thank you.

  9. #9
    pstoellberger Guest


    you can try to increase the logging level in \biserver-ce\tomcat\webapps\pentaho\WEB-INF\classes\log4j.xml so you see more in tomcat\logs\catalina.out or tomcat\bin\pentaho.log

  10. #10



    I don't have more information... just :
    ERROR [org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0.stable.35509
    2009-06-23 15:21:53,115 ERROR [org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent] Error Start: Pentaho Pentaho Platform Engine Core 2.0.0.stable.35509
    2009-06-23 15:21:53,115 ERROR [org.pentaho.platform.plugin.action.jasperreports.JasperReportsComponent] d102c04c-5ff8-11de-bb80-1f589ee7c7ba:COMPONENT:context-26013884-1245763313084:testok.xactionBase.ERROR_0002 - L'exécution du composant à échouée
    The number of error that we can have with Pentaho is crazy... I discover Pentaho for 1 month and I never see so many errors anywhere ! lol

  11. #11


    Here, my xaction file, very simple...
    <?xml version="1.0" encoding="UTF-8"?>
        <description>Empty blank action sequence document</description>  
            <report-definition type="resource"/> 
    If you see an error...

    I add the connection "mysql_test" in the administration console...

    Thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.