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 Thu, 29 Jan 2009 21:39:59 GMT

    [ https://issues.apache.org/jira/browse/DDLUTILS-238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12668614#action_12668614
] 

Thomas Dudziak commented on DDLUTILS-238:
-----------------------------------------

Mhmm this looks like an Oracle JDBC driver problem. You seem to be using a rather old driver
judging by its filename (ojdbc14.jar). Could you try a more recent version - you can download
it from here:

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_111060.html

It would also be interesting to see what the column name is that the driver complains about.
Do you have any columns with names that have characters that are not simple numbers or ascii
letters ?

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