lisacbeaton Posted November 7, 2012 Share Posted November 7, 2012 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. Link to comment Share on other sites More sharing options...
Solution mgeise Posted November 8, 2012 Solution Share Posted November 8, 2012 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. Link to comment Share on other sites More sharing options...
lisacbeaton Posted November 8, 2012 Author Share Posted November 8, 2012 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. Link to comment Share on other sites More sharing options...
Pawel.Hadam Posted August 3, 2017 Share Posted August 3, 2017 Hi - is there the entire database schema described in any document? With all tables and relations between? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now