>>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

Reply via email to