Bug 18930 - SQLExec Task does not work well with MS SQL Server
Summary: SQLExec Task does not work well with MS SQL Server
Status: NEW
Alias: None
Product: Ant
Classification: Unclassified
Component: Core tasks (show other bugs)
Version: 1.5.3
Hardware: Other other
: P3 enhancement (vote)
Target Milestone: ---
Assignee: Ant Notifications List
Depends on:
Reported: 2003-04-11 02:45 UTC by brett.knights
Modified: 2008-11-24 03:57 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description brett.knights 2003-04-11 02:45:27 UTC
There are a number of problems with using the SQLExec task Ant 1.5.3

1)the delimiter test is case-sensitive. It's difficult to control whether a 
delimiter is entered as go, Go or GO. This can be addressed easily in Ant by 
changing .equals in line 469 to .equalsIgnoreCase.

2)The batch is submitted with all line breaks removed. My main use for SQLExec 
is loading stored procedures. If I use SQLExec as is then the db's version of 
the sproc has no linefeeds. This makes it difficult to view the file when, on 
occasion, I want to compare the current db version of the sproc with a local 
version. This can be addressed easily by replacing line 454 with:
 sql += "\n" + line;

I don't believe any statements should suffer from this since all you this 
actually does is restore the line breaks that were in the source.

If you make that change then the lines 457 through 462 become redundant.
Comment 1 Stefan Bodewig 2003-04-11 13:39:18 UTC
part two is a duplicate of bug 10719 and is fixed for Ant 1.6.
Comment 2 Hunter Peress 2006-11-07 19:20:27 UTC