drsaturno

The only and ugly workaround I've found was to put ojdbc6-11.1.0.7.0.jar into the Java jre/lib/ext directory Stack Trace: Compiling to file... C:\amplis\workspace\YMF-AMPLIS-WEB\src\main\resources\br\com\ymf\amplis\patrimonio\relatorios\PTR_49005.jasper 16:42:43,762 [tProcessor] WARN net.sf.jasperreports.engine.component.ComponentsEnvironment [] - Found two components for namespace http://jasperreports.sourceforge.net/jasperreports/components Compilation running time: 8.875! Setting net.sf.jasperreports.engine.query.JRJdbcQueryExecuterFactory as Query Executer Factory for language: sql Filling report... Locale: português (Brasil) Time zone: Default Error filling print... java.lang.ExceptionInInitializerError java.lang.RuntimeException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: br.com.ymf.amplis.fixedincome.assetholding.model.EvaluationSituationEnum at net.sf.jasperreports.engine.base.JRBaseParameter.getValueClass(JRBaseParameter.java:147) at com.jaspersoft.ireport.designer.compiler.prompt.Prompter$1.run(Prompter.java:202) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:199) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: java.lang.ClassNotFoundException: br.com.ymf.amplis.fixedincome.assetholding.model.EvaluationSituationEnum at java.net.URLClassLoader$1.run(URLClassLoader.java:202) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at org.netbeans.ProxyClassLoader.loadClass(ProxyClassLoader.java:252) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:247) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:175) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115) at net.sf.jasperreports.engine.base.JRBaseParameter.getValueClass(JRBaseParameter.java:143) ... 10 more java.lang.reflect.InvocationTargetException at java.awt.EventQueue.invokeAndWait(EventQueue.java:998) at javax.swing.SwingUtilities.invokeAndWait(SwingUtilities.java:1320) at com.jaspersoft.ireport.designer.compiler.prompt.Prompter.promptForParameters(Prompter.java:263) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:706) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: br.com.ymf.amplis.fixedincome.assetholding.model.EvaluationSituationEnum at net.sf.jasperreports.engine.base.JRBaseParameter.getValueClass(JRBaseParameter.java:147) at com.jaspersoft.ireport.designer.IReportManager.setLastParameterValue(IReportManager.java:1565) at com.jaspersoft.ireport.designer.compiler.prompt.Prompter$1.run(Prompter.java:248) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:199) at java.awt.EventQueue.dispatchEvent(EventQueue.java:597) at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: java.lang.ClassNotFoundException: br.com.ymf.amplis.fixedincome.assetholding.model.EvaluationSituationEnum at java.net.URLClassLoader$1.run(URLClassLoader.java:202) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at org.netbeans.ProxyClassLoader.loadClass(ProxyClassLoader.java:252) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:247) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:175) at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForName(JRClassLoader.java:115) at net.sf.jasperreports.engine.base.JRBaseParameter.getValueClass(JRBaseParameter.java:143) ... 11 more Erro inicializando log do amplis org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:357) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:433) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:441) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:449) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:454) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(SimpleJdbcTemplate.java:151) at br.com.ymf.amplis.base.util.log.AmplisLog.getLogFileName(AmplisLog.java:52) at br.com.ymf.amplis.base.util.log.AmplisLog4j.Log4jSetup(AmplisLog4j.java:58) at br.com.ymf.amplis.base.util.log.AmplisLog4j.init(AmplisLog4j.java:41) at br.com.ymf.amplis.base.util.log.AmplisLog$LazyInstanceHolder.<clinit>(AmplisLog.java:27) at br.com.ymf.amplis.base.util.log.AmplisLog.of(AmplisLog.java:37) at br.com.ymf.amplis.base.util.AmplisApplicationContext.<clinit>(AmplisApplicationContext.java:39) at br.com.ymf.amplis.patrimonio.relatorios.BeansDataSource.init(BeansDataSource.java:36) at br.com.ymf.amplis.patrimonio.relatorios.BeansDataSource.<init>(BeansDataSource.java:31) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at java.lang.Class.newInstance0(Class.java:355) at java.lang.Class.newInstance(Class.java:308) at com.jaspersoft.ireport.designer.connection.JRDataSourceProviderConnection.getDataSourceProvider(JRDataSourceProviderConnection.java:60) at com.jaspersoft.ireport.designer.connection.JRDataSourceProviderConnection.getJRDataSource(JRDataSourceProviderConnection.java:113) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:898) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at br.com.ymf.amplis.base.hibernate.connection.TestConnectionProvider.getConnection(TestConnectionProvider.java:59) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) ... 25 more Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at java.net.URLClassLoader$1.run(URLClassLoader.java:202) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at org.netbeans.ProxyClassLoader.loadClass(ProxyClassLoader.java:252) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130) ... 29 more java.lang.ExceptionInInitializerError at br.com.ymf.amplis.base.util.log.AmplisLog.of(AmplisLog.java:37) at br.com.ymf.amplis.base.util.AmplisApplicationContext.<clinit>(AmplisApplicationContext.java:39) at br.com.ymf.amplis.patrimonio.relatorios.BeansDataSource.init(BeansDataSource.java:36) at br.com.ymf.amplis.patrimonio.relatorios.BeansDataSource.<init>(BeansDataSource.java:31) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at java.lang.Class.newInstance0(Class.java:355) at java.lang.Class.newInstance(Class.java:308) at com.jaspersoft.ireport.designer.connection.JRDataSourceProviderConnection.getDataSourceProvider(JRDataSourceProviderConnection.java:60) at com.jaspersoft.ireport.designer.connection.JRDataSourceProviderConnection.getJRDataSource(JRDataSourceProviderConnection.java:113) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:898) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: java.lang.RuntimeException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' at br.com.ymf.amplis.base.util.log.AmplisLog$LazyInstanceHolder.<clinit>(AmplisLog.java:31) ... 15 more Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:357) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:433) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:441) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:449) at org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:454) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.queryForObject(SimpleJdbcTemplate.java:151) at br.com.ymf.amplis.base.util.log.AmplisLog.getLogFileName(AmplisLog.java:52) at br.com.ymf.amplis.base.util.log.AmplisLog4j.Log4jSetup(AmplisLog4j.java:58) at br.com.ymf.amplis.base.util.log.AmplisLog4j.init(AmplisLog4j.java:41) at br.com.ymf.amplis.base.util.log.AmplisLog$LazyInstanceHolder.<clinit>(AmplisLog.java:27) ... 15 more Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at br.com.ymf.amplis.base.hibernate.connection.TestConnectionProvider.getConnection(TestConnectionProvider.java:59) at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113) at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) ... 25 more Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver at java.net.URLClassLoader$1.run(URLClassLoader.java:202) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(URLClassLoader.java:190) at java.lang.ClassLoader.loadClass(ClassLoader.java:307) at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at org.netbeans.ProxyClassLoader.loadClass(ProxyClassLoader.java:252) at java.lang.ClassLoader.loadClass(ClassLoader.java:248) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:169) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130) ... 29 more Print not filled. Try to use an EmptyDataSource...

