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

[Dave E Martin (JIRA)]

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
        Type: Bug

    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


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