Howver, when I try to connect to my DB2 database the DB2 Driver shows as red in the connections wizard and I receive an error that the necessary Driver class cannot be found.
I have added the Driver in the Services window and successfully setup a New Connection in the services window.
I know it works since I was able to select a particular schema during the Services Connection setup process. I've even tried putting the two jars in the 'lib' directory of iReport. Then my next guess is that you're not using the driver that you want to be using.
But you probably want "The Universal driver" :. The iReport GUI is very confusing in this regard. But you can just type in the correct class and things will work as they should. Give this a try. Thanks Matt. I finally did get this resolved. There were three issues and I include them here in case others come across this thread. Hopefully the folks at Jasper can help address the 2nd and 3rd points:.
I wouldn't call the choice in iReport a bug to be corrected. Having it in the list is reasonable. The proposed url is correct for this driver. But "The Universal driver" is much more commonly used. This is the driver you wanted. Adding this would be great.
I didn't have any particular preference on app versus universal. Along with a fellow iReport user here at work, we just tried various combinations of jars, zip files, and entries in that data source screen until something worked.
It likely would've been easier to get the APP driver workign since iReport seems to natively know something about that driver, but I couldn't figure out how to do it.. It's a little misleading to think that iReport knows something about the APP driver. It includes it in its hard-coded list of drivers. But that's it. It doesn't include the driver. This means you must install the DB2 client classes dlls on your client.
This is generally bad for us. The same class can be used as a type-2 or a type-4 driver. You have to look at the url to know which one is being used. Regards, Matt. Hi where can i donwlaod the db2java. Hi, everyone i have the same problem plus i have to change the jre path to the 1. Add a comment. Active Oldest Votes. Ok, it is nearly always the same : When you look for the error, you cannot find it, then you ask on stackoverflow and a few minutes later you find the error by yourself : The seems to be a typo, the ClassName must be: com.
Improve this answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.
Related 0. Hot Network Questions. Question feed.
0コメント