### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'LICENSE_HERF' in 'field list' ### The error may exist in class path resource [com/digitalpublishing/sci/mapper/PArticleMapper.xml] ### The error may involve com.digitalpublishing.sci.dao.PArticleMapper.selectByDoi-Inline ### The error occurred while setting parameters ### SQL: select ID, TITLE, JOURNAL_TITLE, JOURNAL_ID, PUBLISHER_ID, DOI, ORIG_DOI, VOLUME_CODE, ISSUE_CODE, ELOCATIONID, LANGUAGE, SPAGE, EPAGE, SORT, ADVANCE_PUB, FLA, TLA, ISSN, PUB_YEAR, PUB_MONTH, PURCHASE_DATE, ACCEPT_DATE, PUB_DATE, ORG_LINK, PDF_PATH, CREATE_DATE, UPDATE_DATE, RESOURSE_ID, CITED_COUNT, INTRO, ACK, APPENDIX, OPENACCESS, INTEREST, CONTRIBUTIONS, BASE_ID, INCLUDE_LANGUAGE, ORDERAUTHORS, RATING, TRIAL_END_DATE, GRAPH,PRICE,RETRACTION, STATUS, AUTHORIZATION_DATE,COLLAB,SPECIAL_ID,LICENSE_TYPE,LICENSE_HERF,LICENSE_CONTENT from pub_article where CASE WHEN EXISTS ( SELECT ID FROM pub_article WHERE DOI = ? AND LANGUAGE = ? ) THEN LANGUAGE = ? ELSE LANGUAGE = ? END AND DOI = ? LIMIT 1 ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'LICENSE_HERF' in 'field list' ; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'LICENSE_HERF' in 'field list'