From ddlutilscaldwellmichelle@example.org Thu Oct 01 14:21:49 2009
Return-Path: <ddlutilscaldwellmichelle@example.org>
Delivered-To: caldwellmichelle@example.org
Received: (qmail 91196 invoked from network); 1 Oct 2009 14:21:49 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (83.161.120.155)
  by minotaur.apache.org with SMTP; 1 Oct 2009 14:21:49 -0000
Received: (qmail 77370 invoked by uid 500); 1 Oct 2009 14:21:49 -0000
Delivered-To: caldwellmichelle@example.org
Received: (qmail 77323 invoked by uid 500); 1 Oct 2009 14:21:48 -0000
Mailing-List: contact caldwellmichelle@example.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:caldwellmichelle@example.org>
List-Unsubscribe: <mailto:caldwellmichelle@example.org>
List-Post: <mailto:caldwellmichelle@example.org>
List-Id: <ddlutils-dev.db.apache.org>
Reply-To: caldwellmichelle@example.org
Delivered-To: mailing list caldwellmichelle@example.org
Received: (qmail 77306 invoked by uid 99); 1 Oct 2009 14:21:48 -0000
Received: from nike.apache.org (HELO nike.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Oct 2009 14:21:48 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [83.161.120.155] (HELO brutus.apache.org) (83.161.120.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 01 Oct 2009 14:21:45 +0000
Received: from brutus (localhost [83.161.120.155])
	by brutus.apache.org (Postfix) with ESMTP id 553BF234C004
	for <caldwellmichelle@example.org>; Thu,  1 Oct 2009 07:21:24 -0700 (PDT)
Message-ID: <37491273.1254406884332.JavaMail.jira@brutus>
Date: Thu, 1 Oct 2009 07:21:24 -0700 (PDT)
From: "Tamas Ruff (JIRA)" <caldwellmichelle@example.org>
To: caldwellmichelle@example.org
Subject: [jira] Commented: (DDLUTILS-238) java.sql.SQLException: ORA-01424
 missing or illegal character following the escape character
In-Reply-To: <1592529827.1233060780125.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394
X-Virus-Checked: Checked by ClamAV on apache.org


    [ https://issues.apache.org/jira/browse/DDLUTILS-238?page=3Dcom.atlassi=
an.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D12=
761227#action_12761227 ]=20

Tamas Ruff commented on DDLUTILS-238:
-------------------------------------

We have exactly the same problem. Is there any progress in solving this?

> java.sql.SQLException: ORA-01424 missing or illegal character following t=
he escape character
> -------------------------------------------------------------------------=
-------------------
>
>                 Key: DDLUTILS-238
>                 URL: https://issues.apache.org/jira/browse/DDLUTILS-238
>             Project: DdlUtils
>          Issue Type: Bug
>          Components: Core - Oracle
>    Affects Versions: 1.0
>         Environment: Client: win xp, Apache-ant-1.7.1, jdk 1.6.0, DdlUtil=
s-1.0, ojdbc14.jar for oracle 83.161.120.155 | Server: Sun 15k, Solaris, Oracle 1=
83.161.120.155
>            Reporter: Markus B=C3=B6ing
>            Assignee: Thomas Dudziak
>         Attachments: log.txt
>
>
> The schema.xml was written completely and correctly but when it comes to =
extracting the data, this error occures:
> java.sql.SQLException: ORA-01424 missing or illegal character following t=
he escape character
> If you have a where clause with the like operator and use the ESCAPE expr=
ession for example like
> >where owner LIKE 'SOME-OWNER-SUBSTRING' ESCAPE '/'<
> the character after the escape character in SOME-OWNER-SUBSTRING  _MUST_ =
be one of  % or _ to evaluate % or _ literally.
> I've tried different task-parameters like with/without modelname, usedeli=
mitedsqlidentifiers true or without,only certain tabletypes but all with th=
e same result.
> This is my ant file:
> <project name=3D"MyProject" default=3D"database-dump" basedir=3D".">
>     <description>
>         Oracle to DDL
>     </description>
>   <property name=3D"database-dump"  location=3D"database-dump"/>
> <path id=3D"runtime-classpath">
>   <fileset dir=3D"lib">
>     <include name=3D"**/*.jar"/>
>     <include name=3D"**/*.zip"/>
>   </fileset>
> </path>
> <target name=3D"database-dump" description=3D"Oracle10-SCHEMA-Dump">
>   <taskdef name=3D"databaseToDdl"
>            classname=3D"org.apache.ddlutils.task.DatabaseToDdlTask">
>     <classpath refid=3D"runtime-classpath"/>
>   </taskdef>
>   <databaseToDdl modelname=3D"SCHEMA" schemapattern=3D"SCHEMA" databasety=
pe=3D"oracle10" verbosity=3D"DEBUG">
>     <database url=3D"jdbc:oracle:thin:@HOSTIP:1521:SID"
>               driverClassName=3D"oracle.jdbc.driver.OracleDriver"
>               username=3D"SCHEMA"
>               password=3D"PASS"/>
>     <writeSchemaToFile outputFile=3D"schema.xml"/>
>     <writeDataToFile outputFile=3D"data.xml"/>
>   </databaseToDdl>
> </target>
> </project>
> Thanks in advance
> Markus

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.



{'source': 'Apache Software Foundation Public Mail Archives'}