Entity Modeler and Oracle XE

From: Amiel Montecillo (bosyotec..mail.com)
Date: Sun Jan 10 2010 - 21:14:38 EST

  • Next message: Pascal Robert: "Re: Entity Modeler and Oracle XE"

    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

    [image:
    ?ui=2&view=att&th=1261b227a6aaa083&attid=0.1&disp=attd&realattid=ii_1261b227a6aaa083&zw]

    Then I added an index for 2 attributes of my model.

    [image:
    ?ui=2&view=att&th=1261b23fbd2819a2&attid=0.1&disp=attd&realattid=ii_1261b23fbd2819a2&zw]

    When I execute the genrated SQL with the Entity Modeler I get this error.

    [image:
    ?ui=2&view=att&th=1261b254efd1c312&attid=0.1&disp=attd&realattid=ii_1261b254efd1c312&zw]

    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
    db-config-oracle.jpg
    create-idx-error.jpg
    email-pass-idx.jpg

    This archive was generated by hypermail 2.0.0 : Sun Jan 10 2010 - 21:16:04 EST