diesis

May 21, 2007

swood wrote:

You would have to extend the scheduled reporting

I'm not a Java coder :P

I'll wait for the feature ...

In any case, I think thi is very useful, for daily Reports.

Someone could read instantly the report by opening the email, without opening an attachment.

May 18, 2007

Is there any way to include an HTML scheduled report in the body of the email, instead that include it as an attachment ?

Thank you for replying.

May 18, 2007

If it says something like "input line too long" and you are using win2k (not XP or win2k3), try to substitute CMD.EXE with the one of WinXP, run the setup, and after restore the original CMD.EXE.

Remeber to run ji-import.bat or ji-export.bat under Winxp cmd.exe too.

May 7, 2007

No one has an idea ? I've searched, byt it seems there a no parameter for the input control.

May 7, 2007

I have a problem whe running a report using the Calendar input for a date parameter.

The date parameter Data_Inizio (2007-05.01) is passed to mysql so that the query gets executed as:

Code:


SELECT
...
FROM
...
WHERE fd_Data 
BETWEEN
DATE('Tue May 01 00:00:00 CEST 2007')
AND
DATE('Sun May 06 00:00:00 CEST 2007')
...

Naturally this won't work, because mysql need the date in format like yyyy-mm-dd.

I've tried to convert the string to this format using:

Code:

[code]...
WHERE fd_Data
BETWEEN
DATE(STR_TO_DATE($P{Data_Inizio}, '%a %b %d %T CET %Y'))
AND
DATE(STR_TO_DATE($P{Data_Fine}, '%a %b %d %T CET %Y'))

The problem is that the string CET changes to CEST when Daylight saving changes, and for some monthes it works, and for some other not.

Suggestions ?

May 6, 2007

The problem was related with Tomcat security policy.
I addedd (in addition to a lot of other modifications to the standard install procedure):

Code:

cat /etc/tomcat5.5/policy.d/50user.policy | grep -v ^/[/code]

Code:

grant codeBase "file:/var/lib/tomcat5.5/webapps/jasperserver/-" {      permission java.security.AllPermission;      permission java.net.SocketPermission "127.0.0.1:3306", "connect,resolve";      permission java.net.SocketPermission "*.noaa.gov:80", "connect";      permission java.io.FilePermission "/var/lib/tomcat5.5/webapps/jasperserver/WEB-INF/logs-", "read,write,delete";};[/code]

Yes, I know, I'm a totally newbie, but it works.

May 6, 2007

I've followed the instructions on JasperServer-WarFile-Install-Guide.pdf to install JasperServer under Ubuntu 7.04.

Mysql5, Tomcat5.5 and JDBC works good (tested with php, openoffice.org)

Unfortunately, the WAR file does not deploy corretly.

Here is the tomcat log, someone could help me ?

I'm totally new to tomcat and java, so this log is very cryptic to me.

Thank you.

6-mag-2007 0.31.59 org.apache.catalina.core.AprLifecycleListener lifecycleEvent

INFO: The Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-sun/jre/lib/i386/client:/usr/lib/jvm/java-6-sun/jre/lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib

6-mag-2007 0.31.59 org.apache.coyote.http11.Http11BaseProtocol init

INFO: Initializing Coyote HTTP/1.1 on http-8180

6-mag-2007 0.31.59 org.apache.catalina.startup.Catalina load

INFO: Initialization processed in 1515 ms

6-mag-2007 0.31.59 org.apache.catalina.core.StandardService start

INFO: Starting service Catalina

6-mag-2007 0.31.59 org.apache.catalina.core.StandardEngine start

INFO: Starting Servlet Engine: Apache Tomcat/5.5

6-mag-2007 0.31.59 org.apache.catalina.core.StandardHost start

INFO: XML validation disabled

[JPivot] 06 mag 2007 00:32:03,112 ERROR [session ] org.apache.catalina.core.StandardContext#listenerStart: Exception sending context initialized event to listener instance of class org.springframework.web.util.Log4jConfigListener

java.security.AccessControlException: access denied (java.util.PropertyPermission jasperserver.root read)

at java.security.AccessControlContext.checkPermission(AccessControlContext.java:323)

at java.security.AccessController.checkPermission(AccessController.java:546)

at java.lang.SecurityManager.checkPermission(SecurityManager.java:532)

at java.lang.SecurityManager.checkPropertyAccess(SecurityManager.java:1285)

at java.lang.System.getProperty(System.java:652)

at org.springframework.web.util.WebUtils.setWebAppRootSystemProperty(WebUtils.java:130)

at org.springframework.web.util.Log4jWebConfigurer.initLogging(Log4jWebConfigurer.java:117)

at org.springframework.web.util.Log4jConfigListener.contextInitialized(Log4jConfigListener.java:51)

at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)

at org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)

at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)

at org.apache.catalina.core.ContainerBase.access$0(ContainerBase.java:743)

at org.apache.catalina.core.ContainerBase$PrivilegedAddChild.run(ContainerBase.java:143)

at java.security.AccessController.doPrivileged(Native Method)

at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:737)

at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:608)

at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:535)

at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:470)

at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)

at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)

at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)

at org.apache.catalina.core.StandardHost.start(StandardHost.java:718)

at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)

at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)

at org.apache.catalina.core.StandardService.start(StandardService.java:450)

at org.apache.catalina.core.StandardServer.start(StandardServer.java:709)

at org.apache.catalina.startup.Catalina.start(Catalina.java:551)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at org.apache.commons.daemon.support.DaemonLoader.start(DaemonLoader.java:177)

[JPivot] 06 mag 2007 00:32:08,316 ERROR [session ] org.hibernate.util.JDBCExceptionReporter#logExceptions: Cannot create PoolableConnectionFactory (Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException

MESSAGE: java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:3306 connect,resolve)

STACKTRACE:

java.net.SocketException: java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:3306 connect,resolve)

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)

at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)

at com.mysql.jdbc.Connection.createNewIO(Connection.java:2569)

at com.mysql.jdbc.Connection.<init>(Connection.java:1485)

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)

at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)

at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:877)

at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:851)

at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)

at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:81)

at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:76)

at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2006)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1289)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.newSessionFactory(LocalSessionFactoryBean.java:804)

at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:744)

at org.springframework.orm.hibernate3.AbstractSessionFactoryBean.afterPropertiesSet(AbstractSessionFactoryBean.java:131)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1118)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1085)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:429)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:245)

at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:124)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1019)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:809)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425)

at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:250)

at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:247)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:161)

at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:273)

at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:346)

at org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:156)

at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:246)

at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:184)

at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)