n9yty

I didn't dig much further because I really don't need the sample data, I was happy to get our reports back online and I left it there. :)

Just using the version bundled with the linux installer for mysql. Nothing out of the ordinary and nothing that I put in place manually.

Well, isn't this interesting... Or maybe not. I did a fresh install of version 4.0, and since I wanted the minimal install I did not include the sample set. I then copied my existing jasperserver webapp directory over, and wouldn't you know that everything worked great? So I did yet another clean install, this time doing the sample databases and then moved my jasperserver webapp directory over and the same problem came back. So - I have a third install running without the samples and all is fine. The funny thing is that it would appear all the old sample stuff came over from the converted repository because they are still there. So, it is working now, but I think something is still probably not right with the upgrade process when sample data is installed.

I think the upgrade to 4.0 went OK here. :) I upgraded from 3.5.0 to 3.7.1 to 4.0.0. However, when trying to run reports it just sits there, no output, no errors. Also, if I go in and edit or create a datasource and use the TEST CONNECTION button, I get an exception error. Did something get out of sync during the upgrade process? I did verify that the mysql jar is in the tomcat lib directory, even tried the latest MySQL connector and yet still I get an error testing the JDBC connections. I also find it puzzling that it is referencing a Mondrian class for a JDBC connection, but I don't claim to understand all of the levels involved. org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.ExceptionInInitializerError org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:924) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:511) javax.servlet.http.HttpServlet.service(HttpServlet.java:637) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) . . .root causejava.lang.ExceptionInInitializerError java.lang.Class.forName0(Native Method) java.lang.Class.forName(Class.java:247) java.sql.DriverManager.getCallerClass(DriverManager.java:477) java.sql.DriverManager.getConnection(DriverManager.java:576) java.sql.DriverManager.getConnection(DriverManager.java:185) com.jaspersoft.jasperserver.war.action.DataSourceAction.testJdbcDataSource(DataSourceAction.java:226) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) . . .root causejava.lang.ClassNotFoundException: mondrian.olap4j.FactoryJdbc4Impl org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1516) org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1361) java.lang.Class.forName0(Native Method) java.lang.Class.forName(Class.java:169) mondrian.olap4j.MondrianOlap4jDriver.(MondrianOlap4jDriver.java:91) mondrian.olap4j.MondrianOlap4jDriver.register(MondrianOlap4jDriver.java:111) mondrian.olap4j.MondrianOlap4jDriver.(MondrianOlap4jDriver.java:71) java.lang.Class.forName0(Native Method) java.lang.Class.forName(Class.java:247) java.sql.DriverManager.getCallerClass(DriverManager.java:477) java.sql.DriverManager.getConnection(DriverManager.java:576) java.sql.DriverManager.getConnection(DriverManager.java:185) com.jaspersoft.jasperserver.war.action.DataSourceAction.testJdbcDataSource(DataSourceAction.java:226) . . .

Reposted as a new topic to make it more appropriate, sorry for the confusion. Post Edited by n9yty at 02/23/2011 02:04

I know this question is kind of old, but have a look here: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=6666

Thank you for your great idea! I wish this would be something more automatic, especially if uploading from the plugin in iReport, it seems that it is something that should just be done as the report goes to or from the server rather transparently.

SOLVED Since I could not get the client JDK updated to Sun's, I thought I'd just blow out the tomcat install on the server, as well as it's java, and instead I put in sun's jdk1.6 for general use, but for jasperserver I just downloaded the complete package from sf for linux (mysql, tomcat, java, etc...) and installed that and then configured it to use the jasper database from the prevous install. All seems to be working now with the "Edit" function, except for the report I was working on that started this all... but that is for a separate report, it's no longer a general problem with the function itself. THANKS!!!

As for using the Sun JDK - how does one do that on a Mac OS X system? I am just using the pre-built iReport.app bundle... I tried to find a SUN JDK to install, but they don't provide one, and the OpenBSD's variant has had some work on porting it over, but it looks like it may be a real bit of work to set up and it uses X11 instead of the nice Aqua native interface that the pre-built iReport uses. [i did download the beta1 of openjdk1.6 for osx - and tried the "generic" ireport, but it does while the opening dialog says "loading modules", and I can find no debug output anywhere... It may not be ireport/netbeans at all and rather the openjdk stuff, I don't know. My java knowledge is pretty small. :)] Post Edited by n9yty at 05/20/2009 20:53

When I bring up the contextual menu on a repository item and select open in editor, I get a dialog: Error: ; nested exception is: java.lang.RuntimeException This is on a Mac OS X client system (10.5.7, all latest updates), a freshly downloaded copy of iReport 3.5.1 and a JasperServer 3.5.1 install on a Linux server under Tomcat5. Post Edited by n9yty at 05/18/2009 03:45

Wonderful feature! This AdHoc reporting I saw in the demo is what prompted me to investigate JasperServer/JasperReports/etc... I was very surprised not to see it after I struggled through getting a new minimal slice on our Xen server with the JBoss install and JasperServer. It does seem to be working well, and I have used the plugin for iReport to design test reports against our database and upload them to the server, but I can find nothing about AdHoc reporting. :( Will this AdHoc be available only in JasperProfessional, or will it be available in the communiity/free edition of JasperServer? Best Regards, Steve