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.