pjamrisk

There is another way to add the drivers to the system itself so it is always available when compiling. Maven, However is a different story. See my FAQ post if you can and please post this answer to help others!

Would you mind Posting this on the FAQ post? I think that way we can all benefit from this answer

Awesome, Thank you for the post. I haven't had a chance to run the updated versium much yet, but something did got fixed since I posted last and it was compiling the reports in eclipse. Besides that it seems to be working now for the most part. Also, thank you for the class path, that definetly did the trick for me as well after your post, so I wanted to reply and let you know. Not many people have posted here, but I hope we can continue making this post grow and keep adding new information to help other individuals.

that sounds like you are not including the sql driver jar into the project. Did you test the connection to the database on the query designer?

did you added the driver to the query manager when you created the new connection? I have mine working, but can't preview the reports now. I had to stop working with it to try other parts of my project at work. But if you have a question, just reply back and send you a couple screenshots of what I did.

Hi everyone, I have been one of those many users always hoping for an eclipse plugin since the demise of the old ireport for eclipse. Anyways, I been creating a Maven project with jasper studio, and Jasper reports for deployment in tomcat and realized that like many others I was not able to find where the palette was, and many other little things like it used to be on ireport or the netbeans plugin. So, I decided to create this post for the most frequently asked questions, to amke it grow, and slowly clean it up so that all of us can patiently and orderly ask questions about this so we can all help each other to learn to use it here on eclipse. Having said that here are the first few FAQ's. 1. Where is the palette? This one took me about a week to find. when you are in the report perspective of eclipse, if you look right next to the ruler, at the very end there is a small arrow pointing to the right. click on it or drag it, and there are all your palette elements back again. I myself think that this should be displayed by default, so everyone can see it first time and don't freak out when it is gone. 2. Where are my Properties? if you do right click on the report perspective you can click on show properties, and this wonderful eclipse tab will appear. I would ask the developers to have the pallete show like the properties honestly. I did not like have the pallete only available inside the report window, and the properties on a separate one like it is here. 3. Where is the query Window? Again, do Right click on the main report window in design mode, and select Datase and Query. Here you can go ahead and create the query statements for your report. Also here you can create the data adapters for the different databases available to you in iReport on the top right corner (big bold NEW button). those 3 questions, seem to be the most asked right now. I believe everything else is getting re-implemented at this time, so I think patience from everyone will make the transition a lot better and faster. But answering this simple questions, I think will help all the newbies on recovering of the shock of not having to use iReport. Now my personal questions right now are: 1. where is the report page that shows variables and Parameters, so we can define those as well as we go.? I know I have not seen them yet, and you basically have to define them on the source code right now. 2. How to define database drivers in non maven projects? I have no clue, if someone does, please post it. Maven you just define the drivers and Studio seemed to work just fine. Patrick.

OK, here is the solution for Ubuntu 10.10 with netbeans 6.8 and 6.9.1, plus iReport, please post here where you find other solutions as well, as this applies on Windows as well. Forget the classes folder, the driver has to be located in this folder to have it working correctly: /usr/lib/jvm/java-6-sun-1.6xxxx/jre/lib/ext (xxx for whatever revision you have). Windows is the same exact place, but wherever you installed your JDK. Mine was in: C:\Program Files\Java\jdk1.6.0_22\jre\lib\ext Make note of this as this will make subreports work with any database. I was able to connect to 2 different databases at the time without any problems. I will try to post this as well on other places for reference and please pass the message as this is happening all around for a lot of people. And I have been one of them for the longest time. Once you have this working, the Deployment on Tomcat is easy. If you configure your netbeans correctly it will deploythe correct database drivers, and you can create your app to generate reports on the fly and dinamically if needed. Thanks for everyone who contributed to this post. Patrick Jamriska TAGS: subreport, Database subreport, java.sql.Connection, java.sql.DriverManager.getConnection, Multiple Database Connection, connection, driver, sql driver.

Ok, Now its my turn. I formatted my machine and changed it to Ubuntu. I tried to drop the jar's and now its not working whatsoever. Tomcat works, but when I try to compile jasper in linux it just crashes. I went to windows and tried the posted solution and nothing, it gives me the same problem, the driver was not found. Does anyone know exactly where do we need to place the jars so iReport or plugin always find the correct driver for compiling the report? this is just very annoying already. Thanks, Patrick

Sorry for the late reply. Yes, that was the way of doing it in windows. You will do something similar in linux, except you copy the driver to the jre installation directory. Now you have to do the same for tomcat 6.0, I don't remember whare the instructions were, but you put in somewhere inside the catalina folder. The next problem I currently have is that I start with a mysql database, go to a mssql database SR, and then I have another sr inside back to mysql. (don't ask....). So I can't run then the subreport because then it does not see the driver. However, I found out that it will execute fine in tomcat, so I just test it separatle and then compile it for deployment. Hope this post helps a lot of people because I am sure lots of us have run on the same situation. Patrick

