I'm using HA-JDBC with JPA EclipseLink and I've got this exception:
java.sql.SQLException: Table CHANNEL_VALIDITY does not contain a primary key - this is required by synchronization strategy net.sf.hajdbc.sync.DifferentialSynchronizationStrategy
at net.sf.hajdbc.sync.DifferentialSynchronizationStrategy.synchronize(DifferentialSynchronizationStrategy.java:146)
Exception is very clear but Table CHANNEL_VALIDITY cannot have a primary key since it is a CollectionTable of Embeddable and EclipseLink does not allow to have a primary key in it
I'm asking if there is a way to specify a different sinchronization strategy for each table or there is a different strategy that is better to use with jpa
Regards
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I'm using HA-JDBC with JPA EclipseLink and I've got this exception:
java.sql.SQLException: Table CHANNEL_VALIDITY does not contain a primary key - this is required by synchronization strategy net.sf.hajdbc.sync.DifferentialSynchronizationStrategy
at net.sf.hajdbc.sync.DifferentialSynchronizationStrategy.synchronize(DifferentialSynchronizationStrategy.java:146)
Exception is very clear but Table CHANNEL_VALIDITY cannot have a primary key since it is a CollectionTable of Embeddable and EclipseLink does not allow to have a primary key in it
I'm asking if there is a way to specify a different sinchronization strategy for each table or there is a different strategy that is better to use with jpa
Regards