Don't created indexes in your model, the index creation stuff in 5.4
is not complete (it's a EOF problem, not a WOLips one).
> Hi All,
>
> I am trying to generate and execute the SQL from Entity Modeler to
> an Oracle 10g XE version on windows. But I am getting errors on
> executing the sql.
>
> My Database Config looks like
>
> <db-config-oracle.jpg>
>
> Then I added an index for 2 attributes of my model.
>
> <email-pass-idx.jpg>
>
> When I execute the genrated SQL with the Entity Modeler I get this
> error.
>
> <create-idx-error.jpg>
>
> The generated "CREATE INDEX" statement is: CREATE INDEX
> email_password_idx FOR WatchlistUser (PASSWORD, EMAIL)
>
> I'm using the stable version of WOlips (version: 3.4.5830)
>
> Am I missing something?
>
> What do you guys suggest with it comes to using oracle with WO?
> Do you create your tables from Oracle's DB interface / SQLDev and
> reverse engineer it? or use Entity Modeler?
>
> Thanks,
> Amiel
>
> --
> socket error: unable to connect to 127.0.0.1
This archive was generated by hypermail 2.0.0 : Sun Jan 10 2010 - 21:19:21 EST