Hello Amiel
No, you are not missing anything, I found this problem with Sybase SQL Anywhere and PostgreSQL databases as well. The problem is that the generated code uses the keyword FOR, but for the above mentioned databases and Oracle we should have the keyword ON.
Hope the WOLips team can correct this as the current implementation leds to being not able to (successfully) use the index generation.
Regards, Robert
On 11.01.2010, at 03:14, Amiel Montecillo wrote:
> 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
_/ _/ _/ _/ _/ r. huber
_/
_/ _/ _/ 7r gmbh
_/ _/ _/ alpenstrasse 93
_/ _// ch-8200 schaffhausen
_/ _/
_/ _/ tel. +41 52 624 81 15 www.seven-r.ch
This archive was generated by hypermail 2.0.0 : Mon Jan 11 2010 - 03:42:10 EST