[
https://issues.apache.org/jira/browse/DDLUTILS-238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12667979#action_12667979
]
Thomas Dudziak commented on DDLUTILS-238:
-----------------------------------------
Did this error happen during writeSchemaToFile or writeDataToFile ? Please post
the complete stacktrace (run ant with -debug if necessary).
If it happened during writeSchemaToFile, then please post the relevant DDL SQL
for the table where the error happened. If during writeDataToFile, then please
post the DML SQL for the row where it happened.
> 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.
