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