Could someone using Oracle confirm that search is not working on
oracle (I'm not using oracle)?
Just want to check if it's a config issue for Tamer or a more general
one.
Thanks
-Vincent
On Aug 5, 2008, at 1:44 PM, Tamer Sezgin wrote:
Hi,
I installed xwiki on WebSphere/Oracle environment.
But search function does not work properly.. It just responds as
"Error 500: ".
In the log file I saw the following exceptions (I didn't paste all of
the stack trace)
It seems Lucene does not work, and there is also a datatypes related
ORACLE problem.. I'm not sure whether they are related..
Any idea?
thanks,
Tamer
PS:
XWiki version is : 1.4.1.10194
2008-08-01 21:13:51,373 [Lucene index rebuilder thread] [Lucene Index
Rebuilder] ERROR lucene.IndexRebuilder - Error in lucene
rebuild thread
java.lang.NullPointerException
at com.ibm.ws.webcontainer.srt.SRTServletRequest
$SRTServletRequestHelper.access$1600(SRTServletRequest.java:2232)
at
com
.ibm
.ws
.webcontainer
.srt.SRTServletRequest.getQueryString(SRTServletRequest.java:1207)
at
com
.xpn
.xwiki
.web.XWikiServletRequest.getQueryString(XWikiServletRequest.java:193)
at
com
.xpn
.xwiki
.render
.DefaultXWikiRenderingEngine.getKey(DefaultXWikiRenderingEngine.java:
335)
....
2008-08-01 21:14:18,646 [Lucene index updating thread] [Lucene Index
Updater] ERROR lucene.ObjectData - error extracting
fulltext for do
cument xwiki:Main.AllDocs.default.objects
java.lang.ClassCastException: com.xpn.xwiki.objects.StringProperty
incompatible with com.xpn.xwiki.objects.ListProperty
at
com
.xpn.xwiki.objects.BaseCollection.getListValue(BaseCollection.java:
327)
.....
2008-08-01 21:13:50,795 [
http://wiki.test/bin/view/Main/] [Default :
0] ERROR impl.StatsUtil - Failed to search visit
object in t
he database from cookie
com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while
searching documents with sql from VisitStats as obj where obj.cookie=?
and obj.e
ndDate > ? order by obj.endDate desc
Wrapped Exception: could not execute query
at
com
.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:
2121)
at
com
.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:
2056)
.....
Wrapped Exception:
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected -
got CLOB
at
oracle
.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:
288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)