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

From: Mike Schrag (mschra..dimension.com)
Date: Thu Feb 08 2007 - 17:59:11 EST

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

    Is "\" equivalent to an "end command" in Oracle? I suspect it's
    trying to execute "/" as a command, or it's scanning for a semicolon
    and not finding one.

    On Feb 8, 2007, at 5:56 PM, jlecuyer wrote:

    >
    > 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:59:16 EST