ERROR [SchemaExport] schema export unsuccessful
anders3 Apr 27, 2007 12:32 AMMigration from 2.6-BETA1
When I start 2.6-CR1 for the first time it will create tables....
I have some data in table jbp_group that I want to keep
I therefore dropped all tables except jbp_group (groups)
This makes problems
It seems like Portal/Hibernate cannot accept that some tables are there and others not.
So I have to drop all tables or none ?
/Anders
ATTACHED: LOG
java.sql.SQLException: You cannot commit during a managed transaction!
at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:543)
.....
18:35:45,917 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
18:35:45,918 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_object_node' doesn't exist
18:35:46,043 WARN [ServiceController] Problem starting service portal:container=PortalObject
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2147)
.....
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2144)
... 139 more
18:35:46,097 WARN [ServiceController] Problem starting service portal:service=Hibernate,type=Portlet
org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=hilda.local/46, BranchQual=, localId=46]; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=hilda.local/46, BranchQual=, localId=46])
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
at org.jboss.portal.jems.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:229)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
at org.jboss.portal.jems.as.system.AbstractJBossService.start(AbstractJBossService.java:73)
at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)