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