On 21 February 2012 14:36, Franklin, Matthew B. <[email protected]> wrote:
> On 2/21/12 8:31 AM, "Jasha Joachimsthal" <[email protected]> > wrote: > > >This logic is also used in DefaultPageService which even needs the > >entityid > >(so I cannot fake fixed values in there). > > > >Jasha > > > >On 21 February 2012 12:59, Jasha Joachimsthal > ><[email protected]>wrote: > > > >> I'm currently working on a setup with Oracle. The schema should be > >> generated by JPA and then we can add some necessary records for > >>authorities > >> and layouts. > >> During startup Spring tries to create a bean for the > >> DefaultPagePermissionEvaluator which calls the PageTypeRepository in its > >> constructor. Spring throws an exception because there are no pagetypes > >>in > >> my empty database and the context /portal is not available. No schema is > >> created so I cannot populate the tablespaces either. For me this is a > >> catch-22 because I don't know the exact syntax to populate the Oracle > >>table > >> spaces. > > I think OpenJPA allows you to generate the DDL needed to create the > Schema. I would recommend looking into that and seeing if there isn't an > easy way to do it with maven. That way, you get a set of Oracle specific > statements that should be easily runnable in SQL+. > > >> IMO we shouldn't rely on a pre-populated database since the only > >>database > >> we can guarantee to be populated is H2 in the demo setup. The SQL > >>scripts > >> may also work on MySQL, but certainly don't work on PostgreSQL or > >>Oracle. > > +1. Can you open a ticket for this? > Done https://issues.apache.org/jira/browse/RAVE-478
