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

Reply via email to