[Hibernate-issues] [Hibernate-JIRA] Created: (HHH-1785) validate not working with oracle dblinks

[Arik G. (JIRA) <no...@at...>]

validate not working with oracle dblinks
----------------------------------------

         Key: HHH-1785
         URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1785
     Project: Hibernate3
        Type: Bug

    Versions: 3.1 rc2    
 Environment: Hibernate:  3.1.rc2
Database: Oracle 9i
    Reporter: Arik Galansky


Full stack trace of any exception that occurs:
Don't have a full stack availible, but here is the last part:
Caused by:org.hibernate.HibernateException: Missing Table: table@dblink
org.hibernate.cfg.Configuration.ValidateSchema (Configuration.java953)

Name and version of the database you are using: Oracle 9i

the problem is that when I set the hibernate.hbm2ddl.auto to validate I get the mentioned below Exception on a table that is found on a remote DB/
important to note that I can select from the table when it comes to queries, but only if I put it the hbm2ddl on "update" mode which is ofcourse not healthy considering I don't want the EJB to alternate my DB stracture in any way.

* important to mention that the user on the other side of the DBlink has the "select any dictionary" grant so he should have no problem selecting from the dba_* tables.

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