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