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: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
