Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Mapping materialized views

522680Jun 5 2009 — edited Jun 6 2009
Is there some sort of setting I need to adjust to pull off creating Java objects from a materialized view? When I launch the Java Objects from Tables wizard in jDeveloper 11g I can't see any of the materialized views. The views are in a different schema but I have the grants to select from them.

I can see synonyms to them in a different schema but importing synonyms seems to result in some odd mapping behavior.

Any ideas?

Comments

522680
I done some more testing by creating a new schema and creating a materialized view inside of it. When I create a new Toplink project using that schemas login information I still cant see the materialized views in the "Create Java objects from Tables" wizard. This seems to happen in jDeveloper 10 and 11g, Windows and Mac.

Has anyone here managed to successfully map a materialized view? Its looking impossible within jDeveloper at this point.
504035
For mapping purpose only, you could create fake temporary table/view then import the definition. I think if you monitor the SQLs generated to get the list of table/column you should be able to figure out what is wrong by repeting the same from SQLPlus using same login/password.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 4 2009
Added on Jun 5 2009
#application-servers, #toplink-jpa
2 comments
2,037 views