bhaugland

I am having the same problem only with an oracle database. One date shows up as EST and the next date shows up as EDT. Is there a problem with the daylight savings time switch in Jasper.

I am having the same problem only with an oracle database. One date shows up as EST and the next date shows up as EDT. Is there a problem with the daylight savings time switch in Jasper.

I am having the same problem only with an oracle database. One date shows up as EST and the next date shows up as EDT. Is there a problem with the daylight savings time switch in Jasper.

Is it possible to use$R{resourcename} inside of the Report Query.

I noticed that I was not getting any any errors related to database open problems recorded in the event log for scheduled jobs. I am using oracle for my repository. When I checked the logs I found this stack dump. org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batc h update; uncategorized SQLException for SQL [insert into JILogEvent (occurrence_date, event_type, u sername, component, message, resource_uri, event_text, event_data, event_state, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1461]; ORA-01461: can bind a LONG value only for insert into a LONG column ; nested exception is java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for inser t into a LONG column java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9040 ) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:487) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingE ventListener.java:296) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java: 27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransact ionManager.java:579) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit( AbstractPlatformTransactionManager.java:500) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(Abstrac tPlatformTransactionManager.java:473) at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionA fterReturning(TransactionAspectSupport.java:262) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInte rceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo cation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy58.log(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.logException( ReportExecutionJob.java:216) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.handleExcepti on(ReportExecutionJob.java:178) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(Repor tExecutionJob.java:130) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Which field is this referring to. Could this be causing my problem of quartz skipping jobs. Thanks

I noticed that I was not getting any any errors related to database open problems recorded in the event log for scheduled jobs. I am using oracle for my repository. When I checked the logs I found this stack dump. org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batc h update; uncategorized SQLException for SQL [insert into JILogEvent (occurrence_date, event_type, u sername, component, message, resource_uri, event_text, event_data, event_state, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1461]; ORA-01461: can bind a LONG value only for insert into a LONG column ; nested exception is java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for inser t into a LONG column java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9040 ) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:487) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingE ventListener.java:296) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java: 27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransact ionManager.java:579) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit( AbstractPlatformTransactionManager.java:500) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(Abstrac tPlatformTransactionManager.java:473) at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionA fterReturning(TransactionAspectSupport.java:262) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInte rceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo cation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy58.log(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.logException( ReportExecutionJob.java:216) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.handleExcepti on(ReportExecutionJob.java:178) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(Repor tExecutionJob.java:130) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Which field is this referring to. Could this be causing my problem of quartz skipping jobs. Thanks

I noticed that I was not getting any any errors related to database open problems recorded in the event log for scheduled jobs. I am using oracle for my repository. When I checked the logs I found this stack dump. org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Could not execute JDBC batc h update; uncategorized SQLException for SQL [insert into JILogEvent (occurrence_date, event_type, u sername, component, message, resource_uri, event_text, event_data, event_state, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; SQL state [72000]; error code [1461]; ORA-01461: can bind a LONG value only for insert into a LONG column ; nested exception is java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for inser t into a LONG column java.sql.BatchUpdateException: ORA-01461: can bind a LONG value only for insert into a LONG column at oracle.jdbc.driver.DatabaseError.throwBatchUpdateException(DatabaseError.java:367) at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9040 ) at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:487) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:58) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:195) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:230) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingE ventListener.java:296) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java: 27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1009) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:356) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransact ionManager.java:579) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit( AbstractPlatformTransactionManager.java:500) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(Abstrac tPlatformTransactionManager.java:473) at org.springframework.transaction.interceptor.TransactionAspectSupport.doCommitTransactionA fterReturning(TransactionAspectSupport.java:262) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInte rceptor.java:110) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvo cation.java:170) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176) at $Proxy58.log(Unknown Source) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.logException( ReportExecutionJob.java:216) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.handleExcepti on(ReportExecutionJob.java:178) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(Repor tExecutionJob.java:130) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Which field is this referring to. Could this be causing my problem of quartz skipping jobs. Thanks

I am having a problem with jobs not running from the scheduler. No errors are reported and the schedule disappears like it should. However no reports are generated. This is completely random since some of the jobs will run. I have 9 jobs scheduled to run at the same time. At least 1 job will not generate the report. I am able to run the report with no problem. My quartz properties have 20 threads with a priority of 5.

You need to assign users to the role ROLE_USER as well as your new role. That will give them access to the system

I managed to get JasperIntelligence 1.1 running on oracle using the oracle patch for 1.0.1. However I am not sure if there were any database changes that might affect the run. Could you shed some light on this Thanks Bruce Haugland

I am interested in this as well. I need to have security in the JasperIntelligence web application. However I want to pass credentials from another web application to the JasperIntelligence so the user is not forced to log on a second time.

I am interested in this as well. I need to have security in the JasperIntelligence web application. However I want to pass credentials from another web application to the JasperIntelligence so the user is not forced to log on a second time.

I did get it to work using a standard JBoss install (i.e 8080 port and default jnp: 1099 Because of my companies many installations of JBoss I need to be able to move the jnp to a different address. I have not figured out how to do this for 1.1. 1.0 had no problem with the different jnp address

Has anyone succeeded in deploying 1.1 to JBoss. I get the error in relationship to the applicationContext.xml and the bean named datasource javax.naming.NameNotFoundException: jdbc not bound. The strange thing about this is that that name should not be there since JBoss has not initialized the Datasources for the JNDI

Is there any news about the availability of an oracle patch for 1.1. I have tried generating the scripts myself using the source from the source zip file but have been unable to compile.