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
Hello
Please read the second post in this topic : http://www.jboss.com/index.html?module=bb&op=viewtopic&t=94261
Regards
-------------------
Ryszard Kozmik
JBoss Forums
JBoss Labs Team