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

From: Mike Schrag (mschra..dimension.com)
Date: Fri Feb 09 2007 - 07:02:06 EST

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

    No, it's that it would appear that '/' is a command separator in
    oracle, but it's not to EntityModeler ... I put this on the todo list.

    On Feb 8, 2007, at 8:21 PM, jlecuyer wrote:

    > 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 : Fri Feb 09 2007 - 07:02:42 EST