Brokenbone

Hi all! Recently we've deployed our J2EE web application to production server. In development we used Oracle Application Server on Windows while in production it runs on Linux. We've set pretty precise fields lengths depending on the values that those fields display. It looked perfect when deployed on our server, but on production server a lot of values in the fields are not displayed entirely. It looks like as if the text is bigger and it doesn't have enough place in the field. Has anyone had any similar problems? Is this maybe an PDF settings question, iReport question? I'd really appreciate any tips on what to check since it's pretty difficult to set precise field lengths when you have no idea how big field will be required in production. Thank you in advance! BB Edit: Looks like the problem is in font settings. I have Font set to 'Arial' while PDF Font set to 'Helvetica'. Can anyone suggest any solution or maybe just tell me better solution of these two I can think of: 1st: install windows font on Linux server (will this even work?) 2nd: install Linux fonts on my machine and set font for all fields to let's say 'Helvetica' also instead of 'Arial'. I'd really appreciate any suggestions. Kind regards. Post edited by: Brokenbone, at: 2008/06/02 08:21

Hi! Thank you for your help. I've made this work a little different. For someone using JDeveloper it might give some idea if he/she runs at a similar problem. I didn't use any connections, I just wrote the information I need to ProcessScope parameters, which I then used in the class where my report gets filled. This way I can use any ADF/BC elements including application module. Take care! BB

Hi Lucian! I've somehow created a scriptlet class which I've compiled in my JDeveloper ViewController project. The problem I now have is the access to the DB to call a stored procedure. Jdev has application module for this, but I can't get a reference to it from my scriptlet class. (Probably the class that is referenced from jasper report has another session or something like this?) Is there a way to get the DB connection in scriptlet class and call DB procedure directly, without the reference to the Model project. I hope I make myself clear enough to get some suggestions. Thanks!

Hi! I nees to call smo DB procedure with some report results as parameters. I'm using a scriptlet to achieve this (well, I'm trying to use a scriptlet :)). For a scriptlet class I've created a class in JDev, where I use MVC architecture. The class is in ViewController project, from which I have to access my application module to call some DB procedures when report is generated. I've been trying to do this in a couple of way but had no success. The methods in the class are called as I want them to be but I can't get the reference to my application module in this class. I need this because through the application module is the only way I know how to call a DB procedure. Does anyone have any ideas how to achieve this? I'm quite unexperienced in Java and MVC architecture so maybe someone can explain to me if I'm completely wrong trying to do this in such way. Any suggestions would be much appreciated. Thanks BB

Hi! After guessing some more I changed scriptlet property on Document to 'Use this scriptlet class...' and Scriptlet Class property to 'ScriptletReportScriptlet.java'. After compile I have this error: Code: R:Jasper reportsScriptletReportScriptlet.java:4: cannot access it.businesslogic.ireport.IReportScriptlet bad class file: C:Program FilesJasperSoftiReport-2.0.2.libiReport.jar(it/businesslogic/ireport/IReportScriptlet.class) class file has wrong version 49.0, should be 48.0 Please remove or make sure it appears in the correct subdirectory of the classpath. public class ScriptletReportScriptlet extends it.businesslogic.ireport.IReportScriptlet { Any help on this problem and using scriptlets in general would be much appreciated. BB

Hi all! I'm new to JasperReports and iReport. I need to call a DB procedure with the values of some columns from every row that is shown in the report. From JasperReports help forum I got the advice to use scriptlet which I know nothing about. I red the documentation and tried running the Scriptlet example from downloads page, but can't compile it. I get Code:java.lang.ClassNotFoundException: ScriptletReportScriptlet problem when I open the report and Code:[code] Error compiling the Scriptlet Java source. net.sf.jasperreports.engine.JRException: Error compiling report java source files : R:Jasper reportsScriptletReportScriptlet.java at net.sf.jasperreports.engine.design.JRJdk13Compiler.compileClasses(JRJdk13Compiler.java:119) at net.sf.jasperreports.engine.design.JRAbstractMultiClassCompiler.compileClass(JRAbstractMultiClassCompiler.java:45) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:358) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassNotFoundException: com.sun.tools.javac.Main at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:179) at net.sf.jasperreports.engine.design.JRJdk13Compiler.compileClasses(JRJdk13Compiler.java:81) ... 3 more when I try to compile it. I tried changing the Scriptlet property to Use iReport internal scriptlet support but had no success. Can anyone please help me about this and maybe post some links to more examples or tutorials on using scriptles? How do I edit the scriptlet code, is there any more documentation on the methods I can use? Thanks! BB Post edited by: Brokenbone, at: 2008/01/14 11:52

Anyone? I'd really like to be able to call a procedure with some query results but can't find any example for using scriptlets. The one I downloaded from downloads page is not working because of above described error. Thanks

Hi Lucian! Thanks for your suggestion but I'm pretty new to Java too. :blush: I've red the documentation on scriptlets and tried to run the scriptlet example from the samples page. I can't get even this working. When I compile the report without changing it it anyhow I get the ClassNotFoundException. Even if I set the Scriptlet property of the document to Use iReport internal scriptlet support, I still have the same error. Found the thread with the same problem on forum but without a solution. Maybe you can point me to some more information on this subject, where could I read some more about Scriptlet property for example, Scriptlet class, maybe some other example or tutorial. Thanks! BB

Hi all! I'm new to JasperReports and I've been using it for a month now without any major problems. Now I ran into one I can't solve. For the purpose of some kind of custom SELECT auditing I have to call a procedure (INSERT some records) from the result set into the database. I'm using JDeveloper and have a method for shoving reports that loads compiled report from some location, fill the report with some parameters and export report to PDF. Is there a way somewhere in between to get the result sets from the report, because I would need the values of one column from every record shown in my report, and than call some stored procedure with this values? Thank you in advance! BB