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)

Reply via email to