Return-Path: 
 <ddlutils-dev-return-1886-apmail-db-ddlutils-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-ddlutils-dev-archive@www.apache.org
Received: (qmail 34725 invoked from network); 29 Jan 2009 12:11:22 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 29 Jan 2009 12:11:22 -0000
Received: (qmail 91086 invoked by uid 500); 29 Jan 2009 12:11:21 -0000
Delivered-To: apmail-db-ddlutils-dev-archive@db.apache.org
Received: (qmail 91068 invoked by uid 500); 29 Jan 2009 12:11:21 -0000
Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:ddlutils-dev-help@db.apache.org>
List-Unsubscribe: <mailto:ddlutils-dev-unsubscribe@db.apache.org>
List-Post: <mailto:ddlutils-dev@db.apache.org>
List-Id: <ddlutils-dev.db.apache.org>
Reply-To: ddlutils-dev@db.apache.org
Delivered-To: mailing list ddlutils-dev@db.apache.org
Received: (qmail 91057 invoked by uid 99); 29 Jan 2009 12:11:21 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jan 2009 04:11:21 -0800
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jan 2009 12:11:20 +0000
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id 01BC3234C4A7
	for <ddlutils-dev@db.apache.org>; Thu, 29 Jan 2009 04:11:00 -0800 (PST)
Message-ID: <1985087844.1233231060005.JavaMail.jira@brutus>
Date: Thu, 29 Jan 2009 04:11:00 -0800 (PST)
From: =?utf-8?Q?Markus_B=C3=B6ing_=28JIRA=29?= <jira@apache.org>
To: ddlutils-dev@db.apache.org
Subject: [jira] Updated: (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-Virus-Checked: Checked by ClamAV on apache.org


     [ https://issues.apache.org/jira/browse/DDLUTILS-238?page=3Dcom.atlass=
ian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Markus B=C3=B6ing updated DDLUTILS-238:
----------------------------------

    Attachment: log.txt

> 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 10.2.0.4 | Server: Sun 15k, Solaris, Oracle 1=
0.2.0.4
>            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.