Guess no one has an answer for this at this time huh. Well, I can think of doing at this time is processing data on an outside script or program then use those resuls to generate separate reports. If anyone else has a better Idea I am all ears. Thanks, Patrick

hello everyone, Is it possible to use a field value as a filter for the main dataset? I have a very large report which I need to drive by a specific dataset that will return several values that I need to use as a filter for the main report. But I don't seem to be able to use this as a filter. Any suggestions? Thanks, Patrick Jamriska

Ok, we figured out here that if we copy the driver.jar to the java jre folder we can now use iReport to run the reports, so that is great in case someone needs this as a fix. The only other difficulty we found is that we do not have the same capability to do it on a tomcat application, at least not yet as of this moment but we are working on it. I will post my solution if we figure it out on tomcat. Patrick Jamriska

Ok, let me ask the question in an easier way. How do you instanciate the driver inside the JRXML to avoid at runtime getting the no driver found error. No one seems to know how to do it. At least not on any single post I have read so far. Thanks for reading the post! Patrick J.

Hi guys, I been working with Jasper for quite a while, and Today I decided to make use of multiple data sources with sub reports. I created the line of report connection in iReport as following (can be edited in the jrxml as well): java.sql.DriverManager.getConnection("jdbc:jtds:sqlserver://servername/db","user","pass"). Also, we added to the classpath of Jasper the jar driver for jtds, and before mssql 3.0. The mssql property changes a bit but it still goes among those lines so I am not going to retype it. Anyways, The first day everything worked like a charm and we were getting multiple database connections. Then we created a new report today and we get a Stack Trace error. Here is the error report So I am getting the dreaded No Suitable driver found a lot of people has been getting on several different posts around the net. Is this a deficiency of the iReport? or what is not being set correctly. Please let me know if you guys require a little more code, but it really is nothing difficult because all we made is a basic report with a subreport connection. Thanks for your time if you have seen it before. Patrick Jamriska PD: I tried to do it as well to mysql which was working before and now it doesn't either. Code: Post Edited by pjamrisk at 07/07/2010 06:25

Anybody please????

Hello experts, I am using Jasper Reports 3.5, and PHP\Javabridge. While doing the implementation of my project and finally use the exportReportToPdfFile, I get this error: java stack trace: java.lang.Exception: Invoke failed: [[c:JasperExportManager]]->exportReportToPdfFile((o:String)[o:String], (o:String)[o:String]). Cause: java.lang.NoSuchMethodError: com.lowagie.text.pdf.PdfWriter.setRgbTransparencyBlending(Z)V VM: 1.5.0_08@http://java.sun.com/ at net.sf.jasperreports.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:455) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:354) at net.sf.jasperreports.engine.JasperExportManager.exportReportToPdfFile(JasperExportManager.java:126) at net.sf.jasperreports.engine.JasperExportManager.exportReportToPdfFile(JasperExportManager.java:103) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at php.java.bridge.JavaBridge.Invoke(JavaBridge.java:1054) at php.java.bridge.Request.handleRequest(Request.java:415) at php.java.bridge.Request.handleRequests(Request.java:491) at php.java.bridge.http.ContextRunner.run(ContextRunner.java:146) at php.java.bridge.ThreadPool$Delegate.run(ThreadPool.java:60) Caused by: java.lang.NoSuchMethodError: com.lowagie.text.pdf.PdfWriter.setRgbTransparencyBlending(Z)V ... 13 more Thinking that it might have been a problem with iText after a lot of reading, I decided to implement the same thing straight into Java. Surprisingly it works flawless in java, but I need to get the implementation for our webpage with PHP and Javascript. Does anyone know why this error is coming up??? it seems to be frequently asked but no answers. thanks, Patrick J. [/code]

Hi Miramon, The example seems simple enough. I did try though to copile the report directly as a jrxml and as the java to idicate the two different sources, and I still get the same problem, where the system is only watching for the first datasource only. But thank you for the reply. I was wondering if someone might also have a way to do this on the netbeans side with Ireport as well, even if it takes to compile the report via java in that sense. Thanks, Patrick

Hello everyone, I have searched and reall all over the forums looking for a consice and simple example on how to create a subreport with a different datasource. The only close thing to this is link in the forum: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=37515 But still I am not able to get the report to not give me an error when compiling, on either JS or Ireport. Can someone provide a simple example or tutorial on how to create this? I am sure a lot of people is looking for this information to set in the reports. Thanks, Patrick

nisha, I got an email from you about the same problem, do you still need help? Patrick

Nevermind, I got it. I was passing the map wrong. Patrick

