11 Replies Latest reply: Nov 21, 2006 7:14 PM by Ryszard Kozmik RSS

Jboss forum and Oracle 9i

mmontoni Newbie

Hello,

I am using Jboss portal 2.4 and the jboss forum that comes with it. Previously I was using it with MySQL 5 and it worked fine. Now I need to use it with Oracle 9i and I am having some issues.

I can add a new forum and a new topic but I cannot post a reply. I am having the following error:

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:5855)
 at org.jboss.portlet.forums.ForumsPortlet.doView(ForumsPortlet.java:422)
 at org.jboss.portlet.JBossPortlet.doDispatch(JBossPortlet.java:254)
.....


Any ideas of what I am doing wrong?

Thanks!
Mariella.

  • 1. Re: Jboss forum and Oracle 9i
    Ryszard Kozmik Master

    Hello

    No, you do everything perfectly. Just while deploying on Oracle couple of table columns are wrongly created. To repair this you must modify tables JBP_FORUMS_POSTS and JBP_FORUMS_ATTACHMENTS, change clob field datatype to varchar2 and it should do the thing.

    Cheers
    ------------------------
    Ryszard Kozmik
    JBoss Forums
    JBoss Labs Team

  • 2. Re: Jboss forum and Oracle 9i
    mmontoni Newbie

    It worked!

    Thank you sooo very much!

  • 3. Re: Jboss forum and Oracle 9i
    Vinutha GR Newbie

    Hi mmontoni.

    I am trying to integrate JBoss Forums to JBoss Portal 2.4 and have lot of issues. Can I know which versionof JBoss Fourm you have used and also the if you can guide me through how to go about.

    Thanks in advance

  • 4. Re: Jboss forum and Oracle 9i
    Ryszard Kozmik Master

    Hi

    Please write what issues you are experiencing and what versions are you using so that we could help you :-)

    Cheers
    ------------------------
    Ryszard Kozmik
    JBoss Forums
    JBoss Labs Team

  • 5. Re: Jboss forum and Oracle 9i
    Vinutha GR Newbie

    Hi

    I am using the JBOSS Portal2.4 but it doenst come with JBoss Forums..

    Any help regarding this

  • 6. Re: Jboss forum and Oracle 9i
    Ryszard Kozmik Master

    Hello

    You have two choices. Old Portal Forums are available in Portal 2.4 svn repository so you can build them from there. Second choice is using JBoss Forums packaged for JBoss Portal 2.4.

    Regards
    -----------------------
    Ryszard Kozmik
    JBoss Forums Lead
    JBoss Labs Team

  • 7. Re: Jboss forum and Oracle 9i
    Vinutha GR Newbie

    Hi

    It would be helpful if you can give me the links.

    Thanks

  • 8. Re: Jboss forum and Oracle 9i
    Ryszard Kozmik Master

    Hi

    Try this package available here: http://labs.jboss.com/portal/jbossforums/downloads. You can find there also simple guide.

    Regards
    -----------------------
    Ryszard Kozmik
    JBoss Forums Lead
    JBoss Labs Team

  • 9. Re: Jboss forum and Oracle 9i
    Vinutha GR Newbie

    I am using JBoss Portal 2.4.0 bundelded version with Jboss AS 4.0.4 GA, j2sdk1.4.2_04. I am getting the following error

    org.jboss.deployment.DeploymentException: Error parsing the XML file: ; - nested throwable: (org.jboss.mx.util.JBossNotCompliantMBeanException: Error parsing the XML file: )
    at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:196)
    at org.jboss.system.ServiceController.install(ServiceController.java:226)
    at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
    at $Proxy4.install(Unknown Source)
    at org.jboss.deployment.SARDeployer.create(SARDeployer.java:249)
    at org.jboss.deployment.MainDeployer.create(MainDeployer.java:953)
    at org.jboss.deployment.MainDeployer.create(MainDeployer.java:943)
    at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:807)
    at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:771)
    at sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
    at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
    at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
    at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
    at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
    at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
    at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
    at $Proxy8.deploy(Unknown Source)
    at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
    at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
    at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
    at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
    at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)

  • 10. Re: Jboss forum and Oracle 9i
    Ryszard Kozmik Master

    Hi

    I found out that the xml cannot be parsed properly under JDK 1.4.2. I created JIRA bug issue for that http://jira.jboss.com/jira/browse/JBFORUMS-143 I'll try to resolve it ASAP.

    Thanks for reporting
    -----------------------
    Ryszard Kozmik
    JBoss Forums Lead
    JBoss Labs Team

  • 11. Re: Jboss forum and Oracle 9i
    Ryszard Kozmik Master

    Hello

    The issue (http://jira.jboss.com/jira/browse/JBFORUMS-143) has been resolved. Fix is available in svn repository and will be also included in Beta release.

    Regards
    -----------------------
    Ryszard Kozmik
    JBoss Forums Lead
    JBoss Labs Team