invalid URLs in IMS bring down entire query

13935
Reporter: mdoering
Assignee: mdoering
Type: Feedback
Summary: invalid URLs in IMS bring down entire query
Priority: Major
Resolution: Fixed
Status: Closed
Created: 2013-09-16 20:36:02.044
Updated: 2013-09-16 20:47:07.102
Resolved: 2013-09-16 20:47:07.063
        
Description: the URITypeHandler should not throw exceptions but set the field to null instead.

ERROR [2013-09-16 20:30:54,621+0200] [http-bio-8080-exec-11] org.gbif.registry.ims.AugmenterImpl: Failed to augment node %s with IMS information
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: java.sql.SQLException: java.net.URISyntaxException: Illegal character in path at index 2: No website established
### The error may exist in org/gbif/registry/ims/ImsNodeMapper.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT p."__kp_ID" AS imsId, c.ISO2 AS country, n.Name_Full AS title, n.Name_Acronym AS abbreviation, n.URL AS homepage,   p.Member_AsOf AS participantSince, p.PublicDescription AS description,   p.zz__Modified_Timestamp__lxm AS modified,
i.Name AS institution, i.Address AS address, i.City AS city, i.ZipCode AS postalCode, i.State AS province, i.Telephone AS phone, i.Email AS email,   p.GBIFmembership, r.Region, p.MOU2012_Date AS dateSignedMOU  FROM "__Node" n   JOIN "__Participant" p
 ON n."_kf_ParticipantID" = p."__kp_ID"   JOIN "__Region" r ON p."_kf_RegionID" = r."__kp_ID"   JOIN "__Country" c ON p."_kf_CountryID" = c."__kp_ID"   JOIN "__Institution" i ON p."_kf_InstitutionID" = i."__kp_ID"  WHERE p."__kp_ID" = ?
### Cause: java.sql.SQLException: java.net.URISyntaxException: Illegal character in path at index 2: No website established]]>
    

Author: mdoering@gbif.org
Created: 2013-09-16 20:47:07.1
Updated: 2013-09-16 20:47:07.1
        
https://code.google.com/p/gbif-common-resources/source/detail?r=1721
https://code.google.com/p/gbif-labs/source/detail?r=596