Materialized views?

Posts   
 
    
happyfirst
User
Posts: 215
Joined: 28-Nov-2008
# Posted on: 01-Dec-2008 23:09:46   

Oracle 11g. I have a materialized view that is not showing up in the llbl designer. Is this not supported?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 02-Dec-2008 03:39:21   

Materialized views are mapped as Entities. If you refresh and click 'Add entities' you should see your materialized view there. After all materialized views are those views in which the query result is cached as a concrete table.

David Elizondo | LLBLGen Support Team
Otis avatar
Otis
LLBLGen Pro Team
Posts: 39859
Joined: 17-Aug-2003
# Posted on: 02-Dec-2008 10:12:16   

Also, if a database element isn't showing up, first look in the catalog explorer and also the application output window to see if something was logged which shows the reason why it was ignored (e.g. a column with an UDT for example)

Frans Bouma | Lead developer LLBLGen Pro
happyfirst
User
Posts: 215
Joined: 28-Nov-2008
# Posted on: 02-Dec-2008 15:48:57   

Ok, I figured out why the materialized view was not showing up in the designer, it was not in the db I was pointing to!

I was able to add it as an entity (the view does not have a primary key) but the generator is not generating any classes for me and there are no errors in the generator output.

happyfirst
User
Posts: 215
Joined: 28-Nov-2008
# Posted on: 02-Dec-2008 16:28:16   

Never mind. Figured it out. User error again....