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 16422] New: - sql task modifies string input data
Date Sat, 25 Jan 2003 16:35:41 GMT
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=16422>.
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=16422

sql task modifies string input data

           Summary: sql task modifies string input data
           Product: Ant
           Version: 1.5.1
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: Major
          Priority: Other
         Component: Core tasks
        AssignedTo: ant-dev@jakarta.apache.org
        ReportedBy: koeppe@rbg.informatik.tu-darmstadt.de


When you execute the attached createtables.sql with the ant sql task,
the string data for field "passwd" to insert gets corrupted.
On the first INSERT line, all is ok, but the 2 to 5 INSERT is sent modified to 
the DBMS: A space is appended to the passwd strings.

A "SELECT * FROM mitarbeiter where passwd LIKE '% ';" returns
rows 2, 3, 4, and 5.

This is in both cases, if you set delimitertype="row", so that all gets one 
transaction, or if you don't set it.

I use Postgres as DBMS with the JDBC driver  jdbc7.1-1.2.jar.

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


Mime
View raw message