Jump to content
We've recently updated our Privacy Statement, available here ×

mostafacasa

Members
 View Profile  See their activity

  • Posts

    4

  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by mostafacasa

    Integrate jaspereport with php and JDBC connexion to AS400

    in Products

    Posted

    Hello,

    I want to edit report from php using Javabridge with AS400 on server Zend , this is the code that u have foudn in the net for windwos but isnt work on zend ?!

    I have create one report and test it on Jasperreport with JDBC its work fin but i dont know how integrate it on php ?

    Plaise if someone can help me


    NB : I have this version of Javabridge on ZendServer :

     

    JavaBridge Server Enabled
    JavaBridge extension version 3.1.21
    JavaBridge Server Port 10002
    JavaBridge Ints are Longs No
    JavaBridge Encoding UTF-8
    JavaBridge Use Java Objects No

     

    Code:
    <?php               $reportsPath ="/../../Raport/";        $reportFileName = "report1";        $jasperReportsLib = "/../../Raport/";            if(extension_loaded('java')) {                   // lecture du répertoire où sont rengés les librairies utiles à JasperReports            $handle = @opendir($jasperReportsLib);                           // ajout de tous les fichier jar au chemin de classe (Class Path)            while(($new_item = readdir($handle))!==false) {                               $java_library_path .= 'file:'.$jasperReportsLib.'/'.$new_item .';';            }                          try {                // chargement des librairies au classpath                java_require($java_library_path);                       // création de la connexion JDBC                $Conn = new Java("org.altic.jasperReports.JdbcConnection");                // driver                       $Conn->setDriver("sun.jdbc.odbc.JdbcOdbcDriver");                // url de connexion                $Conn->setConnectString("jdbc:odbc:D6075e50");                // utilisateur                $Conn->setUser("mustapha");                // mot de passe                $Conn->setPassword("azerty");                       // Compilation du fichier JRXML en fichier Jasper                       $sJcm = new JavaClass("net.sf.jasperreports.engine.JasperCompileManager");                $report = $sJcm->compileReport($reportsPath .$reportFileName.".jrxml");                       // Remplir le modèle avec les données                       $sJfm = new JavaClass("net.sf.jasperreports.engine.JasperFillManager");                $print = $sJfm->fillReport(                       $report,                new Java("java.util.HashMap"),                $Conn->getConnection()                );                       // Export du fichier au format pdf                $sJem = new JavaClass("net.sf.jasperreports.engine.JasperExportManager");                $sJem->exportReportToPdfFile($print, $reportsPath .$reportFileName.".pdf");                       if (file_exists($reportsPath .$reportFileName.".pdf")){                     header('Content-disposition: attachment; filename="'.$reportFileName.'.pdf"');                     header('Content-Type: application/pdf');                     header('Content-Transfer-Encoding: binary');                     header('Content-Length: '. @filesize($reportsPath . $reportFileName.".pdf"));                     header('Pragma: no-cache');                     header('Cache-Control: must-revalidate, post-check=0, pre-check=0');                     header('Expires: 0');                     set_time_limit(0);                     @readfile($reportsPath .$reportFileName.".pdf") or die("problem occurs.");                 }                   } catch (JavaException $ex) {                 $trace = new Java("java.io.ByteArrayOutputStream");                $ex->printStackTrace(new Java("java.io.PrintStream", $trace));                print "java stack trace: $trace\n";            }        }                      ?>

    Connexion with AS400 ?

    in Products

    Posted

     Hello 

    i want try it with JDBC , i have message error ? that i must install simething else ?

     

    Exception

     

     

    Message:

        java.lang.ClassNotFoundException: COM.ibm.db2.jdbc.app.DB2Driver

    Level:

        SEVERE

    Stack Trace:

    COM.ibm.db2.jdbc.app.DB2Driver

        com.jaspersoft.ireport.designer.connection.JDBCConnection.loadDriver(JDBCConnection.java:63)

        com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:126)

        com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:447)

        com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:335)

        com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:43)

        com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:290)

        javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

        javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

        javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

        javax.swing.DefaultButtonModel.setPressed(Unknown Source)

        javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

        java.awt.Component.processMouseEvent(Unknown Source)

        javax.swing.JComponent.processMouseEvent(Unknown Source)

        java.awt.Component.processEvent(Unknown Source)

        java.awt.Container.processEvent(Unknown Source)

        java.awt.Component.dispatchEventImpl(Unknown Source)

        java.awt.Container.dispatchEventImpl(Unknown Source)

        java.awt.Component.dispatchEvent(Unknown Source)

        java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

        java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

        java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

        java.awt.Container.dispatchEventImpl(Unknown Source)

        java.awt.Window.dispatchEventImpl(Unknown Source)

        java.awt.Component.dispatchEvent(Unknown Source)

        java.awt.EventQueue.dispatchEvent(Unknown Source)

        org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)

        java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

        java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

        java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

        java.awt.Dialog$1.run(Unknown Source)

        java.awt.Dialog$3.run(Unknown Source)

        java.security.AccessController.doPrivileged(Native Method)

        java.awt.Dialog.show(Unknown Source)

        java.awt.Component.show(Unknown Source)

        java.awt.Component.setVisible(Unknown Source)

        java.awt.Window.setVisible(Unknown Source)

        java.awt.Dialog.setVisible(Unknown Source)

        com.jaspersoft.ireport.designer.wizards.ConnectionSelectionVisualPanel.jButton1ActionPerformed(ConnectionSelectionVisualPanel.java:318)

        com.jaspersoft.ireport.designer.wizards.ConnectionSelectionVisualPanel.access$400(ConnectionSelectionVisualPanel.java:41)

        com.jaspersoft.ireport.designer.wizards.ConnectionSelectionVisualPanel$6.actionPerformed(ConnectionSelectionVisualPanel.java:226)

        javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

        javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

        javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

        javax.swing.DefaultButtonModel.setPressed(Unknown Source)

        javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

        java.awt.Component.processMouseEvent(Unknown Source)

        javax.swing.JComponent.processMouseEvent(Unknown Source)

        java.awt.Component.processEvent(Unknown Source)

        java.awt.Container.processEvent(Unknown Source)

        java.awt.Component.dispatchEventImpl(Unknown Source)

        java.awt.Container.dispatchEventImpl(Unknown Source)

        java.awt.Component.dispatchEvent(Unknown Source)

        java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

        java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

        java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

        java.awt.Container.dispatchEventImpl(Unknown Source)

        java.awt.Window.dispatchEventImpl(Unknown Source)

        java.awt.Component.dispatchEvent(Unknown Source)

        java.awt.EventQueue.dispatchEvent(Unknown Source)

        org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)

        java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

        java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

        java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

        java.awt.Dialog$1.run(Unknown Source)

        java.awt.Dialog$3.run(Unknown Source)

        java.security.AccessController.doPrivileged(Native Method)

        java.awt.Dialog.show(Unknown Source)

        org.netbeans.core.windows.services.NbPresenter.superShow(NbPresenter.java:867)

        org.netbeans.core.windows.services.NbPresenter.doShow(NbPresenter.java:901)

        org.netbeans.core.windows.services.NbPresenter.run(NbPresenter.java:889)

        org.netbeans.core.windows.services.NbPresenter.run(NbPresenter.java:109)

        org.openide.util.Mutex.doEventAccess(Mutex.java:1355)

        org.openide.util.Mutex.readAccess(Mutex.java:268)

        org.netbeans.core.windows.services.NbPresenter.show(NbPresenter.java:874)

        java.awt.Component.show(Unknown Source)

        java.awt.Component.setVisible(Unknown Source)

        java.awt.Window.setVisible(Unknown Source)

        java.awt.Dialog.setVisible(Unknown Source)

        com.jaspersoft.ireport.designer.templates.TemplatesFrame.runTemplateWizard(TemplatesFrame.java:465)

        com.jaspersoft.ireport.designer.templates.ReportTemplateItemAction.performAction(ReportTemplateItemAction.java:50)

        com.jaspersoft.ireport.designer.templates.TemplatesFrame.jButtonLaunchWizardActionPerformed(TemplatesFrame.java:328)

        com.jaspersoft.ireport.designer.templates.TemplatesFrame.access$700(TemplatesFrame.java:55)

        com.jaspersoft.ireport.designer.templates.TemplatesFrame$10.actionPerformed(TemplatesFrame.java:244)

        javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

        javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

        javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

        javax.swing.DefaultButtonModel.setPressed(Unknown Source)

        javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)

        java.awt.Component.processMouseEvent(Unknown Source)

        javax.swing.JComponent.processMouseEvent(Unknown Source)

        java.awt.Component.processEvent(Unknown Source)

        java.awt.Container.processEvent(Unknown Source)

        java.awt.Component.dispatchEventImpl(Unknown Source)

        java.awt.Container.dispatchEventImpl(Unknown Source)

        java.awt.Component.dispatchEvent(Unknown Source)

        java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

        java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

        java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

        java.awt.Container.dispatchEventImpl(Unknown Source)

        java.awt.Window.dispatchEventImpl(Unknown Source)

        java.awt.Component.dispatchEvent(Unknown Source)

        java.awt.EventQueue.dispatchEvent(Unknown Source)

        org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)

        java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

        java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

        java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

        java.awt.Dialog$1.run(Unknown Source)

        java.awt.Dialog$3.run(Unknown Source)

        java.security.AccessController.doPrivileged(Native Method)

        java.awt.Dialog.show(Unknown Source)

        java.awt.Component.show(Unknown Source)

        java.awt.Component.setVisible(Unknown Source)

        java.awt.Window.setVisible(Unknown Source)

        java.awt.Dialog.setVisible(Unknown Source)

        com.jaspersoft.ireport.designer.templates.TemplatesFrame.setVisible(TemplatesFrame.java:577)

        com.jaspersoft.ireport.designer.standalone.menu.NewReportAction.performAction(NewReportAction.java:200)

        org.openide.util.actions.CallableSystemAction$1.run(CallableSystemAction.java:118)

        org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77)

        org.openide.util.actions.CallableSystemAction.actionPerformed(CallableSystemAction.java:114)

        javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

        javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)

        javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)

        javax.swing.DefaultButtonModel.setPressed(Unknown Source)

        javax.swing.AbstractButton.doClick(Unknown Source)

        javax.swing.plaf.basic.BasicMenuItemUI.doClick(Unknown Source)

        javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(Unknown Source)

        java.awt.Component.processMouseEvent(Unknown Source)

        javax.swing.JComponent.processMouseEvent(Unknown Source)

        java.awt.Component.processEvent(Unknown Source)

        java.awt.Container.processEvent(Unknown Source)

        java.awt.Component.dispatchEventImpl(Unknown Source)

        java.awt.Container.dispatchEventImpl(Unknown Source)

        java.awt.Component.dispatchEvent(Unknown Source)

        java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)

        java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)

        java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)

        java.awt.Container.dispatchEventImpl(Unknown Source)

        java.awt.Window.dispatchEventImpl(Unknown Source)

        java.awt.Component.dispatchEvent(Unknown Source)

        java.awt.EventQueue.dispatchEvent(Unknown Source)

        org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)

        java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)

        java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)

        java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)

        java.awt.EventDispatchThread.pumpEvents(Unknown Source)

        java.awt.EventDispatchThread.pumpEvents(Unknown Source)

        java.awt.EventDispatchThread.run(Unknown Source)

×
×
  • Create New...

© 2024 Cloud Software Group,
Inc. All rights reserved.

Products

Explore