Reports not refreshing on JasperServer 6.3 (community version)

[mailnando]

Hi,

I am running reports with Oracle database, however the data changes frequently. 

When I run a report the first time it takes the data from the database, however if I run it a second time, it produces the previous report rather than re-read data from the database.  How can I make Jasper Server read from the database every time and generate the report.

I read some posts talking about adhoc parameters in Server Settings, but its not show for me, i believe its because de community version.

Is there an way to solve my ploblem?

Thanks in advance.

Fernando.

[hozawa]

AdHoc reports are only available on Enterprise edition so the information on it doesn't relate to the community edition users.

It seems like your jdbc result is being cached or your page is being cached somewhere. I don't think it's JasperReports Server but more likely the application server you're using or a proxy server. Also check your jdbc string to check if there is any caching argument. Unfortunately, jdbc properties differ depending on the jdbc driver and database you're using so can only give general advice.

[mailnando]

Someone else?

I need someone that really knows about Jasperserver works.

 

Tks.,

Fernando.

 

[mlopez_1]

I am running reports with Oracle database too, Oracle 11gR2, and community version and works perfectly when refresh and when reopen.

Mariano

[mailnando]

Mariano!

Tks for your repply.

What´s the version of your JasperServer? Can you print the data source configuration please?

did you configure some xml file in WEB-INF ? Abou chache or someting like this?

 

Tks,

Fernando.

[mlopez_1]

JasperServer: 6.2.0. RedHatx64

Only add last Oracle JDBC lib jar file to JasperServer's Apache Tomcat and configure Data Adapter:

JDBC Driver: oracle.jdbc.driver.OracleDriver

JDBC Url: jdbc:oracle:thin:@//servername:port_number/service_name

Username and password.

Regards,

Mariano

[mailnando]

Hum i didi the same way.

But when i update the data in database e re-run the report the updated data doesn´t showed in report, then i need to down the apache service e up again and it works with new data.

 

[mlopez_1]

May be Oracle server configuration, ... I just remember this http://community.jaspersoft.com/wiki/how-modify-caching-values-if-your-data-does-not-update-constantly, but I never touch this.

You could check it

Mariano