- changed title to Intercept data too long for column errors when entering too long orcids
- edited description
Intercept data too long for column errors when entering too long orcids
Issue #2543
wontfix
--- The error occurred in Person.xml. --- The error occurred while applying a parameter map. --- Check the updatePerson-InlineParameterMap. --- Check the statement (update failed). --- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'orcid' at row 1 at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeUpdate(MappedStatement.java:107) at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:393) at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82) at org.bibsonomy.database.common.impl.DBSessionImpl.insert(DBSessionImpl.java:257)
Comments (15)
-
reporter -
reporter - changed milestone to 3.4
-
reporter - changed status to open
-
reporter - changed milestone to 3.5
-
reporter -
reporter - changed milestone to 3.6.0
-
reporter - changed milestone to 3.7.0
-
reporter - changed component to database
-
assigned issue to
- removed milestone
-
-
assigned issue to
-
assigned issue to
-
-
assigned issue to
-
assigned issue to
-
- removed responsible
-
-
assigned issue to
-
assigned issue to
-
- changed status to wontfix
In the current Bibsonomy version, the user is already blocked from entering ORCID IDs that are too long by corresponding input field, so it is no longer necessary to intercept the error.
-
Do we check that in the backend or JS only?
-
The formatting is only checked in JS. If the
updateOrcid
method is somehow called with an illegal orcid argument, the usual database error handling is used (since the orcid column can contain a maximum of 16 characters) and no update takes place. - Log in to comment