ant-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 27739] New: - sql insert statement fails
Date Wed, 17 Mar 2004 13:05:08 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=27739>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=27739

sql insert statement fails

           Summary: sql insert statement fails
           Product: Ant
           Version: 1.6.1
          Platform: Other
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Core tasks
        AssignedTo: dev@ant.apache.org
        ReportedBy: ElmarKeck@hotmail.com


executing the following statement in an external sql file fails

INSERT INTO mandator (mandator_id, mandator_name, description) VALUES (0,'--','');

whereas 

INSERT INTO mandator (mandator_id, mandator_name, description) VALUES (0,'test','');

or 

INSERT INTO mandator (mandator_id, mandator_name, description) VALUES
(0,'-'||'-','');

works well! 

[sql] Failed to execute:   INSERT INTO mandator (mandator_id, mandator_name,
description) VALUES (0,'--','');
[sql] java.sql.SQLException: ORA-00911: invalid character

tested with Oracle9i 8.1.7.1  and 9.2.0.3 JDBC Drivers

ant section:

<target name="create_db" >
  <sql
    driver="oracle.jdbc.driver.OracleDriver"
    url="jdbc:oracle:thin:@london:1521:oracle"
    userid="test"
    password="test"
    onerror="continue"
    src="${app.home}/database/create_db_user/test.sql">
    <classpath>
	  <pathelement location="${app.home}/lib/classes12.zip"/>
    </classpath>
  </sql>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org


Mime
View raw message