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

[Diego Pires Plentz (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Diego Pires Plentz resolved HHH-2018.
-------------------------------------

      Assignee: Diego Pires Plentz
    Resolution: Duplicate

> 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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira