org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: [com.atlassian.crowd.model.user.InternalUser#6357021]; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' at row 1

atlassian.com | 4 months ago
  1. 0

    Login Fails Due to java.sql.SQLException: Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' - Atlassian Documentation

    atlassian.com | 4 months ago
    org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: [com.atlassian.crowd.model.user.InternalUser#6357021]; uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' at row 1
  2. 0

    java.sql.SQLException: You can't specify target table 'user_details' for update in FROM clause

    Stack Overflow | 2 years ago | Sejal Rudani
    org.hibernate.exception.GenericJDBCException: could not execute update query at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
  3. 0

    Incorrect string value as I try to store a file as longblob into a mysql database

    Stack Overflow | 2 years ago | user1883212
    java.sql.SQLException: Incorrect string value: '\xA2\x04\x02(\xA0\x00...' for column 'value' at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    failover with mysql and spring-data-jpa

    Stack Overflow | 2 years ago | JayabalanAaron
    java.sql.SQLException: Connection is read-only. Queries leading to data modification are not allowed
  6. 0

    Why this org.hibernate.exception.GenericJDBCException: could not update occurs only on the remote (virtual) server

    Stack Overflow | 5 years ago | Dark Star1
    javax.servlet.ServletException: java.lang.Exception: org.hibernate.exception.GenericJDBCException: could not update: [fr.model.employee.Employee#510]
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Incorrect string value: '\xF2\xB9\x84\xAE\xEF\xBF...' for column 'external_id' at row 1

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    PreparedStatement.executeUpdate
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1078)
    2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
    3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
    4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
    5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
    6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2815)
    7. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
    8. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
    9. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2375)
    10. com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2359)
    10 frames
  3. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeUpdate
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
    1 frame
  4. net.sf.hibernate
    CriteriaImpl.uniqueResult
    1. net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
    2. net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:661)
    3. net.sf.hibernate.persister.EntityPersister.update(EntityPersister.java:621)
    4. net.sf.hibernate.impl.ScheduledUpdate.execute(ScheduledUpdate.java:52)
    5. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2464)
    6. net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2450)
    7. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2408)
    8. net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1836)
    9. net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:3667)
    10. net.sf.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:238)
    11. net.sf.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:385)
    11 frames
  5. com.atlassian.crowd
    HibernateUserDao$3.doInHibernate
    1. com.atlassian.crowd.embedded.hibernate2.HibernateUserDao$3.doInHibernate(HibernateUserDao.java:492)
    1 frame
  6. Hibernate
    HibernateTemplate.execute
    1. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
    2. org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337)
    2 frames
  7. com.atlassian.crowd
    HibernateUserDao.findByExternalId
    1. com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindUserByExternalId(HibernateUserDao.java:487)
    2. com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.internalFindByExternalId(HibernateUserDao.java:459)
    3. com.atlassian.crowd.embedded.hibernate2.HibernateUserDao.findByExternalId(HibernateUserDao.java:435)
    3 frames
  8. com.atlassian.confluence
    CachedCrowdUserDao.findByExternalId
    1. com.atlassian.confluence.user.crowd.CachedCrowdUserDao.findByExternalId(CachedCrowdUserDao.java:164)
    1 frame
  9. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor262.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    3. java.lang.reflect.Method.invoke(Unknown Source)
    3 frames
  10. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  11. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    1 frame
  12. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  13. com.sun.proxy
    $Proxy35.findByExternalId
    1. com.sun.proxy.$Proxy35.findByExternalId(Unknown Source)
    1 frame
  14. com.atlassian.crowd
    DbCachingRemoteChangeOperations.updateUsers
    1. com.atlassian.crowd.directory.AbstractInternalDirectory.findUserByExternalId(AbstractInternalDirectory.java:156)
    2. com.atlassian.crowd.directory.DbCachingRemoteChangeOperations.updateUsers(DbCachingRemoteChangeOperations.java:221)
    2 frames
  15. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  16. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  17. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    1 frame
  18. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  19. com.atlassian.crowd
    DirectoryPollerJobBean.executeInternal
    1. com.atlassian.crowd.directory.$Proxy1569.updateUsers(Unknown Source)
    2. com.atlassian.crowd.directory.DirectoryCacheImplUsingChangeOperations.addOrUpdateCachedUsers(DirectoryCacheImplUsingChangeOperations.java:59)
    3. com.atlassian.crowd.directory.ldap.cache.RemoteDirectoryCacheRefresher.synchroniseAllUsers(RemoteDirectoryCacheRefresher.java:68)
    4. com.atlassian.crowd.directory.ldap.cache.AbstractCacheRefresher.synchroniseAll(AbstractCacheRefresher.java:78)
    5. com.atlassian.crowd.directory.DbCachingRemoteDirectory.synchroniseCache(DbCachingRemoteDirectory.java:998)
    6. com.atlassian.crowd.manager.directory.DirectorySynchroniserImpl.synchronise(DirectorySynchroniserImpl.java:75)
    7. com.atlassian.crowd.directory.DbCachingDirectoryPoller.pollChanges(DbCachingDirectoryPoller.java:50)
    8. com.atlassian.crowd.manager.directory.monitor.poller.DirectoryPollerJobBean.executeInternal(DirectoryPollerJobBean.java:29)
    8 frames
  20. Spring Context Support
    QuartzJobBean.execute
    1. org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
    1 frame
  21. quartz
    JobRunShell.run
    1. org.quartz.core.JobRunShell.run(JobRunShell.java:199)
    1 frame
  22. com.atlassian.confluence
    ConfluenceQuartzThreadPool$1.run
    1. com.atlassian.confluence.schedule.quartz.ConfluenceQuartzThreadPool$1.run(ConfluenceQuartzThreadPool.java:20)
    1 frame
  23. quartz
    SimpleThreadPool$WorkerThread.run
    1. org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
    1 frame