Dear list,

Please see below.

Tim

From: Ivailo Stoyanov istoyanov@pensoftonline.net Date: January 29, 2010 5:02:13 PM GMT+01:00 To: Tim Robertson trobertson@gbif.org Subject: Re: [ZooKeys] GBIF IPT Thanks, Tim, for the help.

I have imported the data, but when I tried to update the metadata with a new title and description I get the following error:

==================================================== Data Access Failure

Hibernate flushing: Could not execute JDBC batch update; uncategorized SQLException for SQL [update resource set created=?, creator_fk=?, geo_coverage_max_latitude=?, geo_coverage_max_longitude=?, geo_coverage_min_latitude=?, geo_coverage_min_longitude=?, guid=?, meta_contact_email=?, meta_contact_name=?, meta_description=?, meta_link=?, meta_location_latitude=?, meta_location_longitude=?, meta_title=?, meta_uddi_id=?, modified=?, modifier_fk=?, status=?, type=?, jdbc_driver_class=?, jdbc_password=?, jdbc_url=?, jdbc_user=?, last_upload_event_fk=?, num_accepted=?, num_classes=?, num_families=?, num_genera=?, num_kingdoms=?, num_orders=?, num_phyla=?, num_species=?, num_synonyms=?, num_taxa=?, num_terminal_taxa=?, bbox_max_latitude=?, bbox_max_longitude=?, bbox_min_latitude=?, bbox_min_longitude=?, feature_hash=?, num_countries=?, num_regions=?, num_terminal_regions=?, rec_with_altitude=?, rec_with_coordinates=?, rec_with_country=?, rec_with_date=? where id=?]; SQL state [90005]; error code [90005]; Value too long for column META_TITLE: 'Western Palaearctic Ectoedemia (Zimmermannia) Hering and Ectoedemia Busck s. str. (Lepidoptera: Nepticulidae): five new species... [90005-104]; nested exception is org.h2.jdbc.JdbcSQLException: Value too long for column META_TITLE: 'Western Palaearctic Ectoedemia (Zimmermannia) Hering and Ectoedemia Busck s. str. (Lepidoptera: Nepticulidae): five new species... [90005-104] ====================================================

Could you help with this?

All the best, Ivailo -- I. Stoyanov Editorial Secretary

ZOOKEYS -- http://pensoftonline.net/zookeys BIORISK -- http://pensoftonline.net/biorisk