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
  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 | 5 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 | 3 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 6 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