Reports maintains data from the previous query. (Cache)

Posted on May 17, 2017 at 5:12am

Good morning, I'm having trouble generating reports. Whenever I make some changes (UPDATE) to certain information in my report, jasper does not make the change.

 

Is there any way to clear the cache every time I run a new query?

JasperReports® Server
fbenitez's picture
fbenitez
52
Joined: Apr 7 2016 - 11:37am
Last seen: 4 years 9 months ago

2 Answers:

Posted on May 18, 2017 at 1:17pm

Hi fbenitez.

Try this:

Access the jasperserver/WEB-INF directory (ex.: c:\Jaspersoft\jasperreports-server-cp-...\apacha-tomcat\webapps\jasperserver\WEB-INF).

Open the file applicationContext, edit "poolTimeout" in jdbcDataSourceServiceFactory from 900 to 1.

rborges.it's picture
rborges.it
60
Joined: May 18 2017 - 1:12pm
Last seen: 6 years 3 weeks ago
Posted on May 19, 2017 at 3:53am
Hello, I have configured the xml file that you said, and it worked.
 
Thanks a lot for the help.
fbenitez's picture
fbenitez
52
Joined: Apr 7 2016 - 11:37am
Last seen: 4 years 9 months ago
Feedback