-
1. Re: Jboss Forum 2.2.1-SP3 Bug?
unibrew Jul 26, 2006 7:19 AM (in response to johncena)I have deployed the same packages as you and they are working fine. I can think off two possibilities why this may happen to you.
First is that ForumsModule MBean didn't deploy properly. You should see this in log at the end of starting AS.
Second is that you may have some errors in your database. Like having topics without any posts what could cause similar efect.
Nevertheless, check AS logs. It should give you some clue. -
2. Re: Jboss Forum 2.2.1-SP3 Bug?
johncena Jul 27, 2006 12:10 AM (in response to johncena)I did re-install and re-deployment of Jboss-forum... Now I can view the Dummy Demo Cat > 2 Forums... I've tried editing the names and posted my first topic under one forum. It added successfully. But when I browsed port 8080 again and logging out as admin.. when clicked on the Forum nav link I got a blank page again.
Now i get these error messages....
12:11:46,203 WARN [JDBCExceptionReporter] SQL Error: 932, SQLState: 42000
12:11:46,204 ERROR [JDBCExceptionReporter] ORA-00932: inconsistent datatypes: expected - got CLOB
12:11:46,204 ERROR [ForumsPortlet] The portlet threw an exception
org.hibernate.exception.SQLGrammarException: could not initialize a collection: [org.jboss.portlet.forums.impl.PostImpl.attachments#6]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1926)
at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:541)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:60)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1705)
at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
at org.hibernate.collection.AbstractPersistentCollection.readSize(AbstractPersistentCollection.java:109)
at org.hibernate.collection.PersistentBag.size(PersistentBag.java:222)
at org.jboss.portlet.forums.ForumsPortlet.fillShowTopicContext(ForumsPortlet.java:5851)
at org.jboss.portlet.forums.ForumsPortlet.doView(ForumsPortlet.java:425)
at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:230)
at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:217)
at org.jboss.portlet.JBossPortlet.render(JBossPortlet.java:360)
at org.jboss.portal.portlet.PortletContainer.invokeRender(PortletContainer.java:521)
at org.jboss.portal.portlet.PortletContainer.dispatch(PortletContainer.java:433)
at org.jboss.portal.server.app.ComponentInvocation.dispatch(ComponentInvocation.java:79)
at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:140)
at org.jboss.portal.core.aspects.component.TransactionInterceptor.invoke(TransactionInterceptor.java:72)
at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
at org.jboss.portal.core.aspects.component.HeaderInterceptor.invoke(HeaderInterceptor.java:50)
at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
at org.jboss.portal.server.aspects.component.NavigationInterceptor.invoke(NavigationInterceptor.java:76)
at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
at org.jboss.portal.server.aspects.component.CacheInterceptor.invoke(CacheInterceptor.java:167)
at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
at org.jboss.portal.server.aspects.component.ModesInterceptor.invoke(ModesInterceptor.java:88)
at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
at org.jboss.portal.server.aspects.component.WindowStatesInterceptor.invoke(WindowStatesInterceptor.java:87)
at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
at org.jboss.portal.bridge.BridgeInterceptor.invoke(BridgeInterceptor.java:49)
at org.jboss.portal.server.app.ComponentInterceptor.invoke(ComponentInterceptor.java:38)
at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
at org.jboss.portal.portlet.aspects.component.SessionPostDispatchInterceptor.invoke(SessionPostDispatchInterceptor.java:65)
How come? at first it was working fine... and now it doesn't? Is there something wrong with the configuration? is there a way to make it stable? .. on first timers point of view, what are the loopholes? -
3. Re: Jboss Forum 2.2.1-SP3 Bug?
unibrew Jul 27, 2006 6:45 AM (in response to johncena)I should ask about database first. From the log I see that you are using Oracle database. There is an issue with mapping hibernate objects with CLOB. The solution is to change datatype in tables JBP_FORUMS_POSTS, JBP_FORUMS_ATTACHMENTS from clob to varchar2 and it should work.