com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '16' for key 'PRIMARY' Error Code: 1062 Call: INSERT INTO unit (id, addr_street, addr_building, admin_email, version, addr_postcode, addr_room, addr_city, name, descr, admin_phone, winDomain, dynamicEnabled, authority_id, organization_id, aup_policy_id, alert_policy_id, image_policy_id, monitor_policy_id, audit_event_policy_id, parent_id, access_policy_id, lib_policy_id, web_policy_id, ldap_sync_policy_id, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [16, null, null, , 1, null, null, null, USER GROUP, null, null, null, false, 2, 3, 16, 16, 16, 16, 16, 15, 16, 16, 16, 16, 5] Query: WriteObjectQuery(UserGroup:16 USER GROUP)

javatalks.ru | 9 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    javatalks.ru / EJB+JPA+AspectJ, MySQLIntegrityConstraintViolationException

    javatalks.ru | 9 months ago
    com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '16' for key 'PRIMARY' Error Code: 1062 Call: INSERT INTO unit (id, addr_street, addr_building, admin_email, version, addr_postcode, addr_room, addr_city, name, descr, admin_phone, winDomain, dynamicEnabled, authority_id, organization_id, aup_policy_id, alert_policy_id, image_policy_id, monitor_policy_id, audit_event_policy_id, parent_id, access_policy_id, lib_policy_id, web_policy_id, ldap_sync_policy_id, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [16, null, null, , 1, null, null, null, USER GROUP, null, null, null, false, 2, 3, 16, 16, 16, 16, 16, 15, 16, 16, 16, 16, 5] Query: WriteObjectQuery(UserGroup:16 USER GROUP)

    Root Cause Analysis

    1. com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException

      Duplicate entry '16' for key 'PRIMARY' Error Code: 1062 Call: INSERT INTO unit (id, addr_street, addr_building, admin_email, version, addr_postcode, addr_room, addr_city, name, descr, admin_phone, winDomain, dynamicEnabled, authority_id, organization_id, aup_policy_id, alert_policy_id, image_policy_id, monitor_policy_id, audit_event_policy_id, parent_id, access_policy_id, lib_policy_id, web_policy_id, ldap_sync_policy_id, TYPE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [16, null, null, , 1, null, null, null, USER GROUP, null, null, null, false, 2, 3, 16, 16, 16, 16, 16, 15, 16, 16, 16, 16, 5] Query: WriteObjectQuery(UserGroup:16 USER GROUP)

      at org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush()
    2. EclipseLink (non-OSGi)
      EJBQueryImpl.getResultList
      1. org.eclipse.persistence.internal.jpa.EntityManagerImpl.flush(EntityManagerImpl.java:699)
      2. org.eclipse.persistence.internal.jpa.EJBQueryImpl.performPreQueryFlush(EJBQueryImpl.java:1194)
      3. org.eclipse.persistence.internal.jpa.EJBQueryImpl.executeReadQuery(EJBQueryImpl.java:404)
      4. org.eclipse.persistence.internal.jpa.EJBQueryImpl.getResultList(EJBQueryImpl.java:681)
      4 frames
    3. org.securus.application
      PropertiesBean.isDirectState
      1. org.securus.application.gui.PropertiesBean.isDirectState(PropertiesBean.java:61)
      1 frame
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    5. OpenEJB :: OSGi :: Core
      BaseEjbProxyHandler.invoke
      1. org.apache.openejb.core.interceptor.ReflectionInvocationContext$Invocation.invoke(ReflectionInvocationContext.java:158)
      2. org.apache.openejb.core.interceptor.ReflectionInvocationContext.proceed(ReflectionInvocationContext.java:141)
      3. org.apache.openejb.core.interceptor.InterceptorStack.invoke(InterceptorStack.java:67)
      4. org.apache.openejb.core.stateless.StatelessContainer._invoke(StatelessContainer.java:211)
      5. org.apache.openejb.core.stateless.StatelessContainer.invoke(StatelessContainer.java:169)
      6. org.apache.openejb.core.ivm.EjbObjectProxyHandler.businessMethod(EjbObjectProxyHandler.java:217)
      7. org.apache.openejb.core.ivm.EjbObjectProxyHandler._invoke(EjbObjectProxyHandler.java:77)
      8. org.apache.openejb.core.ivm.BaseEjbProxyHandler.invoke(BaseEjbProxyHandler.java:286)
      8 frames