Reports maintains data from the previous query. (Cache)

[fbenitez]

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?

[rborges.it]

Hi fbenitez.

Try this:

Access the jasperserver/WEB-INF directory (ex.: c:Jaspersoftjasperreports-server-cp-...apacha-tomcatwebappsjasperserverWEB-INF).

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

[fbenitez]

Hello, I have configured the xml file that you said, and it worked.

 

Thanks a lot for the help.