org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is <openjpa-2.1.0-r422266:1071316 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Incorrect table definition; there can be only one auto column and it must be defined as a key {stmnt 1022736404 ALTER TABLE fieldlanguagesvalues ADD lang_val_id BIGINT AUTO_INCREMENT} [code=1075, state=42000]

Google Groups | Lee Daniel | 5 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Can't start openmeetings_1_9_0_r4692 under Ubuntu 10.04.3 LTS

    Google Groups | 5 years ago | Lee Daniel
    org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for transaction; nested exception is <openjpa-2.1.0-r422266:1071316 nonfatal general error> org.apache.openjpa.persistence.PersistenceException: Incorrect table definition; there can be only one auto column and it must be defined as a key {stmnt 1022736404 ALTER TABLE fieldlanguagesvalues ADD lang_val_id BIGINT AUTO_INCREMENT} [code=1075, state=42000]
  2. 0

    Error when creating EntityManager in JPA2

    Stack Overflow | 6 years ago | stuff22
    org.apache.openjpa.persistence.PersistenceException: java.lang.String incompatible with javax.sql.DataSource
  3. 0

    org.apache.openjpa.lib.jdbc.ReportingSQLException, MySQL, OpenJPA, Geronimo

    Stack Overflow | 6 years ago | AR3Y35
    org.apache.openjpa.persistence.PersistenceException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = innodb' at line 1 {stmnt 1243851750 CREATE TABLE ADMIN_USER (admin_id BIGINT NOT NULL AUTO_INCREMENT, first_name VARCHAR(255), last_name VARCHAR(255), user_name VARCHAR(255), PRIMARY KEY (admin_id)) TYPE = innodb} [code=1064, state=42000]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ServiceMix / Blueprint / JPA Integration

    Stack Overflow | 4 years ago | scubadev
    org.apache.openjpa.persistence.PersistenceException: [javax.sql.DataSource]
  6. 0

    INFORMATION_SCHEMA doesn't exists error while creating EntityManager (JPA + SPRING + H2)

    Stack Overflow | 6 years ago | Arek Wo┼║niak
    org.apache.openjpa.persistence.PersistenceException: Schema 'INFORMATION_SCHEMA' doesn't exists {SELECT SEQUENCE_SCHEMA, SEQUENCE_NAME FROM INFORMATION_SCHEMA.SEQUENCES} [code=-1, state=42Y07]

  1. MoYapro 2 times, last 8 months ago
2 unregistered visitors
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. org.apache.openjpa.lib.jdbc.ReportingSQLException

    Incorrect table definition; there can be only one auto column and it must be defined as a key {stmnt 1022736404 ALTER TABLE fieldlanguagesvalues ADD lang_val_id BIGINT AUTO_INCREMENT} [code=1075, state=42000]

    at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap()
  2. OpenJPA Aggregate Jar
    EntityManagerFactoryImpl.createEntityManager
    1. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:281)[openjpa-2.1.0.jar:2.1.0]
    2. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:265)[openjpa-2.1.0.jar:2.1.0]
    3. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$700(LoggingConnectionDecorator.java:72)[openjpa-2.1.0.jar:2.1.0]
    4. org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:975)[openjpa-2.1.0.jar:2.1.0]
    5. org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingStatement.java:136)[openjpa-2.1.0.jar:2.1.0]
    6. org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:1221)[openjpa-2.1.0.jar:2.1.0]
    7. org.apache.openjpa.jdbc.schema.SchemaTool.addColumn(SchemaTool.java:1054)[openjpa-2.1.0.jar:2.1.0]
    8. org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:503)[openjpa-2.1.0.jar:2.1.0]
    9. org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:363)[openjpa-2.1.0.jar:2.1.0]
    10. org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:340)[openjpa-2.1.0.jar:2.1.0]
    11. org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:505)[openjpa-2.1.0.jar:2.1.0]
    12. org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:456)[openjpa-2.1.0.jar:2.1.0]
    13. org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:160)[openjpa-2.1.0.jar:2.1.0]
    14. org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBrokerFactory.java:164)[openjpa-2.1.0.jar:2.1.0]
    15. org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFactory.java:122)[openjpa-2.1.0.jar:2.1.0]
    16. org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFactory.java:210)[openjpa-2.1.0.jar:2.1.0]
    17. org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBrokerFactory.java:156)[openjpa-2.1.0.jar:2.1.0]
    18. org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:227)[openjpa-2.1.0.jar:2.1.0]
    19. org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:154)[openjpa-2.1.0.jar:2.1.0]
    20. org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager(EntityManagerFactoryImpl.java:60)[openjpa-2.1.0.jar:2.1.0]
    20 frames
  3. Spring ORM
    JpaTransactionManager.doBegin
    1. org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTransaction(JpaTransactionManager.java:400)[org.springframework.orm-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    2. org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionManager.java:321)[org.springframework.orm-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    2 frames
  4. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)[org.springframework.transaction-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    3 frames
  5. Spring AOP
    Cglib2AopProxy$DynamicAdvisedInterceptor.intercept
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    2. org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    2 frames
  6. org.openmeetings.app
    ScopeApplicationAdapter.appStart
    1. org.openmeetings.app.data.basic.Configurationmanagement$$EnhancerByCGLIB$$53c37128.getConfKey(<generated>)[cglib-2.2.2.jar:na]
    2. org.openmeetings.app.remote.red5.ScopeApplicationAdapter.appStart(ScopeApplicationAdapter.java:129)[openmeetings.jar:na]
    2 frames
  7. Red5
    WebScope.register
    1. org.red5.server.adapter.MultiThreadedApplicationAdapter.start(MultiThreadedApplicationAdapter.java:409)[red5.jar:na]
    2. org.red5.server.adapter.ApplicationAdapter.start(ApplicationAdapter.java:55)[red5.jar:na]
    3. org.red5.server.Scope.start(Scope.java:1171)[red5.jar:na]
    4. org.red5.server.Scope.init(Scope.java:906)[red5.jar:na]
    5. org.red5.server.WebScope.register(WebScope.java:208)[red5.jar:na]
    5 frames
  8. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.6.0_26]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)[na:1.6.0_26]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)[na:1.6.0_26]
    4. java.lang.reflect.Method.invoke(Method.java:597)[na:1.6.0_26]
    4 frames
  9. Spring Beans
    DefaultListableBeanFactory.preInstantiateSingletons
    1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1544)[org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1485)[org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)[org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    4. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)[org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    5. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)[org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    6. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)[org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    7. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)[org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    8. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)[org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    9. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:192)[org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    10. org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:585)[org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    10 frames
  10. Spring Context
    AbstractApplicationContext.refresh
    1. org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)[org.springframework.context-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    2. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)[org.springframework.context-3.0.6.RELEASE.jar:3.0.6.RELEASE]
    2 frames
  11. tomcatplugin
    TomcatLoader$1.run
    1. org.red5.server.tomcat.TomcatLoader$1.run(TomcatLoader.java:577)[tomcatplugin-1.1.jar:na]
    1 frame