I'm trying to configure the iReport preview with JRDataSourceProvider, but despite the fact of including ojdbc6-11.1.0.7.0.jar in both iReport classpath and in \Jaspersoft\iReport-4.0.0\ide10\modules\ext I'm still getting the oracle driver not found exception. Does anybody know what coud be happening: iReport Console: Error filling print... java.lang.ExceptionInInitializerError java.lang.RuntimeException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'oracle.jdbc.driver.OracleDriver' Thanks.

I think I have to limit the number of generated reports at once, right? UNIX has a limit of 1024 files by application, and I generated almost 20000. The stack: Caused by: br.com.ymf.amplis.base.exception.BusinessException: Erro na montagem dos datasources do book de relatórios: at br.com.ymf.amplis.patrimonio.relatorios.GeradorRelatorioLote.getDataSources(GeradorRelatorioLote.java:41) at br.com.ymf.amplis.patrimonio.relatorios.PTR_40029.getDataSourcesByFileNames(PTR_40029.java:56) at br.com.ymf.amplis.base.report.AbstractReportBean.putReportsOnSession(AbstractReportBean.java:159) at br.com.ymf.amplis.base.report.AbstractReportBean$1.processConfirmAction(AbstractReportBean.java:70) at br.com.ymf.amplis.base.view.Toolbar.confirmButtonAction(Toolbar.java:326) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37) at java.lang.reflect.Method.invoke(Method.java:599) at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329) at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:342) at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58) at org.jboss.el.parser.AstValue.invoke(AstValue.java:96) at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276) at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68) ... 58 more Caused by: br.com.ymf.amplis.base.exception.AmplisException: Erro na construção do datasource do transaction id PTR_49011 at br.com.ymf.amplis.patrimonio.relatorios.view.ParametroRelatorioUtils.criaReportDS(ParametroRelatorioUtils.java:95) at br.com.ymf.amplis.patrimonio.relatorios.GeradorRelatorioLote.getDataSources(GeradorRelatorioLote.java:39) ... 72 more Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedConstructorAccessor167.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39) at java.lang.reflect.Constructor.newInstance(Constructor.java:515) at br.com.ymf.amplis.patrimonio.relatorios.view.ParametroRelatorioUtils.criaReportDS(ParametroRelatorioUtils.java:93) ... 73 more Caused by: br.com.ymf.amplis.base.exception.AmplisException: Problema no acesso ao diretório temporário do amplis, verifique se existe e se permissões de acesso estão corretas at br.com.ymf.amplis.base.report.AbstractAmplisReportDataSource.<init>(AbstractAmplisReportDataSource.java:126) at br.com.ymf.amplis.patrimonio.relatorios.PTR_49011ReportDS.<init>(PTR_49011ReportDS.java:60) ... 77 more Caused by: net.sf.jasperreports.engine.JRRuntimeException: java.io.FileNotFoundException: /tmp/swap_1860726504_1298486206011 (Too many open files) at net.sf.jasperreports.engine.util.JRSwapFile.<init>(JRSwapFile.java:113) at br.com.ymf.amplis.base.report.AbstractAmplisReportDataSource.<init>(AbstractAmplisReportDataSource.java:122) ... 78 more Caused by: java.io.FileNotFoundException: /tmp/swap_1860726504_1298486206011 (Too many open files) at java.io.RandomAccessFile.open(Native Method) at java.io.RandomAccessFile.<init>(RandomAccessFile.java:218) at net.sf.jasperreports.engine.util.JRSwapFile.<init>(JRSwapFile.java:96)

