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
