>>Bob MacCallum wrote: >> Hi, >> >> I'm just guessing that this data type is limited to 255 characters. >> If you really need more, then "text" is probably what you want. > >Hmmm.... it shouldn't be. "text" is not an allowed value in the xml >file. The definitions in this file are passed on to Hibernate which >should select a column type that can hold at least the specified number >of characters. If this is so or not in this case I can't tell. We are >mainly using length="255" or length="65535" and they come out as >"varchar(255)" and "text" column types. Can you check that the >"genename" column is of a type that is able to hold at least 300 characters?
I've checked the mysql structure and it was a "string varchar(255)" ! Even after I've changed the xml file to : length="65535" and launch an "updatedb.sh" ... >There is also an old ticket in our trac server >(http://base.thep.lu.se/ticket/438) which is about a bug that is related >to a rather old MySQL version and a character encoding issue. I don't >know if this could be the problem. It all depends on your MySQL version >and connection settings and also on the actual data in the file. > >Also note that the this error happens during a flush operation which >means that the actual line number (4506) may not be the line with the >problematic data. The flush interval is configured by the db.batch-size >setting in base.config. The default value is 50 which means that the >data that is causing the problem can be anywhere between line 4457 and 4506. > >Hope this helps. Otherwise please post some more information regarding >your server environment (MySQL version etc.). It would also be useful >with parts of the file that is causing the problems. > >/Nicklas I've changed the type to "text" manually in the database and the import was successful. Thanks a lot for your quick replies ! Flavien ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ The BASE general discussion mailing list basedb-users@lists.sourceforge.net unsubscribe: send a mail with subject "unsubscribe" to basedb-users-requ...@lists.sourceforge.net
