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
|