Jump to content

Changes to the Jaspersoft community edition download ×

conect to iseries

iReport Designer

ILEMax

By ILEMax
March 11, 2008 in Products

Share

Recommended Posts

ILEMax

Rookie

ILEMax

Posted March 11, 2008

- Share

Posted March 11, 2008

Hi *all

i want to test jasper / iReport

I have download the windows installer for ireport

and run it. Than i have register me.

now i try to connect to an iseries.

JDBC driver: COM.ibm.db2.jdbc.app.DB2Driver

(from the list behind this field)

JDBC URL: jdbc:db2:

server adress : xxx.xxx.xxx.xxx (real IP)

database : qsys.lib/mylib.lib/myfile.file

(and, as a try and error way, /myfile.mbr)

User and password

and press test connection:

I get an nearby emty window with a red cross.

when i press detail i get:

Exception

Message:

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

Level:

SEVERE

Stack Trace:

it.businesslogic.ireport.connection.DriverPool.registerDriver(DriverPool.java:155)

it.businesslogic.ireport.connection.JDBCConnection.getConnection(JDBCConnection.java:90)

it.businesslogic.ireport.connection.JDBCConnection.test(JDBCConnection.java:404)

it.businesslogic.ireport.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:322)

it.businesslogic.ireport.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:24)

it.businesslogic.ireport.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:274)

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)

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)

it.businesslogic.ireport.gui.ConnectionsDialog.jButtonModifyParameterActionPerformed(ConnectionsDialog.java:514)

it.businesslogic.ireport.gui.ConnectionsDialog.access$300(ConnectionsDialog.java:53)

it.businesslogic.ireport.gui.ConnectionsDialog$7.actionPerformed(ConnectionsDialog.java:232)

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)

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)

it.businesslogic.ireport.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:623)

it.businesslogic.ireport.gui.MainFrame.jMenuItemConnectionsActionPerformed(MainFrame.java:6471)

it.businesslogic.ireport.gui.MainFrame.access$13800(MainFrame.java:101)

it.businesslogic.ireport.gui.MainFrame$175.actionPerformed(MainFrame.java:3760)

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)

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)

I am very sorry, but i am an as400 coder, i do not know anythink about JAVA

Please give me a detailed 'mini Howto'

to get the connection

thank you very mutch

regards

ILEMax

Link to comment

Share on other sites

Top Posters In This Topic

3
2

Popular Days

Top Posters In This Topic

ILEMax 3 posts
pumaking 2 posts

Popular Days

pumaking

Enthusiast

pumaking

Posted March 12, 2008

- Share

Posted March 12, 2008

I had the same problem before and solved it that way:

First you have to copy the jt400.jar file from your iseries access installation into the ireport/lib folder.

Then you have to add the jt400.jar in Ireport in Options/Classpath.

Then you create the datasource and type in the jdbc driver field:

com.ibm.as400.access.AS400JDBCDriver

You can fill the other fields with the assistant. That's it.

Link to comment

Share on other sites

ILEMax

Rookie

ILEMax

Posted March 12, 2008

Author

- Share

Posted March 12, 2008

Thank's a lot,

that works but ...

I could use the assistant, when i press the button, nothing happen.

i have the driver, you wrote to me and the URL:

jdbc:db2://xxx.x.xx.x/qsys.lib/mylib.lib/myfile.file

(with and without /mymbr.mbr)

Test ask the Passwort and than i get :

Exception

Message:

java.lang.NullPointerException

Level:

SEVERE

Stack Trace:

it.businesslogic.ireport.connection.JDBCConnection.getConnection(JDBCConnection.java:105)

it.businesslogic.ireport.connection.JDBCConnection.test(JDBCConnection.java:404)

it.businesslogic.ireport.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:322)

it.businesslogic.ireport.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:24)

it.businesslogic.ireport.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:274)

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)

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)

it.businesslogic.ireport.gui.ConnectionsDialog.jButtonNewParameterActionPerformed(ConnectionsDialog.java:550)

it.businesslogic.ireport.gui.ConnectionsDialog.access$200(ConnectionsDialog.java:53)

it.businesslogic.ireport.gui.ConnectionsDialog$6.actionPerformed(ConnectionsDialog.java:216)

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)

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)

it.businesslogic.ireport.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:623)

it.businesslogic.ireport.gui.MainFrame.jMenuItemConnectionsActionPerformed(MainFrame.java:6471)

it.businesslogic.ireport.gui.MainFrame.access$13800(MainFrame.java:101)

it.businesslogic.ireport.gui.MainFrame$175.actionPerformed(MainFrame.java:3760)

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)

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)

can you help again ?

ILEMax

Post edited by: ILEMax, at: 2008/03/12 13:56

Link to comment

Share on other sites

pumaking

Enthusiast

pumaking

Posted March 12, 2008

- Share

Posted March 12, 2008

Sorry, I forgot to write how to configure the URL. It has to be:

jdbc:as400://IP-Adress or DNSName/lib

Link to comment

Share on other sites

ILEMax

Rookie

ILEMax

Posted March 12, 2008

Author

- Share

Posted March 12, 2008

Jep,

that work fine,

thank you verry much

Max

Link to comment

Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Share

Go to topic listing

×

×

Create New...