Hi all,

I've searched the forum and it looks as if JPA does support views, which is what I am trying to do -- but having a problem. In my case, the view is owned by another schema. When I connect to the Oracle 10 schema using a tool like Toad, I can't see the view even though I can query it. I tried the query select * from user_views which produced no result. When I try to configure JPA (backed by Hibernate) I get the error:



I asked my DBA about this, but the answer I get is:


How can I get past this problem?

Stack is Spring 2.5, JPA backed by Hibernate 3.2.6 connecting to Oracle 10 on the back end.

Any reply would be appreciated!

Since you mention JPA, what is the SCHEMA that you're defining in your @Table on this entity?

The class is annotated as such:
@Table(name = "ORACLE_USER_ID", schema = "ORACLE_USER_ID")

Where the ORACLE_USER_ID is the oracle account used to connect to the schema.