db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Markus Böing (JIRA) <j...@apache.org>
Subject [jira] Created: (DDLUTILS-238) java.sql.SQLException: ORA-01424 missing or illegal character following the escape character
Date Tue, 27 Jan 2009 12:53:00 GMT
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