Maybe a background could solve your problem: <background> <band height="782"> <staticText> <reportElement x="0" y="0" width="555" height="782" style="backgroundStyle" mode="Transparent" /> <textElement rotation="None"/> <text> <![CDATA[sAMPLE]]> </text> </staticText> </band> </background> Source: http://www.themeswiki.org/Designing_reports_using_JasperReports_3.5

Hi there, I was researching some way of reusing jrxml parts, such as report title elements, report footer elements, etc, in a way of providing some pattern to all my reports. I found some topics related to the same issue: http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=26491 http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=3043 The jasperTemplate filter helps me to stablish a way to start new reports, defining styles, headers, footers, etc. But when we have to change those patterns, like, for example, a logo image position at the top of all reports, I cannot do it in just one template file. In other words, I cannot avoid replications in all the reports, I have to change the image position in all reports. That's not true, in fact. I tried to use XML entities as a workaround, and it worked. But, once I define a XML entity inside a jrxml file, I cannot use iReport as a jrxml editor anymore to compile reports, cause all my entities are translated, and all the replicated code is back again. Is there any news about this issue? How to create a template avoiding code replication in all reports using it? Thank you!

I'm wondering if there is any elegant solution for customizing report elements. I'd like to have a different way of configuring a TextField "Pattern", and thought about creating a new TextField with this different feature. I started to study the source code, but I coud not find an elegant solution. I could simply overwriting the JRBaseTextField, but this is ugly, very ugly. After some research on the source code I realized that JRBaseTextField's code has a strong coupling. Even extending JRBaseTextField, I would have facing problems using the extended class. It seems that iReport has great plug-in features, but I cannot using this for add my new TextField report element, right? Thanks!

Hi everybody, Is that possible to return values from the List component to the main report, like return value in subreports? This new component really helps a lot, and simplifies iterations over nested collections. But I don´t know if it´s possible to return values, like a sum field from the List to the mais report. Nowadays I´m solving the issue using ad hoc methods that totalize the sum values. I can use sum variables inside datasets, but the point is: how to show the sum only once, at the botton (or any other place) of the list. Thanks a lot!