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

From: jlecuyer (jlecuye..ac.com)
Date: Thu Feb 08 2007 - 20:21:18 EST

  • Next message: jlecuyer: "someone using ojdbc14.jar (oracle xp) with success ?"

    If i cut and paste:

    drop table SIMPLE_TEST_TABLE cascade constraints
    /

    in Oracle Database Express Edition, in html sql control page
    it's work, and execute those 2 line

    ???

    may be some code add a strange car. at the end (like a cr /
    lf ) ? or ???

    On 07-Feb-08, at 5:59 PM, Mike Schrag wrote:

    > 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 - 20:21:31 EST