java.sql.SQLException: Table EV_AUTHDB.ACCESSLOG does not contain a primary key - this is required by synchronization strategy net.sf.hajdbc.sync.DifferentialSynchronizationStrategy

ha-jdbc | scottyedinb | 6 months ago
  1. 0

    Trouble with synchronization

    ha-jdbc | 6 months ago | scottyedinb
    java.sql.SQLException: Table EV_AUTHDB.ACCESSLOG does not contain a primary key - this is required by synchronization strategy net.sf.hajdbc.sync.DifferentialSynchronizationStrategy
  2. 0

    HA-JDBC 3.0.0 activate does not synchronize

    ha-jdbc | 3 years ago | justincranford
    java.sql.SQLException: mysqldump: Got error: 1045: Access denied for user 'root@10.20.0.150'@'10.20.0.150' (using password: YES) when trying to connect
  3. 0

    DifferentialSynchronizationStrategy does not work with a JPA CollectionTable

    ha-jdbc | 9 months ago | bedinsky
    java.sql.SQLException: Table CHANNEL_VALIDITY does not contain a primary key - this is required by synchronization strategy net.sf.hajdbc.sync.DifferentialSynchronizationStrategy
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Problem with load data from oracle to excel

    Oracle Community | 7 years ago | 710783
    java.sql.SQLException: [Microsoft][ODBC Excel Driver] Deleting data in a linked table is not supported by this ISAM.
  6. 0

    Getting java.sql.SQLException: ORA-02291 for a nullable foreign key

    Stack Overflow | 2 years ago
    java.sql.SQLException: ORA-02291 when I try to insert a NULL value to a column which has a foreign key constraint to another table. By definition this column is NULLABLE in the child table and the column it is referencing in the parent is the PK of that table. I am confused, why I am getting this exception. Any help with this will be greatly appreciated. Here is the exception and DDL Exception org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; violated - parent key not found

    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

      Table EV_AUTHDB.ACCESSLOG does not contain a primary key - this is required by synchronization strategy net.sf.hajdbc.sync.DifferentialSynchronizationStrategy

      at net.sf.hajdbc.sync.DifferentialSynchronizationStrategy.synchronize()
    2. net.sf.hajdbc
      DatabaseClusterImpl.activate
      1. net.sf.hajdbc.sync.DifferentialSynchronizationStrategy.synchronize(DifferentialSynchronizationStrategy.java:146)
      2. net.sf.hajdbc.sync.PerTableSynchronizationStrategy.synchronize(PerTableSynchronizationStrategy.java:74)
      3. net.sf.hajdbc.sync.DifferentialSynchronizationStrategy.synchronize(DifferentialSynchronizationStrategy.java:94)
      4. net.sf.hajdbc.sql.DatabaseClusterImpl.activate(DatabaseClusterImpl.java:885)
      5. net.sf.hajdbc.sql.DatabaseClusterImpl.activate(DatabaseClusterImpl.java:156)
      6. net.sf.hajdbc.sql.DatabaseClusterImpl.activate(DatabaseClusterImpl.java:134)
      6 frames
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:497)
      4 frames
    4. net.sf.hajdbc
      AnnotatedMBean.invoke
      1. net.sf.hajdbc.management.AnnotatedMBean.invoke(AnnotatedMBean.java:214)
      1 frame
    5. Java RT
      Thread.run
      1. com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:819)
      2. com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:801)
      3. javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1471)
      4. javax.management.remote.rmi.RMIConnectionImpl.access$300(RMIConnectionImpl.java:76)
      5. javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1312)
      6. javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1404)
      7. javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:832)
      8. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      9. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      10. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      11. java.lang.reflect.Method.invoke(Method.java:497)
      12. sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:323)
      13. sun.rmi.transport.Transport$1.run(Transport.java:200)
      14. sun.rmi.transport.Transport$1.run(Transport.java:197)
      15. java.security.AccessController.doPrivileged(Native Method)
      16. sun.rmi.transport.Transport.serviceCall(Transport.java:196)
      17. sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:568)
      18. sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run0(TCPTransport.java:826)
      19. sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.lambda$run$256(TCPTransport.java:683)
      20. java.security.AccessController.doPrivileged(Native Method)
      21. sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:682)
      22. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      23. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      24. java.lang.Thread.run(Thread.java:745)
      24 frames