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=28745>.
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=28745

SQL Task treatment of "--" is incorrect





------- Additional Comments From [EMAIL PROTECTED]  2004-05-04 09:59 -------
The problem with comments is more complex than people think.
SQLServer (at least older releases) does not allow new lines on the SQL 
statement passed by JDBC and it does not allow comments either.

So, for that DB you need to clean all this things up.
Oracle has a different set of behaviours. What was implemented was what was
considered safer for most of them.

I see that now people are asking for more DBspecific behaviour. Maybe we need 
to start thinking on a pluggable architecture for <sql/> that would allow
user access to the special features of a particular DB.

To start with, it could define the correct default values for the different 
settings that make the best way to send the SQL to the particular DB.

Does it make sense? The pluggins could autodetect based of the driver being 
used.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to