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????