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.
HTH Bob. flap...@free.fr writes: > Hello, > > I'm using the base-2.14.1 and I'm trying to import a genepix GAL file. > > I've add in the file named "extended-properties.xml", this : > > <property > name="genename" > title="GeneName" > description="The identifier for the Gene name" > column="genename" > type="string" > length="300" > /> > > I was planning to have the gene name linked to the reporter. > > But i got this error : > > net.sf.basedb.core.BaseException: Data truncation: Data too long for column > 'genename' at row 1 on line 4506 in file 'placenta_cto_sghm.gal': 6 11 4 > IMAGE:1473... > at > net.sf.basedb.plugins.AbstractFlatFileImporter.doImport(AbstractFlatFileImporter.java:731) > at > net.sf.basedb.plugins.AbstractFlatFileImporter.run(AbstractFlatFileImporter.java:468) > at > net.sf.basedb.core.PluginExecutionRequest.invoke(PluginExecutionRequest.java:110) > at > net.sf.basedb.core.InternalJobQueue$JobRunner.run(InternalJobQueue.java:506) > at java.lang.Thread.run(Thread.java:619) > Caused by: net.sf.basedb.core.BaseException: Data truncation: Data too long > for column 'genename' at row 1 > at net.sf.basedb.core.BasicBatcher.flushUpdate(BasicBatcher.java:453) > at net.sf.basedb.core.BasicBatcher.update(BasicBatcher.java:352) > at > net.sf.basedb.plugins.ReporterFlatFileImporter.handleData(ReporterFlatFileImporter.java:656) > at > net.sf.basedb.plugins.AbstractFlatFileImporter.doImport(AbstractFlatFileImporter.java:699) > ... 4 more > Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for > column 'genename' at row 1 > at > com.mysql.jdbc.ServerPreparedStatement.executeBatchSerially(ServerPreparedStatement.java:814) > at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1452) > at > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723) > at net.sf.basedb.core.BasicBatcher.flushUpdate(BasicBatcher.java:445) > ... 7 more > > the data for the column genename on line 4506 is almost the shorter of the > GAL file ... I can delete/switch/mix the line, the import is stopping on > this line every time. > > Where's the problem ? > > Thanks for the help, > > 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 -- Bob MacCallum | VectorBase Developer | Kafatos/Christophides Groups | Division of Cell and Molecular Biology | Imperial College London | Phone +442075941945 | Email r.maccal...@imperial.ac.uk ------------------------------------------------------------------------------ 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