[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-2018) Cannot map views in postgres unless hbm2ddl.auto is unset

Cannot map views in postgres unless hbm2ddl.auto is unset --------------------------------------------------------- Key: HHH-2018 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2018 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.0.cr2 Environment: hibernate 3.2cr2 annotations 3.2cr1 postgresql 8.1 with postgresql-8.1-404.jdbc3.jar This is also a problem in hibernate 3.1 Reporter: Dave E Martin Assignee: Diego Pires Plentz Attempting to map a view with hibernate results in: Exception in thread "main" org.hibernate.HibernateException: Missing table: monthly_block_totals_utc Even though this exists (as a view) in the database. making sure hbm2ddl.auto is not set allows the application to work, but at the expense of being unable to update or validate the schema (or allow the end user to control whether the schema should be updated or not). Furthermore, there doesn't appear to be a 'none' or any documented way to set .auto to something which would be the equivalent of it not being set. (or to clear it out of the properties, and setting it to null doesn't work either). This appears to be related to HHH-1329 and HHH-1473. Stepping into the process reveals that postgres apparently reports views as views and not tables, causing them to be overlooked by Hibernate when its validating.