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