Hi Solomax, since thread is too long can you post the fix on wiki..
2011/12/13 luo angela <angela....@gmail.com>
> Yeah！ It's work.After i drop and recreate the database,the system is
> installed successfully.
> THanks! solomax!
>
> On 12月13日, 下午1时53分, solomax <solomax...@gmail.com> wrote:
> > 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
> >
> > ...
> >
> > 阅读更多 >>
>
> --
> 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.
>
>
--
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.
