crax

I've been trying to create a jar file to perfom what was in that older thread you posted, but I can't ever get it to work. I created a SQLUtils.java file in a text editor. Ran javac to compile it and it created a SQLUtils.class file for me. Ran jar cf SQLUtils.jar SQLUtils.class to make it a jar file and that seemed to work fine. I then added the path to the jar file in ireport from tools>options and have also put it on the report server in WEB-INF/LIB Anytime I run the report on the server or in ireport I get these errors: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. SQLUtils cannot be resolved value = (java.lang.String)(SQLUtils.enumerate(((java.util.Collection)parameter_Sites.getValue()), true));//$JR_EXPR_ID=0$ <------> 2. SQLUtils cannot be resolved value = (java.lang.String)(SQLUtils.enumerate(((java.util.Collection)parameter_Sites.getValue()), true));//$JR_EXPR_ID=0$ <------> 3. SQLUtils cannot be resolved value = (java.lang.String)(SQLUtils.enumerate(((java.util.Collection)parameter_Sites.getValue()), true));//$JR_EXPR_ID=0$ <------> 3 errorsnet.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:1. SQLUtils cannot be resolved value = (java.lang.String)(SQLUtils.enumerate(((java.util.Collection)parameter_Sites.getValue()), true));//$JR_EXPR_ID=0$ <------>2. SQLUtils cannot be resolved value = (java.lang.String)(SQLUtils.enumerate(((java.util.Collection)parameter_Sites.getValue()), true));//$JR_EXPR_ID=0$ <------>3. SQLUtils cannot be resolved value = (java.lang.String)(SQLUtils.enumerate(((java.util.Collection)parameter_Sites.getValue()), true));//$JR_EXPR_ID=0$ <------>3 errors Post Edited by Glen Ki at 01/20/09 19:26

Is there a reason you are using odbc and not the jdbc drivers for mssql? While those drivers have issues, it is possible and I have had them working on a few different setups with sql authentication. I'm using JDBC driver: com.microsoft.sqlserver.jdbc.SQLServerDriver JDBC url: jdbc:sqlserver://sqlservername;DatabaseName=dbname I've had issues with the 2.0 ctp mssql drivers, but have had good luck with the 1.2 released ones, which you can find here: http://www.microsoft.com/downloads/details.aspx?FamilyID=c47053eb-3b64-4794-950d-81e1ec91c1ba&DisplayLang=en after you get the drivers, you will need to put them in the right place for ireport to use which might vary depending on the ireport version. You will also need to put them out on your server as well Post Edited by Glen Ki at 11/14/08 16:27 Post Edited by Glen Ki at 11/14/08 16:29

Is there a way I can localize the Display name link and description of the report that appears on the explorer screen? I've localized the fields of the report with two .properties files(_en_US and _ja) and that works fine, but I woud like the acutal name of the report in jasperserver to be different depending on the locale chosen when the user logs on.

I actually have this same problem when using 3.1.2 of ireport. I DON'T have this problem when using 3.1.1 of ireport. Pretty frustrating!

Mine don't actually have a chart. I don't know if 3.1.1 converts the report in someway when it saves it, but I can do the following: I open a 3.0 report in 3.1.1. I Make a few edits and I can preview the report just fine with or without an active datasource. If I save and close the report and then reopen it, I get that Invalid byte 1 of 1-byte error which prevents me from doing anything with the report. I don't know if this is something to do with the saving or what as I can open any 3.0 created reports and preview them just finee. The problems all arise once I save them.

Actually, I can create brand new reports and new report units from 3.1.1 and it does seem to work. However, if I open a report created in 3.0, edit it and then save it and reopen it, I get the Invalid byte 1 of 1-byte UTF-8 sequence or if I upload it to the reportserver, I get that same error as well.

I have been using jasperserver 3.0.0 with ireport 3.0 and everything has mostly worked fine. I just installed ireport 3.1.1 and when trying to send a report up to the server through the repository navigator, I get an error when adding a new report: Error: com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Invalid byte 1 of 1-byte UTF-8 sequence If I open an existing report and modify it, I can update the report on the server by right clicking the Main.jrxml and choosing Replace with current jrxml. Then, when I run the report form the report server, I get the Invalid byte 1 of 1-byte UTF-8 sequence error. Is 3.1.1 not compatible with jasperserver 3.0.0 or is there something else I need to do? I've tried creating a new report from scratch and also using reports originally done in 3.0

Ok, it's possible it just didn't take my change to the tomcat5 service log on initially. I changed both the mysql and tomcat service login to be my domain/username and restarted both services. Everything is working now. Thanks a lot for the initial guidance tkavanagh

Well, it appears to be a authentication issue completely. It looks like it's trying to log in to the mssql server as domain/machine name. I changed the tomcat service to be run as my login and not the local system account, so not sure why it's passing what it is to the mssql server.

Upon further inspection of the logs, it looks like it has to do with Microsoft SQL Server integrated authentication failing when tomcat and mysql are started as a service. When I start MYSQL and Tomcat as a service, the Sample Reports all run fine but my MSSQL reports using windows authentication all fail to connect. When I start via the allctl.bat, all my reports work fine. Both sample reports and my MSSQL reports. Does the allctl.bat load up some files that wouldn't get loaded otherwise? The MSSQL with integrated auth requires a jar and a couple dlls to be loaded. I've put them in a bunch of different directories, and like I said, works just great when started with the script.

Looks like it took out my backslashes in those directory locations so just image that these are / Directories are: jasperserver3/apache-tomcat/common/lib and jasperserver3/scripts/lib

I've gotten it to work with sql server 2005 and integrated security on two different machines. On one machine I couldn't get the integrated security to work with jasperserver What I've done is copied the two dll files and the jar file to the ireport/lib directory for using ireport to create them. To make it so it works on jasperserver, I've also copied all three files to [jasper install dir]scriptslib and also into [jasper install dir]apache-tomcatcommonlib I had bad luck with the very latest jdbc driver from microsoft so I have been using the jar with the dlls that are 1.2.2828.100

I've seen this discussed a few times here, but I haven't had any luck getting it going. If I start jasperserver via start>all programs>jasperserver 3.0>jasperserver management>start jasperserver then everything runs fine and my reports work and things seem to be as they should. I've registered tomcat as a service and can also start mysql as a service. If instead of using the start jasperserver shortcut, I start the tomcat service and the mysql service, I can browse to http://localhost:8080/jasperserver/login.html and can login and can see my reports listed. If I click on one of the reports though, they do not work and I get the following error: com.jaspersoft.jasperserver.api.JSexception: jsexception.error.creating.connection Like I said above, everything works fine using the start jasperserver shortcut. I get this error when I have started tomcat and mysql through services. Is there something else I have to start?