eldonlee Posted October 13, 2009 Share Posted October 13, 2009 I have installed JasperServer 3.5 and then I also copied ojdbc14.jar for my oracle db 10g connection.After that, I chose "Start iReport" In start menu of JasperServer 3.5.0 , the window of iReport 3.5.0 was popped up.At the left hand side of the iReport 3.5.0, I could log in the oracle DB through the oracle jdbc driver and see the tables.But, on the right hand side, I would like to create a simple report by following step1 , 2, 3.When I followed the step 1 of "create a database connection" and filled in database JDBC connection option, I could not make a connection to oracle database. Error are as shown below.I am using jasperServer 3.5 free version. Does any people know why I can't make a connection to DB in the steps of creating report while I could connect to DB on the services of database? Please help!!!! ClassNotFoundError!Msg: oracle.jdbc.driver.OracleDriverPossible not found class: oracle.jdbc.driver.OracleDriver...Exception Message: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriverLevel: SEVEREStack Trace:oracle.jdbc.driver.OracleDriver com.jaspersoft.ireport.designer.connection.JDBCConnection.loadDriver(JDBCConnection.java:72) com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:135) com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:456) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:316) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:25) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:271) javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) java.awt.Component.processMouseEvent(Component.java:5488) javax.swing.JComponent.processMouseEvent(JComponent.java:3126) java.awt.Component.processEvent(Component.java:5253) java.awt.Container.processEvent(Container.java:1966) java.awt.Component.dispatchEventImpl(Component.java:3955) java.awt.Container.dispatchEventImpl(Container.java:2024) java.awt.Component.dispatchEvent(Component.java:3803) java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) java.awt.Container.dispatchEventImpl(Container.java:2010) java.awt.Window.dispatchEventImpl(Window.java:1778) java.awt.Component.dispatchEvent(Component.java:3803) java.awt.EventQueue.dispatchEvent(EventQueue.java:463) java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153) java.awt.Dialog$1.run(Dialog.java:517) java.awt.Dialog$2.run(Dialog.java:545) java.security.AccessController.doPrivileged(Native Method) java.awt.Dialog.show(Dialog.java:543) java.awt.Component.show(Component.java:1300) java.awt.Component.setVisible(Component.java:1253) com.jaspersoft.ireport.designer.welcome.QuickStartPanel.jButton1ActionPerformed(QuickStartPanel.java:282) com.jaspersoft.ireport.designer.welcome.QuickStartPanel.access$200(QuickStartPanel.java:37) com.jaspersoft.ireport.designer.welcome.QuickStartPanel$2.actionPerformed(QuickStartPanel.java:111) javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:231) java.awt.Component.processMouseEvent(Component.java:5488) javax.swing.JComponent.processMouseEvent(JComponent.java:3126) java.awt.Component.processEvent(Component.java:5253) java.awt.Container.processEvent(Container.java:1966) java.awt.Component.dispatchEventImpl(Component.java:3955) java.awt.Container.dispatchEventImpl(Container.java:2024) java.awt.Component.dispatchEvent(Component.java:3803) java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) java.awt.Container.dispatchEventImpl(Container.java:2010) java.awt.Window.dispatchEventImpl(Window.java:1778) java.awt.Component.dispatchEvent(Component.java:3803) java.awt.EventQueue.dispatchEvent(EventQueue.java:463) java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) java.awt.EventDispatchThread.run(EventDispatchThread.java:110) Link to comment Share on other sites More sharing options...
ckampshoff Posted October 13, 2009 Share Posted October 13, 2009 Hi eldonlee,have you add the folder or jar into the classpath list of iReport? You'll find this under Options -> iReport -> Classpath. HTHChristina Link to comment Share on other sites More sharing options...
eldonlee Posted October 13, 2009 Author Share Posted October 13, 2009 Dear Christina Could you please elaborate on it in detail? It seems that I don't see any OPTION directories under ireport of jasperserver-3.5.0BTW, I am using jasperserver 3.5 window free version.Please see the screen shot of attachment Please help Link to comment Share on other sites More sharing options...
swood Posted October 13, 2009 Share Posted October 13, 2009 iReport is a separate application from JasperServer. In iReport, you need to add the Oracle JDBC driver JAR into the classpath. See the attached screenshot in iReport. You get to this with Tools -> Options and select the Classpath tab. ShermanJaspersoft Link to comment Share on other sites More sharing options...
eldonlee Posted October 14, 2009 Author Share Posted October 14, 2009 Thank you for your help. I can create a simple report. Questions1) how can I make the report available to end users through their pc?2) what other procedures or configuration should I do?Do you have any pdf or docuemnt which shows me how to use iReport completely and distribute reports to end users ...etc? Link to comment Share on other sites More sharing options...
swood Posted October 17, 2009 Share Posted October 17, 2009 eldonleeWrote: Thank you for your help. I can create a simple report. Questions 1) how can I make the report available to end users through their pc? You can deploythe report to JasperServer and the users can run the report through their browser without iReport. Or JasperServer can be set up to run the report on a scheduled basis, and have the report sent to the users via email as an attachment, or a link back to JasperServer. 2) what other procedures or configuration should I do? Do you have any pdf or docuemnt which shows me how to use iReport completely and distribute reports to end users ...etc? There are iReport and JasperReports Ultimate Guides at http://www.jaspersoft.com/ultimate-guides. You can download and install JasperServer (which comes with an iReport install in it) which has documentation, and an Ultimate Guide too. ShermanJaspersoft Link to comment Share on other sites More sharing options...
eldonlee Posted October 19, 2009 Author Share Posted October 19, 2009 are there any iReport guide free of charge becuase http://www.jaspersoft.com/ultimate-guides. needs to be paid? Link to comment Share on other sites More sharing options...
eldonlee Posted October 19, 2009 Author Share Posted October 19, 2009 I installed jasperserver 3.5 for windows (free version). In the jasperserver 3.5 , I can't find any ultimate guide I just find some guides or pdf attached which does not contain iReport guide . Link to comment Share on other sites More sharing options...
mgeise Posted October 19, 2009 Share Posted October 19, 2009 If you don't want to buy the documentation, I would recommend taking a look at the wiki pages under the iReport documentation. The community contributes tutorials, etc. here. Link to comment Share on other sites More sharing options...
asif_m10 Posted October 21, 2009 Share Posted October 21, 2009 Hi eldonlee,I would suggest you to go through the jasperserver interfaces for creating the report. These are very user friendly interfaces to publish your report to the jasperserver.my understanding is that you are done with creating a .jrxml file. Now your next move will be to publish this to jasperserver.Start with Add Resource Icon > jasper server report on the home page and follow the steps.asif Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now