Marcus Christie created AIRAVATA-3408:
-----------------------------------------
Summary: increase user_friendly_description length
Key: AIRAVATA-3408
URL: https://issues.apache.org/jira/browse/AIRAVATA-3408
Project: Airavata
Issue Type: Improvement
Components: Application Catalog
Reporter: Marcus Christie
Assignee: Marcus Christie
Getting this error with long descriptions:
{code:sql}
Caused by: org.apache.openjpa.persistence.PersistenceException: (conn:10655875)
Data too long for column 'USER_FRIENDLY_DESC' at row 1 {prepstmnt 1342301087
UPDATE APPLICATION_INPUT
SET USER_FRIENDLY_DESC = ?
WHERE INTERFACE_ID = ? AND INPUT_KEY = ?
[params=(String) Select the type of collection: If all the genomes in your
collection..., (String) Database-Indexing_77cf2460-ba00-4eed-96ca-c62b1e1243c5,
(String) Project Type]} [code=1406, state=22001]
at
org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:5250)
at
org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:5210)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:134)
at
org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:75)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:146)
at
org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:80)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:102)
at
org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:90)
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:554)
at
org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:111)
at
org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:61)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:108)
at
org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:81)
at
org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:757)
at
org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:146)
... 20 common frames omitted
{code}
Maybe should just turn this into a CLOB
--
This message was sent by Atlassian Jira
(v8.3.4#803005)