Open-Source BI with JasperReports, Part 1
Last Post 02 Jan 2013 01:16 PM by Rita-Lyn Sanders. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Resolved
Dave Hanneman
New Member
New Member
Posts:2

--
27 Dec 2012 02:24 PM

Pete,

JasperReports looks interesting, but I cannot get the i5OS shown in your sample to connect. Here is my JBDC

JDBC Driver   : com.ibm.as400.accessJDBCDriver
JDBC URL      : jdbc:as400:172.24.8.149/rre
Server Address: 172.24.8.149
Database        :     rre
Username    : tcpuser

 

My configuration is:

WIN7 32bit
IBM I Access for Window 6R1 SI31390

It fails with the following:

Exception
 

Message:
    java.lang.ClassNotFoundException: com.ibm.as400.accessJDBCDriver
Level:
    SEVERE
Stack Trace:
com.ibm.as400.accessJDBCDriver
    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(AbstractButton.java:1995)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
    java.awt.Component.processMouseEvent(Component.java:6290)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
    java.awt.Component.processEvent(Component.java:6055)
    java.awt.Container.processEvent(Container.java:2039)
    java.awt.Component.dispatchEventImpl(Component.java:4653)
    java.awt.Container.dispatchEventImpl(Container.java:2097)
    java.awt.Component.dispatchEvent(Component.java:4481)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
    java.awt.Container.dispatchEventImpl(Container.java:2083)
    java.awt.Window.dispatchEventImpl(Window.java:2482)
    java.awt.Component.dispatchEvent(Component.java:4481)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:648)
    java.awt.EventQueue.access$000(EventQueue.java:84)
    java.awt.EventQueue$1.run(EventQueue.java:607)
    java.awt.EventQueue$1.run(EventQueue.java:605)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
    java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
    java.awt.EventQueue$2.run(EventQueue.java:621)
    java.awt.EventQueue$2.run(EventQueue.java:619)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:618)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
    java.awt.Dialog$1.run(Dialog.java:1044)
    java.awt.Dialog$3.run(Dialog.java:1096)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.Dialog.show(Dialog.java:1094)
    java.awt.Component.show(Component.java:1584)
    java.awt.Component.setVisible(Component.java:1536)
    java.awt.Window.setVisible(Window.java:841)
    java.awt.Dialog.setVisible(Dialog.java:984)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.jButtonModifyParameterActionPerformed(ConnectionsDialog.java:540)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.access$500(ConnectionsDialog.java:47)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog$8.actionPerformed(ConnectionsDialog.java:236)
    javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
    java.awt.Component.processMouseEvent(Component.java:6290)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
    java.awt.Component.processEvent(Component.java:6055)
    java.awt.Container.processEvent(Container.java:2039)
    java.awt.Component.dispatchEventImpl(Component.java:4653)
    java.awt.Container.dispatchEventImpl(Container.java:2097)
    java.awt.Component.dispatchEvent(Component.java:4481)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
    java.awt.Container.dispatchEventImpl(Container.java:2083)
    java.awt.Window.dispatchEventImpl(Window.java:2482)
    java.awt.Component.dispatchEvent(Component.java:4481)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:648)
    java.awt.EventQueue.access$000(EventQueue.java:84)
    java.awt.EventQueue$1.run(EventQueue.java:607)
    java.awt.EventQueue$1.run(EventQueue.java:605)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
    java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
    java.awt.EventQueue$2.run(EventQueue.java:621)
    java.awt.EventQueue$2.run(EventQueue.java:619)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:618)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
    java.awt.Dialog$1.run(Dialog.java:1044)
    java.awt.Dialog$3.run(Dialog.java:1096)
    java.security.AccessController.doPrivileged(Native Method)
    java.awt.Dialog.show(Dialog.java:1094)
    java.awt.Component.show(Component.java:1584)
    java.awt.Component.setVisible(Component.java:1536)
    java.awt.Window.setVisible(Window.java:841)
    java.awt.Dialog.setVisible(Dialog.java:984)
    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:651)
    com.jaspersoft.ireport.designer.menu.DatasourcesAction.performAction(DatasourcesAction.java:46)
    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(AbstractButton.java:1995)
    javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
    javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
    javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
    java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
    java.awt.Component.processMouseEvent(Component.java:6290)
    javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
    org.openide.awt.ToolbarButton.processMouseEvent(ToolbarButton.java:61)
    java.awt.Component.processEvent(Component.java:6055)
    java.awt.Container.processEvent(Container.java:2039)
    java.awt.Component.dispatchEventImpl(Component.java:4653)
    java.awt.Container.dispatchEventImpl(Container.java:2097)
    java.awt.Component.dispatchEvent(Component.java:4481)
    java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
    java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
    java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
    java.awt.Container.dispatchEventImpl(Container.java:2083)
    java.awt.Window.dispatchEventImpl(Window.java:2482)
    java.awt.Component.dispatchEvent(Component.java:4481)
    java.awt.EventQueue.dispatchEventImpl(EventQueue.java:648)
    java.awt.EventQueue.access$000(EventQueue.java:84)
    java.awt.EventQueue$1.run(EventQueue.java:607)
    java.awt.EventQueue$1.run(EventQueue.java:605)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
    java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
    java.awt.EventQueue$2.run(EventQueue.java:621)
    java.awt.EventQueue$2.run(EventQueue.java:619)
    java.security.AccessController.doPrivileged(Native Method)
    java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
    java.awt.EventQueue.dispatchEvent(EventQueue.java:618)
    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)
    java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
    java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
    java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
    java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
    java.awt.EventDispatchThread.run(EventDispatchThread.java:122)

 

 

Any ideas?

Dave Hanneman
New Member
New Member
Posts:2

--
27 Dec 2012 02:57 PM

Pete,

 

I found the answer @ http://community.jaspersoft.com/que...ct-iseries

Rita-Lyn Sanders
Editorial Staff Member
Editorial Staff Member
Posts:15

--
02 Jan 2013 01:16 PM

Dave, I'm glad you found the answer. Let us know if you have any other questions :)

-Rita, iPro Developer executive editor

You are not authorized to post a reply.

Acceptable Use Policy