species multimedia mybatis mapper throwing exceptions

16083
Reporter: mdoering
Assignee: mdoering
Type: Bug
Summary: species multimedia mybatis mapper throwing exceptions
Priority: Blocker
Resolution: Fixed
Status: Closed
Created: 2014-07-10 10:03:47.05
Updated: 2014-07-10 13:32:43.997
Resolved: 2014-07-10 13:32:43.975
        
Description: http://www.gbif-uat.org/species/4342

{noformat}
ERROR [2014-07-10 10:00:18,758+0200] [http-bio-8080-exec-154] org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/b_checklistbank-ws].[default]: Servlet.service() for servlet [default] in context with path [/b_checklistbank-ws] threw exception
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: java.lang.IllegalArgumentException: Illegal pattern character 'p'
### The error may exist in org/gbif/checklistbank/service/mybatis/MultimediaMapper.xml
### The error may involve org.gbif.checklistbank.service.mybatis.MultimediaMapper.listByNubUsage-Inline
### The error occurred while setting parameters
### SQL: SELECT i.usage_fk,      i.id, i.url, i.link, i.title, i.description, i.license, i.creator, i.created, i.publisher      FROM      image i       JOIN nub_rel rel ON i.usage_fk=rel.usage_fk       WHERE rel.nub_fk=?     ORDER BY i.rating, i.id      LIMIT ? OFFSET ?
### Cause: java.lang.IllegalArgumentException: Illegal pattern character 'p'
{noformat}
]]>
    

Author: mdoering@gbif.org
Created: 2014-07-10 13:32:38.909
Updated: 2014-07-10 13:32:38.909
        
Happened due a dateparser bug that was throwing exceptions for non dates like "Unknown date" instead of returning a failed parse.
Fixed in https://github.com/gbif/parsers/commit/d8314c4ab64660233b1940c6e0fb6600a70ad9bc