[gatein-issues] [JBoss JIRA] (GTNPORTAL-3284) Errors in saving long access-token for some social networks

[Marek Posolda (JIRA)]

     [ https://issues.jboss.org/browse/GTNPORTAL-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Marek Posolda updated GTNPORTAL-3284:
-------------------------------------

              Status: Pull Request Sent  (was: Open)
    Git Pull Request: https://github.com/gatein/gatein-portal/pull/683

    
> Errors in saving long access-token for some social networks
> -----------------------------------------------------------
>
>                 Key: GTNPORTAL-3284
>                 URL: https://issues.jboss.org/browse/GTNPORTAL-3284
>             Project: GateIn Portal
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>    Affects Versions: 3.6.3.Final
>            Reporter: Marek Posolda
>            Assignee: Marek Posolda
>             Fix For: 3.7.0.Final
>
>
> In some cases, it could happen that during binding of user to some social network (Facebook/Google/Twitter), the binding is not successful because of the fact that access token or refresh token is too long and DB throws error because of size limit of particular column (H2 has default limit of 255 characters per column)
> The exception stacktrace could look like this:
> {code}
> 12:06:50,595 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/127.0.0.1:8080-3) SQL Error: 22001, SQLState: 22001
> 12:06:50,595 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-/127.0.0.1:8080-3) Value too long for column "ATTR_VALUE VARCHAR(255)": "STRINGDECODE('VvjdI6prHvZXN6CG95jWIpkPLS0i6WMtitYVNeE8TRIfI3y+sCOxxJRqKIP9iCojWCajhup0QTro\nUe0YrgTbhKQbH7fMLEYOWKgtTNDt2omE5A0g... (259)"; SQL statement:
> insert into jbid_io_attr_text_values (TEXT_ATTR_VALUE_ID, ATTR_VALUE) values (?, ?) [22001-168]
> 12:06:50,597 INFO [org.exoplatform.services.organization.idm.UserProfileDAOImpl] (http-/127.0.0.1:8080-3) Identity operation error: : org.hibernate.exception.DataException: could not execute statement
>     at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:134)
>     at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
>     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)
>     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)
>     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136)
>     at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:58)
>     at org.hibernate.persister.collection.AbstractCollectionPersister.insertRows(AbstractCollectionPersister.java:1474)
>     at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:86)
>     at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
>     at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354)
>     at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:278)
>     at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:328)
>     at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:62)
>     at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1205)
>     at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1655)
>     at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
>     at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.getAttributes(HibernateIdentityStoreImpl.java:2108) [picketlink-idm-hibernate-1.4.3.Final-redhat-2.jar:1.4.3.Final-redhat-2]
>     at org.picketlink.idm.impl.repository.WrapperIdentityStoreRepository.getAttributes(WrapperIdentityStoreRepository.java:392) [picketlink-idm-core-1.4.3.Final-redhat-2.jar:1.4.3.Final-redhat-2]
>     at org.picketlink.idm.impl.api.session.managers.AttributesManagerImpl.getAttributes(AttributesManagerImpl.java:194) [picketlink-idm-core-1.4.3.Final-redhat-2.jar:1.4.3.Final-redhat-2]
>     at org.picketlink.idm.impl.api.session.managers.AttributesManagerImpl.updateAttributes(AttributesManagerImpl.java:255) [picketlink-idm-core-1.4.3.Final-redhat-2.jar:1.4.3.Final-redhat-2]
>     at org.picketlink.idm.impl.api.session.managers.AttributesManagerImpl.updateAttributes(AttributesManagerImpl.java:280) [picketlink-idm-core-1.4.3.Final-redhat-2.jar:1.4.3.Final-redhat-2]
>     at org.exoplatform.services.organization.idm.UserProfileDAOImpl.setProfile(UserProfileDAOImpl.java:259) [exo.portal.component.identity-3.6.3.Final-redhat-4.jar:3.6.3.Final-redhat-4]
>     at org.exoplatform.services.organization.idm.UserProfileDAOImpl.saveUserProfile(UserProfileDAOImpl.java:97) [exo.portal.component.identity-3.6.3.Final-redhat-4.jar:3.6.3.Final-redhat-4]
>     at org.gatein.security.oauth.data.SocialNetworkServiceImpl.updateOAuthInfo(SocialNetworkServiceImpl.java:136) [exo.portal.component.web.oauth-common-3.6.3.Final-redhat-4.jar:3.6.3.Final-redhat-4]
>     at org.gatein.security.oauth.web.OAuthLinkAccountFilter.doFilter(OAuthLinkAccountFilter.java:91) [exo.portal.component.web.oauth-web-3.6.3.Final-redhat-4.jar:3.6.3.Final-redhat-4]
>     at org.gatein.sso.integration.SSODelegateFilter$SSOFilterChain.doFilter(SSODelegateFilter.java:119) [sso-integration-1.3.4.Final-redhat-2.jar:1.3.4.Final-redhat-2] 
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira