Hi devs,
We need to decide how to handle the charset/encoding in XWiki. We have 3
options:
1. Leave it as it is. The default is ISO-8859-1, and the admin has to
make sure the JVM is started with the correct -Dfile.encoding param. If
another encoding is needed, it has to be changed in 4 places (web.xml,
xwiki.cfg, -Dfile.encoding, database charset+collation)
2. Force it to always be UTF-8, overriding the file.enconding setting.
This ensures internationalization, as UTF-8 works with any language. And
I think it is a safe move, as any modern system supports UTF-8 (given
that XWiki requires java 5, we can assume it will be in a modern
system). This has the advantage that the code will be simpler, as we
don't have to check and switch encodings, but has the disadvantage that
mysql has to be manually configured for UTF-8, as by default it comes in
latin1.
3. Keep it configurable, but by only specifying it in one place
(xwiki.cfg or web.xml), and enforcing that encoding in the JVM (by
overriding file.encoding). The default should be UTF-8.
Here's my +1 for option 2, -1 for option 1, and 0 for option 3.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
Hi all,
i am currently working on integrating a recommendation system into a
xwiki installation.
What I need to build a statistical model is to register every link to
another wiki page
a particular user clicks.
e.g. zorn is on Main.WebHome and clicks on SandBox.WebHome
After investigating this a little, I think one way to do this would be
to extend the XWikiStats
subsystem.
I would prefer to write simple plugin however, if such hooks already
exist, but I couldn't find
any.
Thanks,
Hans-Peter
Hi,
I'd like to propose moving the title field in edit mode to the side,
in the information panel, just before the Parent field. We have
already parent and tags there and the title would fit nicely there.
The main reason for this is to clear up more space for the main
content edition. It's also more consistent to put the page metadata
together on the side (which has a lot of unused space).
Here's my +1
Thanks
-Vincent
PS: It really helps in Toucan skin to have that title field on the
side since a major theme of Toucan is to simplify the interface and
provide more space for the content.
Hello,
we started to approach the embedding of the MathTran service for
XWiki embedding of formulae. A very very rudimentary version (based
on velocity macros) is at
http://i2geo.net/bin/Sandbox/Formulae
Clearly, we'll make a macro instead of a velo-macro, so that syntax
has some input freedom (you can't put \cdot currently!), and maybe
even a plugin (so as to cache at the xwiki-server-side the resulting
image.
That'll work well, with baseline, for html-rendered pages.
That will be somewhat ugly, however, for print (gross resolution,
nothing vector).
Having discussed with a MathTran developer we realized it would be
easy to actually use the DVI to embed for print provided the fonts
are installed on the XWiki server (they are freely available).
This file is very small and is in the picture's metadata. The DVI
format is basically a vector format that says where to place which
characters.
Is it possible to extend the print features for some islands so that
it "draws on a Graphics2D" ? That would solve our approach without
the requirement of any installation on the XWiki-server except for
the fonts.
thanks in advance
paul
Hi,
There is a functionality in xwiki user registration module where we can send
a validation key to the user account.
For the xwiki registration tab as provided two settings:
1. from email address
2. smpt server address from which the mail is to be sent.
Now most smtp server require some authentication on their machine, that
would mostly be the user name/password of the from email address.
There are no such settings provided under the registration tab.
My question is are additional settings needed, if yes then how can one add
the same.
Currently i get the following error when trying to send the validation mail:
com.xpn.xwiki.XWikiException: Error number 10006 in 10: Could not send mail
to server 199.237.236.4 port 25 error code 530 (530 authentication required
for relay (#5.7.1)
)
at com.xpn.xwiki.XWiki.sendMessage(XWiki.java:2981)
at com.xpn.xwiki.XWiki.sendMessage(XWiki.java:3015)
at com.xpn.xwiki.XWiki.sendValidationEmail(XWiki.java:2924)
at com.xpn.xwiki.XWiki.sendValidationEmail(XWiki.java:2883)
at com.xpn.xwiki.XWiki.createUser(XWiki.java:2833)
at com.xpn.xwiki.web.RegisterAction.action(RegisterAction.java:41)
at com.xpn.xwiki.web.XWikiAction.execute(XWikiAction.java:187)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
>From stack trace it does seem that authentication is required.
So how can I get that done via xwiki.
Please help.
Thanks
Sachin
-----
http://www.assembla.com/wiki/show/sachin_mittal about me:
--
View this message in context: http://www.nabble.com/Registering-user-using-a-validation-mail-%28problem%2…
Sent from the XWiki- Dev mailing list archive at Nabble.com.
To add on,
I am using Oracle 10g R1 and hibernate 3.2.5ga. This problem seem to lie on the hibernate portion where it failed to resolve the alias in the GROUP BY clauses
in WatchSheets.WebHome document.The code causing this problem is as follow:
.....
#set($tagsQuery = "select elements(entry.tags), count(*) from XWiki.FeedEntryClass asentry, XWikiDocument as doc, BaseObject as obj wheredoc.fullName=obj.name and obj.id=entry.id and doc.web='${doc.space}' group bycol_0_0_)
#set($tagList = $xwiki.search($tagsQuery))
How can i resolve this issue or else the watch application could not be used.
Regards,
Colin
----- Original Message ----
From: Colin Tay <lee_hyeok(a)yahoo.com.sg>
To: XWiki Developers <devs(a)xwiki.org>
Sent: Wednesday, 13 February 2008 8:55:02
Subject: [xwiki-devs] Problem loading Watch.Reader Application
Hi all,
I am using the Xwiki enterprise 1.2.1 with rev 7495.
After importing the watch application successfully, i opened the http://localhost:8080/xwiki/bin/view/watch/reader url.
An exception occured, may i know what causes this?
The errors are as follows:
Thanks in adv,
Colin
2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] WARN util.JDBCExceptionReporter - SQL Error: 932, SQLState: 42000
2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] ERROR util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expected - got CLOB
2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] ERROR xwiki.XWiki - Unhandled exception on the server
com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with sql select entry.feedname, sum(1-coalesce(entry.read,0)) from XWiki.FeedEntryClass as entry, XWikiDocument as doc, BaseObject as obj where doc.fullName=obj.name and obj.id=entry.id and doc.web='Watch' group by entry.feedname
Wrapped Exception: could not execute query
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1809)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735)
at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420)
at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Wrapped Exception:
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got CLOB
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
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 com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1801)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735)
at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420)
at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] WARN util.JDBCExceptionReporter - SQL Error: 904, SQLState: 42000
2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] ERROR util.JDBCExceptionReporter - ORA-00904: "COL_0_0_": invalid identifier
2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] ERROR xwiki.XWiki - Unhandled exception on the server
com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with sql select elements(entry.tags), count(*) from XWiki.FeedEntryClass as entry, XWikiDocument as doc, BaseObject as obj where doc.fullName=obj.name and obj.id=entry.id and doc.web='Watch' group by col_0_0_
Wrapped Exception: could not execute query
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1809)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735)
at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420)
at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Wrapped Exception:
java.sql.SQLException: ORA-00904: "COL_0_0_": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
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 com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1801)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735)
at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420)
at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Real people. Real questions. Real answers. Share what you know.
-----Inline Attachment Follows-----
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
__________________________________________________________________
Yahoo! Singapore Answers
Real people. Real questions. Real answers. Share what you know at http://answers.yahoo.com.sg
Hi all,
I am using the Xwiki enterprise 1.2.1 with rev 7495.
After importing the watch application successfully, i opened the http://localhost:8080/xwiki/bin/view/watch/reader url.
An exception occured, may i know what causes this?
The errors are as follows:
Thanks in adv,
Colin
2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] WARN util.JDBCExceptionReporter - SQL Error: 932, SQLState: 42000
2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] ERROR util.JDBCExceptionReporter - ORA-00932: inconsistent datatypes: expected - got CLOB
2008-02-13 08:59:33,359 [http://localhost:8080/xwiki/XWikiService] [P1-17] ERROR xwiki.XWiki - Unhandled exception on the server
com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with sql select entry.feedname, sum(1-coalesce(entry.read,0)) from XWiki.FeedEntryClass as entry, XWikiDocument as doc, BaseObject as obj where doc.fullName=obj.name and obj.id=entry.id and doc.web='Watch' group by entry.feedname
Wrapped Exception: could not execute query
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1809)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735)
at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420)
at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Wrapped Exception:
java.sql.SQLException: ORA-00932: inconsistent datatypes: expected - got CLOB
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
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 com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1801)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735)
at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420)
at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] WARN util.JDBCExceptionReporter - SQL Error: 904, SQLState: 42000
2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] ERROR util.JDBCExceptionReporter - ORA-00904: "COL_0_0_": invalid identifier
2008-02-13 08:59:33,718 [http://localhost:8080/xwiki/XWikiService] [P1-18] ERROR xwiki.XWiki - Unhandled exception on the server
com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with sql select elements(entry.tags), count(*) from XWiki.FeedEntryClass as entry, XWikiDocument as doc, BaseObject as obj where doc.fullName=obj.name and obj.id=entry.id and doc.web='Watch' group by col_0_0_
Wrapped Exception: could not execute query
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1809)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735)
at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420)
at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
Wrapped Exception:
java.sql.SQLException: ORA-00904: "COL_0_0_": invalid identifier
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:623)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:181)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:420)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:896)
at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:452)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:986)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2929)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2220)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
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 com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1801)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1746)
at com.xpn.xwiki.store.XWikiHibernateStore.search(XWikiHibernateStore.java:1735)
at com.xpn.xwiki.store.XWikiCacheStore.search(XWikiCacheStore.java:420)
at com.xpn.xwiki.gwt.api.server.XWikiServiceImpl.customQuery(XWikiServiceImpl.java:740)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:281)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:167)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:616)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:830)
at com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:117)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplicationHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1565)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1517)
at org.mortbay.http.HttpServer.service(HttpServer.java:954)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:983)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
______________________________________________________________________
Search, browse and book your hotels and flights through Yahoo! Travel.
http://sg.travel.yahoo.com