Jump to content
Changes to the Jaspersoft community edition download ×

JasperReports Server 7.1 - Access postgres materialized views from a domain


jevans_247

Recommended Posts

When creating a Domian from a postgres data source, materialized views do not appear in the domain designer. I followed the instructions at https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v71/configuring-domains#Accessing_Materialized_Views and added <value>MATERIALIZED VIEW</value> as described. I also rebooted the server in case that was necessary. My materialized views still don't appear in the domain designer. Any suggestions?

As an additional troubleshooting step,  I commenting out the  <value>VIEW</value> line immediately above my new <value>MATERIALIZED VIEW</value> line , rebooted, and as expected did not see (non-materialized) views in the domain designer. I then un-commented the VIEW line, rebooted, and again saw non-materialized views as expected. So that confirmed I at least had the correct file and area.

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...