From ddlutils-dev-return-1888-apmail-db-ddlutils-dev-archive=db.apache.org@db.apache.org Thu Jan 29 21:40:30 2009 Return-Path: Delivered-To: apmail-db-ddlutils-dev-archive@www.apache.org Received: (qmail 25980 invoked from network); 29 Jan 2009 21:40:30 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 29 Jan 2009 21:40:30 -0000 Received: (qmail 49880 invoked by uid 500); 29 Jan 2009 21:40:30 -0000 Delivered-To: apmail-db-ddlutils-dev-archive@db.apache.org Received: (qmail 49860 invoked by uid 500); 29 Jan 2009 21:40:30 -0000 Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-dev@db.apache.org Delivered-To: mailing list ddlutils-dev@db.apache.org Received: (qmail 49848 invoked by uid 99); 29 Jan 2009 21:40:30 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jan 2009 13:40:30 -0800 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 29 Jan 2009 21:40:19 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id ADBAA234C4AD for ; Thu, 29 Jan 2009 13:39:59 -0800 (PST) Message-ID: <651188650.1233265199710.JavaMail.jira@brutus> Date: Thu, 29 Jan 2009 13:39:59 -0800 (PST) From: "Thomas Dudziak (JIRA)" To: ddlutils-dev@db.apache.org Subject: [jira] Commented: (DDLUTILS-238) java.sql.SQLException: ORA-01424 missing or illegal character following the escape character In-Reply-To: <1592529827.1233060780125.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DDLUTILS-238?page=3Dcom.atlassi= an.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D12= 668614#action_12668614 ]=20 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 mo= re recent version - you can download it from here: http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_1= 11060.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 t= hat are not simple numbers or ascii letters ? > java.sql.SQLException: ORA-01424 missing or illegal character following t= he 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, DdlUtil= s-1.0, ojdbc14.jar for oracle 10.2.0.4 | Server: Sun 15k, Solaris, Oracle 1= 0.2.0.4 > Reporter: Markus B=C3=B6ing > 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 t= he escape character > If you have a where clause with the like operator and use the ESCAPE expr= ession 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, usedeli= mitedsqlidentifiers true or without,only certain tabletypes but all with th= e same result. > This is my ant file: > > > Oracle to DDL > > > > > > > > > > classname=3D"org.apache.ddlutils.task.DatabaseToDdlTask"> > > > > driverClassName=3D"oracle.jdbc.driver.OracleDriver" > username=3D"SCHEMA" > password=3D"PASS"/> > > > > > > Thanks in advance > Markus --=20 This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.