Reports are saved in the repository... but what table?

I have connected to my Postgres repository using pgAdmin. I'm in the public schema of the jasperserver database. There are 86 tables and I can view the data in them. Where are the reports stored? Table jiresource looks like it might be the one. Exactly how are reports saved in the repository? I want to help our users understand that reports don't exist in the file system, and in what format they exist within the repository.

lisacbeaton's picture
Joined: Mar 27 2012 - 9:24am
Last seen: 8 years 5 months ago

1 Answer:

You are correct that they do not reside on the filesystem.  I think what you are looking for is may be in two tables:

  • jifileresource - Report Definitions (JRXML files), Server UI stylesheets (CSS), Domain definitions and security files (XML), etc.
  • jicontentresource - Report output from scheduled report executions (PDF, HTML, XLSX, etc)

In both of these tables, the files are stored as a binary datatype in the reposotory database.

mgeise's picture
Joined: Mar 5 2007 - 6:18am
Last seen: 2 years 9 months ago
Thanks! That's exactly what I'm looking for, and in jicontentresource I can see some report output that I generated yesterday. This is a big help.
lisacbeaton - 9 years 10 months ago

Hi - is there the entire database schema described in any document? With all tables and relations between?

Pawel.Hadam - 5 years 1 month ago