Not getting Updated values from DB to Adhoc Report

[ravi_sati]

Hi,

 

I created a Adhoc report from 1 topic. The Datasource is pointing to Sql Server 2005 Database. This Sqlserver database is keep on updating with some other application.

My jasperserver is pointing to that sqlserver database ,when i am running a report, i am not getting the updated values from DB.

I need to restart my jasperserver , then only i am geeting updated values from sqlserver DB.

Do i missing some setting?

 

Regards,

Ravi Dutt

[kkelleher]

This sounds like a caching problem. Each dataset cached by Ad Hoc has a maximum time that it stays in the cache:

 - If a dataset is not used, it is flushed from the cache after 20 minutes.

 - If the data set is being used, it is still flushed after 60 minutes.

You can change this behavior by editing these properties in the applicationContext-adhoc.xml (in WEB-INF):

        <!--  defaultTimeoutMinutes: the absolute longest time in minutes that a dataset can live in the cache -->
        <property name="defaultTimeoutMinutes" value="60"/>

        <!-- defaultUnusedTimeoutMinutes: the longest time a dataset can stay since the last time it was used    -->
        <property name="defaultUnusedTimeoutMinutes" value="20"/>

 

Tweak these values so that JasperServer knows to refresh the results more frequently.  Obviously, this may impact performance when reports are run.

 

Thanks,

 

Kristen

Post Edited by kkelleher at 07/16/2009 19:12

[ravi_sati]

Thanks Kristen, it worked for me.

[noonab]

for japerserver-pro 5.0 :

• Go to WEB-INF folder: ~/jasperreports-server-5.0/apache-tomcat/webapps/jasperserver-pro/WEB-INF
• adhoc-ehcache.xml file
• Change the values as follows timeToIdleSeconds="0"
  timeToLiveSeconds="0"

[gil shimer]

Hi,

Do you know where I can find the configuration for refreshing the cache of reports in general and not only the ad-hoc?

I'm using japerserver-pro 5.0

 

Thanks,

Gil