db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-238) java.sql.SQLException: ORA-01424 missing or illegal character following the escape character
Date Wed, 28 Jan 2009 09:43:00 GMT

    [ 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.


Mime
View raw message