Well here is an update, I was pointing at the wrong repository and did not notice with my javabridge, and now I have it compiling correctly. However, when the pdf comes out I only get an empty page without the barcode... :( I will keep trying and posting results. If anyone has any idea, let me know. Patrick

Ok, I did get a little better progress. now I am getting the following error: java stack trace: java.lang.Exception: CreateInstance failed: new org.altic.jasperReports.JdbcConnection. Cause: java.lang.ClassNotFoundException: Could not find org.altic.jasperReports.JdbcConnection in java_require() path. Please check the path and the SEL and File permissions. VM: 1.6.0_03@http://java.sun.com/ at php.java.bridge.DynamicJavaBridgeClassLoader.loadClass(DynamicJavaBridgeClassLoader.java:278) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:247) at php.java.bridge.SimpleJavaBridgeClassLoader.forName(SimpleJavaBridgeClassLoader.java:146) at php.java.bridge.JavaBridge.CreateObject(JavaBridge.java:445) at php.java.bridge.Request.handleRequest(Request.java:447) at php.java.bridge.Request.handleRequests(Request.java:485) at php.java.bridge.JavaBridge.run(JavaBridge.java:213) at php.java.bridge.ThreadPool$Delegate.run(ThreadPool.java:60) Caused by: java.lang.ClassNotFoundException: Could not find org.altic.jasperReports.JdbcConnection in java_require() path. Please check the path and the SEL and File permissions. ... 10 more Caused by: java.lang.ClassNotFoundException: Class org.altic.jasperReports.JdbcConnection not found at php.java.bridge.DynamicClassLoader.loadClass(DynamicClassLoader.java:495) at php.java.bridge.DynamicJavaBridgeClassLoader.loadClass(DynamicJavaBridgeClassLoader.java:276) ... 9 more Any help is appreciated, I think I am getting there. Patrick

Well, this did not do the trick unluckly... I still get the same exact error. Any other ideas?

Thanks, I will try that out, I will post the results later. Patrick

Hi, After reading several posts, I have been endlesly trying to run a report via PHP to the java compiler into Jasperserver. The error I get on compile is the following: Does anyone have any close solution? we have installed the barbecue.war in tomcat, and I tried to copy the barbecue jar into jasperserver as well. Thanks!! Code:java stack trace: java.lang.Exception: Invoke failed: [[c:JasperCompileManager]]->compileReport((o:String)[o:String]). Cause: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. it.businesslogic.ireport.barcode.BcImage cannot be resolved to a type value = (java.awt.Image)(it.businesslogic.ireport.barcode.BcImage.getBarcodeImage(9,((java.lang.String)field_ProductID.getValue()),false,false,null,0,0));//$JR_EXPR_ID=8$ <--------------------------------------> 2. it.businesslogic.ireport.barcode.BcImage cannot be resolved to a type value = (java.awt.Image)(it.businesslogic.ireport.barcode.BcImage.getBarcodeImage(9,((java.lang.String)field_ProductID.getOldValue()),false,false,null,0,0));//$JR_EXPR_ID=8$ <--------------------------------------> 3. it.businesslogic.ireport.barcode.BcImage cannot be resolved to a type value = (java.awt.Image)(it.businesslogic.ireport.barcode.BcImage.getBarcodeImage(9,((java.lang.String)field_ProductID.getValue()),false,false,null,0,0));//$JR_EXPR_ID=8$ <--------------------------------------> 3 errors VM: 1.6.0_03@http://java.sun.com/ at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:193) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:219) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:152) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at php.java.bridge.JavaBridge.Invoke(JavaBridge.java:1063) at php.java.bridge.Request.handleRequest(Request.java:409) at php.java.bridge.Request.handleRequests(Request.java:485) at php.java.bridge.JavaBridge.run(JavaBridge.java:213) at php.java.bridge.ThreadPool$Delegate.run(ThreadPool.java:60) Caused by: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. it.businesslogic.ireport.barcode.BcImage cannot be resolved to a type value = (java.awt.Image)(it.businesslogic.ireport.barcode.BcImage.getBarcodeImage(9,((java.lang.String)field_ProductID.getValue()),false,false,null,0,0));//$JR_EXPR_ID=8$ <--------------------------------------> 2. it.businesslogic.ireport.barcode.BcImage cannot be resolved to a type value = (java.awt.Image)(it.businesslogic.ireport.barcode.BcImage.getBarcodeImage(9,((java.lang.String)field_ProductID.getOldValue()),false,false,null,0,0));//$JR_EXPR_ID=8$ <--------------------------------------> 3. it.businesslogic.ireport.barcode.BcImage cannot be resolved to a type value = (java.awt.Image)(it.businesslogic.ireport.barcode.BcImage.getBarcodeImage(9,((java.lang.String)field_ProductID.getValue()),false,false,null,0,0));//$JR_EXPR_ID=8$ <--------------------------------------> 3 errors ... 12 more