Mailing-List: contact dev-help@ant.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Ant Developers List" <dev@ant.apache.org>
Date: 16 Jul 2003 13:11:52 -0000
Message-ID: <20030716131152.9227.qmail@nagoya.betaversion.org>
From: bugzilla@apache.org
To: dev@ant.apache.org
Cc: 
Subject: DO NOT REPLY [Bug 21594]  -
    Result Sets and Errors are getting lost in SQL task with multiple
 statements

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21594>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=21594

Result Sets and Errors are getting lost in SQL task with multiple statements


------- Additional Comments From antoine@apache.org  2003-07-16 13:11 -------
without ; the output is like that :
$ ant -f sql.xml
Buildfile: sql.xml

sql:
      [sql] Executing commands
      [sql] Failed to execute: 
      [sql] SELECT * FROM TableA
      [sql] UPDATE TableA SET  ColumnA = 'NoValue' WHERE Columnb = 'No Match'
      [sql] INSERT INTO TableA (ColumnA, ColumnB) VALUES (NULL, NULL)
      [sql] SELECT * FROM TableA
      [sql] go

BUILD FAILED

C:\dev\testant\sql.xml:10: java.sql.SQLException: [DJ0X820J]Cannot insert the 
value NULL into column 'ColumnA', table 'test.dbo.TableA'; column does not allow 
nulls. INSERT fails.

Total time: 1 second

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