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: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


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

Reply via email to