Entity modeler error ? (sql and oracle), please help me (2nd post)

From: jlecuyer (jlecuye..aptra.com)
Date: Thu Feb 08 2007 - 17:56:48 EST

  • Next message: Mike Schrag: "Re: Entity modeler error ? (sql and oracle), please help me (2nd post)"

    Could someone give me a hint on this error ?
    ___
    In Eclipse 3.2 (WOLips) (on mac and pc) in Entity Modeler when i clic
    on sql button and i select only for exemple, the "drop tables" radio
    selection (on an existing oracle table)
    the sql is:

    drop table SIMPLE_TEST_TABLE cascade constraints
    /

    on clic "execute SQL" i get:
    ORA-00933: SQL command not properly ended.

    If I try in the same in EOModeler, all is OK and
    the SQL is the same:

    drop table SIMPLE_TEST_TABLE cascade constraints
    /

    no error, and the table is dropped on the pc from the mac on a local
    network.

    Help me, please
    Jean

    ______
    If I remove ojdbc14 from /Library/Java/Extensions (on the mac)
    Eclipse (and EOModeler) generate an error (driver not found)

    before going to oracle, everything ok with openbase and mysql on mac
    ___

    Configuration and version:

    mac:
    Dev. Computer: Dual 2GHz PowerPc G5, 10.4.8
    Eclipse 3.2.1
    WOLips: 2.0.0.2967
    java version "1.5.0_06"

    pc:
    oracle Express Edition 10g on Pc windows xp pro
    jdbc driver: ojdbc14.jar (10.2.0.2)
    java 1.5.0_10
    ___
    url from the model:
    jdbc:oracle:thin:PcIpNumber:1521:xe

    ____

    Jean

    This archive was generated by hypermail 2.0.0 : Thu Feb 08 2007 - 17:57:01 EST