commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 26638] New: - [sql] MySqlBuilder class not converting LONGVARBINARY
Date Tue, 03 Feb 2004 17:00:14 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=26638>.
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=26638

[sql] MySqlBuilder class not converting LONGVARBINARY

           Summary: [sql] MySqlBuilder class not converting LONGVARBINARY
           Product: Commons
           Version: 1.0 Alpha
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: Sandbox
        AssignedTo: commons-dev@jakarta.apache.org
        ReportedBy: gus.heck@olin.edu


It turns out that if you have a torque generated schema with the type
LONGVARBINARY, that it needs to be converted to LONGBLOB or LONG VARBINARY (with
the space) or MySQL will give you a syntax error. The book I have suggests
MEDIUMBLOB == LONG VARBINARY instead of LONGBLOB, but torque generates
LONGBLOB... so perhaps it should just match that.

MySqlBuilder is not doing any conversion right now and needs to do something.

This has been observed by me with MySQL 4.0.14 and Connector/J 3.0.9. Discussion
on the ojb-dev list indicates that it shows up for MySQL 3 too. I am running a
CVS checout of commons-sql that is only a couple weeks old.

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


Mime
View raw message