1 Reply Latest reply on Jun 16, 2007 4:09 PM by Ryszard Kozmik

    Error when trying to read message from Oracle 9i

    Mitch De Felice Newbie

      Environment Information
      ----------------------------------
      OS-System: Windows 2000 5.0,x86
      Java VM: Java HotSpot(TM) Server VM 1.5.0_02-b09,Sun Microsystems Inc
      Release ID: JBoss [Zion] 4.0.5.GA (build: CVSTag=Branch_4_0 date=200611211702)
      Jboss Portal-2.4.1-CR2
      JBoss Forums 1.0.0 GA for JBoss Portal 2.4
      Oracle, version: Oracle9i Enterprise Edition Release 9.2.0.1.0
      Oracle JDBC driver, version: 10.2.0.1.0

      When I try to read a topic that was posted, I receive the following Oracle database error:

      [2007-06-16 14:10:13,157,JDBCExceptionReporter] WARN SQL Error: 932, SQLState: 42000
      [2007-06-16 14:10:13,157,JDBCExceptionReporter] ERROR ORA-00932: inconsistent datatypes: expected - got CLOB

      [2007-06-16 14:10:13,157,ForumsModuleImpl] ERROR Cannot find posts
      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.listIgnoreQueryCache(Loader.java:2028)
      at org.hibernate.loader.Loader.list(Loader.java:2023)
      at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:393)
      at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
      at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
      at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
      at org.jboss.portlet.forums.impl.ForumsModuleImpl.findPostsByIdsFetchAttachmentsAndPosters(ForumsModuleImpl.java:1236)
      at org.jboss.portlet.forums.impl.ForumsModuleImpl.findPostsByIdsAscFetchAttachmentsAndPosters(ForumsModuleImpl.java:1257)
      at org.jboss.portlet.forums.ui.view.ViewTopic.execute(ViewTopic.java:282)
      at org.jboss.portlet.forums.ui.view.ViewTopic.isInitialized(ViewTopic.java:179)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      Could you please advise to possible solution