java.sql.SQLException: ORA-01424 missing or illegal character following the 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, DdlUtils-1.0, ojdbc14.jar for oracle 10.2.0.4 | Server: Sun 15k, Solaris, Oracle 10.2.0.4 Reporter: Markus Böing Assignee: Thomas Dudziak 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 the escape character If you have a where clause with the like operator and use the ESCAPE expression 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, usedelimitedsqlidentifiers true or without,only certain tabletypes but all with the same result. This is my ant file: <project name="MyProject" default="database-dump" basedir="."> <description> Oracle to DDL </description> <property name="database-dump" location="database-dump"/> <path id="runtime-classpath"> <fileset dir="lib"> <include name="**/*.jar"/> <include name="**/*.zip"/> </fileset> </path> <target name="database-dump" description="Oracle10-SCHEMA-Dump"> <taskdef name="databaseToDdl" classname="org.apache.ddlutils.task.DatabaseToDdlTask"> <classpath refid="runtime-classpath"/> </taskdef> <databaseToDdl modelname="SCHEMA" schemapattern="SCHEMA" databasetype="oracle10" verbosity="DEBUG"> <database url="jdbc:oracle:thin:@HOSTIP:1521:SID" driverClassName="oracle.jdbc.driver.OracleDriver" username="SCHEMA" password="PASS"/> <writeSchemaToFile outputFile="schema.xml"/> <writeDataToFile outputFile="data.xml"/> </databaseToDdl> </target> </project> Thanks in advance Markus -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.