@Id
 @Column(name = "some_id", unique = true, nullable = false)
 @GeneratedValue(strategy = GenerationType.AUTO)
 private Long id;
 

  Internal Exception: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
Error Code: 1205
Call: UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?
       bind => [50, SEQ_GEN]
Query: DataModifyQuery(name="SEQUENCE" sql="UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?")]       
 

 <persistence-unit name="xxxxService" transaction-type="RESOURCE_LOCAL">
    <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
    <class>...</class>
    <class>...</class>
    <class>...</class>
    <properties> .... </properties>
   </persistence-unit> 
 

                 <bean id="jpaDialect" class="org.springframework.orm.jpa.vendor.EclipseLinkJpaDialect" />
	    
		<bean class="org.springframework.orm.jpa.JpaTransactionManager"
			id="transactionManager">
			<property name="entityManagerFactory" ref="entityManagerFactory" />
			<property name="jpaDialect" ref="jpaDialect" />
		</bean>
		<bean id="jpaVendorAdapter"
			class="org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter">
			<property name="showSql" value="true" />
			<property name="generateDdl" value="true" />
		<property name="databasePlatform" value="org.eclipse.persistence.platform.database.MySQLPlatform" />
		</bean>
		<bean
			class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean"
			id="entityManagerFactory">
			<property name="jpaVendorAdapter" ref="jpaVendorAdapter" />
			<property name="jpaDialect" ref="jpaDialect" />
			<property name="persistenceUnitName" value="xxxxService" />
		</bean>		
		
		<tx:annotation-driven transaction-manager="transactionManager" />
		
		<bean class="org.springframework.orm.jpa.support.PersistenceAnnotationBeanPostProcessor"/>
 

         @Transactional
	public void saveSumthg(Sumthg sumthg) throws Exception{
		someDAO.saveSumthg(sumthg);
	}

       @Transactional(propagation = Propagation.SUPPORTS, readOnly = true)
	public List<Sumthg> findActiveSumthgs(String username) {
		List<Sumthg> sumthgs = someDAO.findActiveSumthgs(username);
		return sumthgs ;
	}
 

...
<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
<jta-data-source>jdbc/project</jta-data-source>
<properties>
   <property name="eclipselink.connection-pool.sequence.nonJtaDataSource" value="jdbc/project-sequencing"/>
   ...
</properties>
...