Table definition has been changed in 1.9
You need to drop old Database, or specify different DB in your
persistense.xml
On Dec 13, 12:40 pm, luo angela <angela....@gmail.com> wrote:
> Different error.
> [ERROR] [Launcher:/openmeetings]
> org.openmeetings.app.remote.red5.ScopeApplicationAdapter - [appStart]
> 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]
> at
> org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionMan
> ager.java:
> 382) ~[org.springframework.orm-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.
> getTransaction(AbstractPlatformTransactionManager.java:
> 371) ~[org.springframework.transaction-3.0.6.RELEASE.jar:
> 3.0.6.RELEASE]
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.create
> TransactionIfNecessary(TransactionAspectSupport.java:
> 335) ~[org.springframework.transaction-3.0.6.RELEASE.jar:
> 3.0.6.RELEASE]
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(T
> ransactionInterceptor.java:
> 105) ~[org.springframework.transaction-3.0.6.RELEASE.jar:
> 3.0.6.RELEASE]
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Reflec
> tiveMethodInvocation.java:
> 172) ~[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.springframework.aop.framework.Cglib2AopProxy
> $DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
> ~[org.springframework.aop-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.openmeetings.app.data.basic.Configurationmanagement$
> $EnhancerByCGLIB$$53c37128.getConfKey(<generated>)
> ~[cglib-2.2.2.jar:na]
> at
> org.openmeetings.app.remote.red5.ScopeApplicationAdapter.appStart(ScopeAppl
> icationAdapter.java:
> 129) ~[openmeetings.jar:na]
> at
> org.red5.server.adapter.MultiThreadedApplicationAdapter.start(MultiThreaded
> ApplicationAdapter.java:
> 409) [red5.jar:na]
> at
> org.red5.server.adapter.ApplicationAdapter.start(ApplicationAdapter.java:
> 55) [red5.jar:na]
> at org.red5.server.Scope.start(Scope.java:1171) [red5.jar:na]
> at org.red5.server.Scope.init(Scope.java:906) [red5.jar:na]
> at org.red5.server.WebScope.register(WebScope.java:208)
> [red5.jar:na]
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> ~[na:1.6.0_26]
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
> 39) ~[na:1.6.0_26]
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImp
> l.java:
> 25) ~[na:1.6.0_26]
> at java.lang.reflect.Method.invoke(Method.java:597) ~[na:
> 1.6.0_26]
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactor
> y.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:
> 1544) [org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactor
> y.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:
> 1485) [org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactor
> y.initializeBean(AbstractAutowireCapableBeanFactory.java:
> 1417) [org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactor
> y.doCreateBean(AbstractAutowireCapableBeanFactory.java:
> 519) [org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactor
> y.createBean(AbstractAutowireCapableBeanFactory.java:
> 456) [org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractBeanFactory
> $1.getObject(AbstractBeanFactory.java:293)
> [org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getS
> ingleton(DefaultSingletonBeanRegistry.java:
> 222) [org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(Abs
> tractBeanFactory.java:
> 290) [org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(Abstr
> actBeanFactory.java:
> 192) [org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preIns
> tantiateSingletons(DefaultListableBeanFactory.java:
> 585) [org.springframework.beans-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.context.support.AbstractApplicationContext.finishBeanFa
> ctoryInitialization(AbstractApplicationContext.java:
> 895) [org.springframework.context-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.context.support.AbstractApplicationContext.refresh(Abst
> ractApplicationContext.java:
> 425) [org.springframework.context-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at org.red5.server.tomcat.TomcatLoader$1.run(TomcatLoader.java:
> 577) [tomcatplugin-1.1.jar:na]
> Caused by: 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]
> at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:558)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:456)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBr
> okerFactory.java:
> 160) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.synchronizeMappings(JDBCBr
> okerFactory.java:
> 164) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.kernel.JDBCBrokerFactory.newBrokerImpl(JDBCBrokerFa
> ctory.java:
> 122) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.AbstractBrokerFactory.newBroker(AbstractBrokerFac
> tory.java:
> 210) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.kernel.DelegatingBrokerFactory.newBroker(DelegatingBroke
> rFactory.java:
> 156) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager
> (EntityManagerFactoryImpl.java:
> 227) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager
> (EntityManagerFactoryImpl.java:
> 154) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.persistence.EntityManagerFactoryImpl.createEntityManager
> (EntityManagerFactoryImpl.java:
> 60) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.springframework.orm.jpa.JpaTransactionManager.createEntityManagerForTra
> nsaction(JpaTransactionManager.java:
> 400) ~[org.springframework.orm-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> at
> org.springframework.orm.jpa.JpaTransactionManager.doBegin(JpaTransactionMan
> ager.java:
> 321) ~[org.springframework.orm-3.0.6.RELEASE.jar:3.0.6.RELEASE]
> ... 29 common frames omitted
> Caused by: 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(LoggingConnecti
> onDecorator.java:
> 281) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnecti
> onDecorator.java:
> 265) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access
> $700(LoggingConnectionDecorator.java:72) ~[openjpa-2.1.0.jar:2.1.0]
> at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator
> $LoggingConnection
> $LoggingStatement.executeUpdate(LoggingConnectionDecorator.java:975)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.lib.jdbc.DelegatingStatement.executeUpdate(DelegatingSta
> tement.java:
> 136) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.executeSQL(SchemaTool.java:
> 1221) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.addColumn(SchemaTool.java:
> 1054) ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:503)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.add(SchemaTool.java:363)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.schema.SchemaTool.run(SchemaTool.java:340)
> ~[openjpa-2.1.0.jar:2.1.0]
> at
> org.apache.openjpa.jdbc.meta.MappingTool.record(MappingTool.java:505)
> ~[openjpa-2.1.0.jar:2.1.0]
> ... 40 common frames omitted
> DEBUG 12-13 13:35:59.108 MeetingReminderJob.java 14538 16
> org.openmeetings.app.quartz.scheduler.MeetingReminderJob
> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-3]
> - MeetingReminderJob.execute
> DEBUG 12-13 13:35:59.411 Sessionmanagement.java 14841 453
> org.openmeetings.app.data.basic.Sessionmanagement
> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-1]
> - ****** clearSessionTable:
> ERROR 12-13 13:36:00.115 RecordingDaoImpl.java 15545 98
> org.openmeetings.app.data.record.dao.RecordingDaoImpl
> [org.springframework.scheduling.quartz.SchedulerFactoryBean#0_Worker-2]
> - getRecordingsByRoom
> org.apache.openjpa.persistence.PersistenceException: Unknown column
> 't7.allowRecording' in 'field list' {prepstmnt 1773392968 SELECT
> t0.recording_id, t0.comment_field, t0.deleted, t0.duration, t0.name,
> t1.user_id, t1.activatehash, t2.adresses_id, t2.additionalname,
> t2.comment_field, t2.deleted, t2.email, t2.fax, t2.phone,
> t2.starttime, t3.state_id, t3.deleted, t3.name, t3.starttime,
> t3.updatetime, t2.street, t2.town,...
>
> read more »
--
You received this message because you are subscribed to the Google Groups
"OpenMeetings User" group.
To post to this group, send email to openmeetings-user@googlegroups.com.
To unsubscribe from this group, send email to
openmeetings-user+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/openmeetings-user?hl=en.
